Hi all,
I'm trying to create a single Excel file that links to other files that reference their own sheets.
This would be simple enough I think except that I am trying to have all the information contained in one file to show the amount of working.
So 'New file' would have sheet links to 'File A', 'File B', 'File C' etc and A, B, C etc would have their own sheets, formulas and so on.
Other than actually putting each and every sheet onto 'New file', I've not found a way to do this, if it is even possible. The linked files have around 13 sheets each and there's a lot of them so having everything possible sheet seems rather clunky.
Thanks!
I'm trying to create a single Excel file that links to other files that reference their own sheets.
This would be simple enough I think except that I am trying to have all the information contained in one file to show the amount of working.
So 'New file' would have sheet links to 'File A', 'File B', 'File C' etc and A, B, C etc would have their own sheets, formulas and so on.
Other than actually putting each and every sheet onto 'New file', I've not found a way to do this, if it is even possible. The linked files have around 13 sheets each and there's a lot of them so having everything possible sheet seems rather clunky.
Thanks!
