Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy values separated by a set number of columns
I have a spreadsheet set up like this:
A B C D E F 1 2/13/2009 2/14/2009 2/15/2009 2 Plan Actual Plan Actual Plan Actual 3 W X Y Z AA AB In a separate tab, I want to be able to group all the Daily Plan and Daily Actual by date. Is there a way to copy the values that are separated by two columns? In other words, copy the value for A3, then C3, and E3 for all the planned results. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy values separated by a set number of columns | Excel Discussion (Misc queries) | |||
copy values separated by a set number of columns | Excel Discussion (Misc queries) | |||
Copy values separated by a set number of columns | Excel Discussion (Misc queries) | |||
Copy columns values into separate columns | Excel Discussion (Misc queries) | |||
Copy/Paste of separated columns | Excel Discussion (Misc queries) |