Adjust code to copy mulitple columns & date stamp

Hi

I have the below code which works, however, I'd like to adjust it to:
1) Copy & paste columns F and H from the "Forecast vs actual" sheet instead of just column F.
2) Hard code the date stamp so it doesnt change each time I open the document.

Please Login or Register  to view this content.

Thanks in advance for your help

Jen

Replace 4 lines as below.
Sub copycolumn1()

Please Login or Register  to view this content.

Thanks for replying!
I did try inserting F1:H but this also copies over column G as well and I dont need column G, I just need it to copy columns F and H. Any other suggestions?
The date stamp works perfectly. Thanks
Jen

Above code places a date along with time stamp as well. Replace 'Now' to 'Date' if you need only date.

Another method...

Please Login or Register  to view this content.

To select only visible cells, replace relevant lines with below code.

Please Login or Register  to view this content.

Sorry column G cant be hidden it needs to be visible. Any further suggestions?
thanks

Thank You, this works great

Originally Posted by tiger01

Sorry column G cant be hidden it needs to be visible. Any further suggestions?
thanks

Please Login or Register  to view this content.