Hi All
I have running a manpower whereabouts spreadsheet - and want to automate some bits of it.
Columns A-P are each employee details.
Column R onwards is a day by day whereabouts - each column is a day and and I have a selection of 6 codes for each whereabouts. The codes are SI, IA, SoS, D, C, L.
Column R onwards is headed by the date in the format dd-mmm-yy.
For each employee I want to automate(copy) column P to match what is in Column R onwards based on the applicable column for todays date.
Cell L1 shows todays date by =Today().
I have thought about saying P = R but I may not delete the columns for past days each day - I would have to delete columns so Column R is always today.
For instance - today Column R is headed 07-Apr-20. On 15 Apr 20 for each row I want Column P to copy what Column Z would say if I had not deleted Columns R to Y. Hope that makes sense? Prefer to use a function/formula rather than code.
Many thanks in advance
Matt
I have running a manpower whereabouts spreadsheet - and want to automate some bits of it.
Columns A-P are each employee details.
Column R onwards is a day by day whereabouts - each column is a day and and I have a selection of 6 codes for each whereabouts. The codes are SI, IA, SoS, D, C, L.
Column R onwards is headed by the date in the format dd-mmm-yy.
For each employee I want to automate(copy) column P to match what is in Column R onwards based on the applicable column for todays date.
Cell L1 shows todays date by =Today().
I have thought about saying P = R but I may not delete the columns for past days each day - I would have to delete columns so Column R is always today.
For instance - today Column R is headed 07-Apr-20. On 15 Apr 20 for each row I want Column P to copy what Column Z would say if I had not deleted Columns R to Y. Hope that makes sense? Prefer to use a function/formula rather than code.
Many thanks in advance
Matt