Macro - Copy and paste into last column of new worksheet

[larzep]

Hi,

Can some one help me with a macro that copies data from 4 static columns in sheet A and pastes it into last columns in sheet B?

It is for a spreadsheet that keeps records of all our budgeted sales amount.

Source Sheet 'Sales Forecast' Range = B5:E27

Copy to

Destination Sheet 'Forecast Data' starting from cell B1.

So far my macro is pretty basic which is

Please Login or Register  to view this content.

This is just one that i could only come up with as I am not a VBA wizz.

Would be great if someone can give me some assistance.

Thank you.

[NickyC]

Hi
I’m guessing your forecast sheet will be renewed every 4 months and you want to copy the latest forecast in sheet “sales Forecast” into columns to the right of the data in the "forecast data" sheet. If so, try this macro:

Please Login or Register  to view this content.

[larzep]

Hi Nicky,

Thank you so much for that . It works like a charm! Exactly what i was after. I was only stuck on the lastcol function of the paste.