ssraghunathan
New Member
Hi,
I have few excel files which is used for calculation and data analysis. The data in each file has been consolidated to one file i.e. in the consolidated sheet, I have referred the data to other excel file(s). My question is :- If I move those worksheet (selective) to a file where the consolidated worksheet available (For the convenience i would say this consolidated worksheet which is in a "common file"), i'm afraid the data loss in the consolidated sheet.
Is there any mechanism to bring those worksheets in a "common file" along with the consolidated worksheet without affecting the formulas and subsequent changes in the other worksheet which is meant for calculation purposes. In worst case, I wanted to mirror those worksheets in a "common file".
Please let me know.
Thanks
Raghuanthan S
I have few excel files which is used for calculation and data analysis. The data in each file has been consolidated to one file i.e. in the consolidated sheet, I have referred the data to other excel file(s). My question is :- If I move those worksheet (selective) to a file where the consolidated worksheet available (For the convenience i would say this consolidated worksheet which is in a "common file"), i'm afraid the data loss in the consolidated sheet.
Is there any mechanism to bring those worksheets in a "common file" along with the consolidated worksheet without affecting the formulas and subsequent changes in the other worksheet which is meant for calculation purposes. In worst case, I wanted to mirror those worksheets in a "common file".
Please let me know.
Thanks
Raghuanthan S