Linking files

[bakerd]

I have one master file I want to link in 3 separate files to the master. Is this possible and if so how?

 

[dermie_72]

you want to link them, or merge them into one new file, or merge them into an existing file. Regularly, or once off?
Please provide more details.

 

[bakerd]

Thank you for your reply. I have decided to change things up. I want to have 3 files, for this forum post I will call these excel files A, B & C. Each file represents input for production schedule for one of three specific office locations, each office named respectively A, B or C. Also each file only contains one editable sheet and 2 linked sheets - each linked sheet representing the file from the other 2 offices. What I want to do for example is have file A be edited by office A and file A would include linked sheets B & C; conversely office B would edit their own and would include linked sheets A & C while office C would edit their own sheet and would include linked sheets A & B.
Hope this is clearer than mud.

 

[dermie_72]

That sounds much more like a system security request, more than an excel request. Once someone has created the files A, B & C. They need to be placed into specific network forlders, then they set permissions based on the location of the staff.

The other option would be to create the spreadsheets they way you want, then add passwords to make modifications to the sheets you want to protect. You only make available the passwords to the file A to site A, file B to site B, file C to site C.

I hope that helps.