I really need help!!! lol... I'm trying to have the document update from a master sheet which I managed to do via a VLOOKUP, but when the reference date on the document is updated, and I want it only to reflect the past 5-days, rather than the whole amount of information. So at all times it will show the last 5 work days and shift the cells automatically accordingly.
So basically the dates will constantly switch back. So that way tomorrow when I have the results of Sept. 29th, Sept. 22 will no longer be depicted, and the 23rd will take it's place; the 24th will take the 23rd's place, and so on. So it would look something like this...
**5 columns each date with it's own column
****After each day, there will only be 5 columns reflecting the last 5-workdays!
Sept. 22 Sept. 23 Sept. 24 Sept. 25 Sept. 26
So basically the dates will constantly switch back. So that way tomorrow when I have the results of Sept. 29th, Sept. 22 will no longer be depicted, and the 23rd will take it's place; the 24th will take the 23rd's place, and so on. So it would look something like this...
**5 columns each date with it's own column
****After each day, there will only be 5 columns reflecting the last 5-workdays!
Sept. 22 Sept. 23 Sept. 24 Sept. 25 Sept. 26