Ahhhhh.

I should have read the OP's message <bg.

Max wrote:

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.
which hints that she wants to populate col B using col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
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 Peterson