I have attached a sheet that i am working with.
Say i have 5 depots each that have this sheet which they put there information, and they will be creating a new sheet each week to put the weekly data onto.
I would then have a master sheet that would grab the data from each of the 5 depots sheets and will have all the information in one place (saving the whole copy and paste from each report.)
This is simple enough to do if this was for just one week.
What i would like to do to save the time of having to (CTRL+F) "replace" Week 1 to Week 2.
Is the a VBA or some sort of automatic macro that would change this for me.
for example if i have week 41 in A2 all the formulas would have the correct file path and would end with week 41 and on new week i changed A2 to week 42 it would then change end of the formula to week 42 and this would then update the report accordingly?
Is this at all possible or am i trying to pull of a bit more than excel can chew.
Thanks for any help in advance.
Bookmarks