Hi
I am trying to consolidate information from 12 workbooks, each with 12
worksheets (jan - dec) into one workbook (also split by month). I am
linking the cells but typing the following:
=[leisureclub1.xls]January!A1
=[leisureclub1.xls]January!A2
=[leisureclub1.xls]January!A3
=[leisureclub2.xls]January!A1
=[leisureclub2.xls]January!A2
and so on. This is very time consuming. Is it possible to have the
worksheet reference (January!) read from a cell in my consolidated
sheet to save me having to copy the link to the cells over and over i.e
= [liesureclub1.xls]"cell B7"!A1
= [liesureclub1.xls]"cell B7"!A2
= [liesureclub1.xls]"cell B7"!A3
I hope this makes sence. I think i have confused myself!
Webby