Linking

  • Thread starter Thread starter amy
  • Start date Start date
A

amy

I am using Excel97 and want to know how to change links to another worksheet
in the same workbook? For example, I have worksheet OTB DEC and OTB JAN in
workbook OTB1. In a separate workbook, I have linked the values from
worksheet OTB DEC in column A. In column B I need the same exact cells
linked, but from the the worksheet OTB JAN. How can I do this without having
to either relink column B or type over "OTB DEC" with "OTB JAN" in every
cell? I cannot use change source because they are both from the same
workbook, OTB1.
 
Try this sequence with col B selected:
1. Edit > Replace "=" with say "zzzz" (convert formulas to textstrings)
2. Edit > Replace "OTB DEC" with "OTB JAN"
3. Edit > Replace "zzzz" with "=" (re-instate textstrings to formulas)
 
I bet that steps 1 and 3 aren't necessary.

Just changing the worksheet name (don't make a typo though!) would work fine.
 
Dave
Perhaps my earlier response should have been:

Select col A
Edit > Replace "=" with say "zzzz" (convert formulas to textstrings)

Copy n paste col A to col B

Select col B
1. Edit > Replace "OTB DEC" with "OTB JAN"
2. Edit > Replace "zzzz" with "=" (re-instate textstrings to formulas)

Select col A
Edit > Replace "zzzz" with "=" (re-instate textstrings to formulas)

since OP indicated that
.. In column B I need the same exact cells linked,
but from the the worksheet OTB JAN.
Click to expand...
which hints that she wants to populate col B using col A

---
 
Back
Top