I have a XLS with two sheets, ROTA and SETUP
Setup consists of some cells refering to the location of a file called COMPANY ROTA.XLS (EG c:/..../..../).
Setup also decifers what week it is and creates the references it would need to pull back the rota'ed hours for that week and following weeks.
ROTA sheet uses these references to build INDIRECT() calls for the data.
All works fine, very happy with it.
I want to pull the comments from COMPANY ROTA.XLS and put them in the new sheet ROTA which provides and overview of the year (Company rota has a week per sheet view... fyi)
Any ideas on how to approach this?
Steve
Setup consists of some cells refering to the location of a file called COMPANY ROTA.XLS (EG c:/..../..../).
Setup also decifers what week it is and creates the references it would need to pull back the rota'ed hours for that week and following weeks.
ROTA sheet uses these references to build INDIRECT() calls for the data.
All works fine, very happy with it.
I want to pull the comments from COMPANY ROTA.XLS and put them in the new sheet ROTA which provides and overview of the year (Company rota has a week per sheet view... fyi)
Any ideas on how to approach this?
Steve