Hi guys.
I've gone through a lot of other posts but could not find the answer.
I have columns A,B,C,D,E,F
with column A =today(), =today()+1, =today()+2, =today()+3 for rows 1,2,3,4 respectively.
column b has duties listed for today for client X in row 1, duties for tomorrows date in row 2 and so forth
likewise column c has duties listed for today for client Y in row 1, duties for tomorrows date in row 2 and so on
and same for columns D,E & F.
Now when I turn on the computer tomorrow I need the contents from the previous day in columns B,C,D,E & F to move up rows to correspond with the date from which they matched yesterday.
All help is greatly appreciated.
Bookmarks