Copy Row if Cell contains data within specifc range

[leahb909]

Hi

I'm currently using this code to search my sheet for the overall total column, and then copy this row onto the last row of the next sheet :

Please Login or Register  to view this content.

HOWEVER, this code copies the entire row and as a result, the table doesn't auto-populate. I need to edit the code so that it only copies between columns A:W as when I manually copy this over, the table and it's formulas do auto-populate.

Thank you in advance.

[Kaper]

Freom the description and your code seems that:

Please Login or Register  to view this content.

should do.

But on the other hand, you have a slightly different data layout in sheet 1 and sheet 2, so may be:

Please Login or Register  to view this content.

will suit you better.

[leahb909]

That worked great, thanks!