EXCEL: I need to populate on a weekly plan sheet in column G 1 :G 48 etc
Fantastic news! We've Found the answer you've been seeking!
Question:
EXCEL: I need to populate on a weekly plan sheet in column G:G etc the names from the roster sheet Dec, Jan etc where if the N Night or DDay next to their name on the roster sheet, it appears in the weekly plan sheet in column G corresponding with the correct date. The names on the roster sheet are in column B:B etc. And the N and D are filled in from G:AK according to shift pattern and under the date and day which are G:AK I am currently using this formula IFSDecMDDec!BDec!M"OTD",Dec!B which does populate the name, however this way doesn't automatically populate for each day. I have to manaully change M to N to change the date from the th to the th for example.
Posted Date: