R
Ruth
Hi
I have a main spreadsheet which keeps track of all staffs sickness scores
and dates of their sickness meetings. I update this every week with their
weekly sick scores so I am continually inserting extra columns into the
spreadsheet. I want to create a spreadsheet for all team leaders which only
shows their team, in this spreadsheet I want to automatically populate the
meeting dates from my main spreadsheet but as I am inserting a column each
week the cell reference is changing and I cant think of a way to follow that
column. Any suggestions?
I have a main spreadsheet which keeps track of all staffs sickness scores
and dates of their sickness meetings. I update this every week with their
weekly sick scores so I am continually inserting extra columns into the
spreadsheet. I want to create a spreadsheet for all team leaders which only
shows their team, in this spreadsheet I want to automatically populate the
meeting dates from my main spreadsheet but as I am inserting a column each
week the cell reference is changing and I cant think of a way to follow that
column. Any suggestions?