Small Paul
Board Regular
- Joined
- Jun 28, 2018
- Messages
- 118
Hi
Any help with VBA on this would be appreciated.
I have a workbook, z:\promotional and marketing\product performance\weekly data\cacs.xls which I download each week.
Firstly, I need to Copy cells A2 : last active cell in column R
I then need to Paste Values into z:\promotional and marketing\product performance\cacs history.xls at the bottom of the existing data (presently row 866)
If you could help I would be appreciated.
Thanks
Small Paul.
Any help with VBA on this would be appreciated.

I have a workbook, z:\promotional and marketing\product performance\weekly data\cacs.xls which I download each week.
Firstly, I need to Copy cells A2 : last active cell in column R
I then need to Paste Values into z:\promotional and marketing\product performance\cacs history.xls at the bottom of the existing data (presently row 866)
If you could help I would be appreciated.
Thanks
Small Paul.