Paste Column After Last Column With Data

[gav0101]

Hello All.

Each day I calculate the previous days metrics in workbook one. I'm working on a macro to then copy the calculated metrics from workbook one into workbook two and paste the data in the next available empty column.

1. Copy cells E3 to F262 in workbook one.
2. Paste the data starting in the first empty column and row 3. If cells A3 to U3 have data, I want to paste the new data from V3 to W262.
3. This is the code I have been trying.

Please Login or Register  to view this content.

Any help would be appreciated.

[rylo]

Hi

Try

Please Login or Register  to view this content.

rylo

[gav0101]

Thanks rylo this solves my problem