Copy and Paste based on a hlookup

[tony7262]

Hi,

I need to create a macro that will look at a user selection of the month and then copy the actuals to date that match that selection and overwrite what is in as forecast.

I have attached a two tab example of what I mean. Basically in sheet 1 there is forecast for the year on the left and then actuals for the year to date on right. On sheet 2 the user will select which is the latest month they have actuals for and then they can press a button and all the actuals will over write what is in the forecast.

Some limitations are I don't want any months that are still forecast to be overwritten and there will be further information down below so can't copy the entire column has to be limited to a certain number of rows.

Any help is greatly appreciated as I have been going around in circles on this one for a while...

Thanks,
Tony

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[tony7262]

Thanks Leo

I can follow this through and now editing it to work with the live version the only part I don't follow is the line:

.Range(.Cells(4, 18), .Cells(lastrow, 18 + mycol - 1)).Copy .Range("B4")

Are you able to just break it down (particularly the first part) so I can know what to edit it to in the live version?

Thanks again,
Tony

[LeoTaxi]

Hi Tony

Cells(4,18) is same as Range("R4"), so just change 18 to columnnumber where is first month in live version.
also change the range in application.match


Kind regards
Leo

[tony7262]

Thanks Leo, I understand now - and my problem is solved