Offset question

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top