I currently have 4 different excel files, which all contain 4 columns of the same information.
I was planning to have the information included on the 4 files in one excel document, but as different worksheets. However, I would like the information to keep constant with Sheet 1, ie when I add a line or change the text.
I know you can group the worksheets at the time when you are amending sheet 1 but as other people will be using this document, I would like to permanently group all the worksheets together.
Anyone know if this can be done?
I was planning to have the information included on the 4 files in one excel document, but as different worksheets. However, I would like the information to keep constant with Sheet 1, ie when I add a line or change the text.
I know you can group the worksheets at the time when you are amending sheet 1 but as other people will be using this document, I would like to permanently group all the worksheets together.
Anyone know if this can be done?
