Hi - I have a 50 sheet, 9-week report that I want to deliver each week so it shows the current week and all previous weeks. (I open each sheet via an add-in user menu) I have counters for each week in cells A6 through A104. There is an integer for the current week in E4. The code below should do what I need but I do not know where is the best place to put the code.
Thanks in advance.Please Login or Register to view this content.
Bookmarks