Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to copy line above when XXX occurs and move on?
Hi,
I am working with a large spreadsheet and need to copy and fill data. I am hoping there is a better way than copy and pasting manually 2000 lines of data. Its pretty basic: in column A there are sub totals. I need to copy the information from the line above the subtotal to the line on the sub-total. if A3 contains the word "total" then copy B2, C2, D2 and E2 to line B3, C3, D3,and E3 respectively. Then move to the next occurrance of a cell in column A that contains the word "total" repeat the copy of the row above until reaching the end of the worksheet. Is there a way to do this? Thanks, Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Cell From Subtotal Line To Detail Line | Excel Discussion (Misc queries) | |||
Copy Source Cells to Destination Cells Only when a Change Occurs | Excel Discussion (Misc queries) | |||
Can I Move replace instead of Move copy | Excel Discussion (Misc queries) | |||
Move a value from one range to another - rounding occurs that I do not want....? | Excel Programming | |||
Move equations from line to line automatically | Excel Discussion (Misc queries) |