copy range on all but 2 sheets

[tbar05]

hi,

im trying to copy all data in all sheets except sheet1 and sheet2 and copy into the next row on sheet2. the data is A7:T7 and down to the last row (there is not always data in every column but in the last row there should be data in column E)

i have the following so far but its not quite working. at the moment its only copying row A6 which is werid

any ideas?

Please Login or Register  to view this content.

any help is appreciated!

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

[tbar05]

i was so close!

thanks JBeaucaire! perfect, as usual