Hi
I have played around with a few different ways to do this and I can't get any to work well.
What I have is a 2 sheets, on sheet 2 there is a column with dates in (these could be mon-fri). On sheet one I have a list of Łamounts. With the header Amount and then for the rest of the year I have the Week Commencing (MON) dates as headers in ROW A
What I need is a macro that will work through the entire row of dates in sheet 2. Whatever the date of the Monday of that week is I need it to copy and paste the Łamount from sheet 1 and put the amount in the correct cell of the correct row.
All of the rows correspond with each other. So Sheet1!A2:A100 has its relevant data in Sheet2!A2:A100.
I have attached a very simple explanatory sheet.
I hope someone can help me.
Thanks,
Dan
Bookmarks