Pasting to area depending on date

Dear All,

Am a newbie who is also a complete VBA numptie and I am trying to write a macro that will copy some data from one page in an excel workbook and paste it to another page in the same workbook but the cell that the data is pasted to is dependent upon information in column A.

Cell B2 contains today's date, column A contains a date range from 01.01.08 to 31.12.09 and Row 2 contains a line of static data detailing bank account numbers.

I want to paste the balances on each account starting in column C on the row where the date in Column A is the same as the date in cell B2.

So today is 23.02.09 - cell B2 is 23/02/2009 and in column A, cell A425 is 23/02/2009 so the macro should paste the data starting from cell C425.

Tomorrow will be 24.02.09 so cell B2 will show 24/02/2009 and the data should be pasted into cell C426 as cell A426 shows the date 24/02/2009.

A very kind person gave me the code below but this pastes the data in C3 rather than against the correct date in column A;

Please Login or Register  to view this content.

I originally used a formula to calculate the dates in B2 and column A but have copied and paste specialed them as values in case that was affecting the macro but I am now stuck again.

Any help will be gratefully recieved.

Thanks,
DB

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I have code tags for you. Can you attach a workbook with some dummy data in?

Use the =TODAY() formula instead of NOW(), then try this codeOption Explicit

Please Login or Register  to view this content.

have you copied & pasted the code to a standard module?