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