Sometimes, just using Edit|Replace and changing the old worksheet name to the
new worksheet name will be enough.

It'll catch the worksheet names used in formulas -- but it won't catch
everything.

Al wrote:

Let's say I have two worksheets: WS-A, WS-B. In WS-B I link certain cells to
cells in WS-A. Now I want to replicate these two worksheets (i.e. create
WS-A(2) and WS-B(2). What I would like to end up with is WS-B(2) linked cells
pointing to their corresponding cells in WS-A(2). Ultimately I would like to
take those first two worksheets and duplicate that set a number of times in
the same workbook and end up having each subsequent WS-B worksheet
pointing/linking to its paired WS-A worksheet. Sorry if I made this more
confusing than need be, but not sure how else to describe it. Any suggestions
on how to accomplish this would be appreciated! (Excel 2003)

When I create the first set, I did "Edit--Move or Copy--Create Copy" for
each of two initial sheets (WS-A, WS-B).

--

Dave Peterson