Link to home
Start Free TrialLog in
Avatar of Jason Priester
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
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jason Priester
Jason Priester

ASKER

One additional question that is related...

The sequence I had completed above (being:  ='Sheet2'!$A$1, ='Sheet2'!$B$1,='Sheet2'!$C$1) -  could I mass copy that iteration of cells (lets say from rows 1:10, to 11:20)?
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
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