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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"amy" wrote:
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.