Jason Priester
asked on
Linking Cells within workbooks - how to mass re-direct to a different sheet within a workbook
Hey All,
Currently I am trying to develop a tab within my workbook to serve as an export table (into a different master spreadsheet, and/or Microsoft Access).
I currently have a sheet within Excel in which I have individually linked the specific cells I want. I have other sheets within this same workbook in Excel which are formatted the same way (being the data in each column/row being laid out similarly in each workbook).
For example, in my current work book in cells a1 - a3 I have:
='Sheet2'!$A$1
='Sheet2'!$B$1
='Sheet2'!$C$1
How do I mass produce a change to capture the same sequence of links, but pointed to a separate sheet? Such as:
='Sheet3'!$A$1
='Sheet3'!$B$1
='Sheet3'!$C$1
The version of Excel I'm using is 2007. Any ideas?
Jason
Currently I am trying to develop a tab within my workbook to serve as an export table (into a different master spreadsheet, and/or Microsoft Access).
I currently have a sheet within Excel in which I have individually linked the specific cells I want. I have other sheets within this same workbook in Excel which are formatted the same way (being the data in each column/row being laid out similarly in each workbook).
For example, in my current work book in cells a1 - a3 I have:
='Sheet2'!$A$1
='Sheet2'!$B$1
='Sheet2'!$C$1
How do I mass produce a change to capture the same sequence of links, but pointed to a separate sheet? Such as:
='Sheet3'!$A$1
='Sheet3'!$B$1
='Sheet3'!$C$1
The version of Excel I'm using is 2007. Any ideas?
Jason
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can copy them, but since you have the $ in front of the cell references Excel will not adjust the referenced cells, so you will get an exact copy of the source cells.
»bp
»bp
ASKER
You made my day, Bill! I didn't even think to use the find/replace function for this. Worked perfectly! Thanks!
Great, glad that was helpful.
»bp
»bp
ASKER
The sequence I had completed above (being: ='Sheet2'!$A$1, ='Sheet2'!$B$1,='Sheet2'!$