Linking cells to several other workbooks and worksheets

W

webb_justin

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
 

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

Similar Threads

Linking a several workbooks and worksheets 2
Dynamic links to other sheets 2
How do I link a cell in a workbook? 1
2 dimensional date sort 2
List all link cell to other workbooks 1
Excel Formula to add network file link to each month 1
Link to workbooks 2
vba to copy data from sale receipt to next available column in aninventory worksheet 0

Top