Hi
I am trying to work out how to run a macro wheras data from the first (weekly) workbook is placed into the second (monthly) workbook but in a different location every week for a full calender month. Then start over again.
Attached sheets from both workbooks.
weekly: cells C1:G138 copied to
monthly: cells C1:G138 for week1 and then to cells H1:L138 the following week and so forth.
I was thinking along the lines of
If text in Cell C1 go to cell H1 etc.
I'm thinking it's not possible with one macro but I still need help even if it can only be done using one!!!
Thanks again in anticipation to you gurus!!!
Bookmarks