I have a workbook with sales from 2013 and last year sales from 2012. The workbook contains 52 sheets for each week in the year. I used the same workbook for 2014 but I am now trying to extract the 2013 sales and place them in the 2014's Last years sales.
So I can do it by using this function "='[2013.xlsx]Week 1'!C$15" and then drag it to every cell in that week, but to go to the next sheet copy the formula and change the Week 1 to Week 2 for 52 sheets seems like an issue to me. Any macros that may make it easier.
Thanks in advance
So I can do it by using this function "='[2013.xlsx]Week 1'!C$15" and then drag it to every cell in that week, but to go to the next sheet copy the formula and change the Week 1 to Week 2 for 52 sheets seems like an issue to me. Any macros that may make it easier.
Thanks in advance