Link individual sheet to one sheet in another workbook

I'm trying to set up two folders; one group and one individual. The
individual folder needs to link back to it's corresponding worksheet in
another workbook/folder. Is there a way to do this without having to
fomulate each cell individually? (We're talking about 35-40 pages). Thanks
for any/all suggestions

Hi
This is just a suggestion on how to start as I'm not sure if I understand correctly (what do you mean by "folders"?), but try...

For multiple files:
1)
Creating a list of the file names that you want the links to go to. Have a look at:
http://www.erlandsendata.no/english/...ldersscripting
2)
Using the indirect function to build the reference to the cell you want to link to (check out the Excel help files) & pasting it down alongside the list of file names.

Or for a single file with multiple sheets:
1)
Creating a list of sheet names that you want the links to refer to.
For this I use the macro below:

Please Login or Register  to view this content.

2)
Using the indirect function to build the reference to the cell you want to link to (check out the Excel help files) & pasting it down alongside the list of sheet names.


hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...