I am trying to find a way to do the following procedure:
I have two spreadsheets in different files (spreadsheet1 & spreadsheet2), with cell references linked between them. For example the formular in cell A1 of spreadsheet1 is: ='[spreadsheet2.xlsx]Sheet3'!C10)
This brings the value of from cell C10 in spreadsheet2 forward to cell A1 in spreadsheet1.
Now, consider that the contents in cell C10 in spreadsheet2 is an equation as well, for example =1500/10 the answer displayed in both cell C10 of spreadsheet2 and cell A1 of spreadsheet1 is 150.
Is there any way I can easily bring the actual formular (=1500/10) forward from spreadsheet2 to spreadsheet 1, thus essentially eliminating the link between the two spreadsheets?
Unfortunately, copy and paste isn't an option as I have a large number of formulars to bring forward from a variety of different locations.
Any help on this topic is much appreciated.
Thank you.
Bookmarks