Excel 2007/ Vista- Problem Duplicating Worksheets Within Same Work

I duplicate/copy the same tab/ worksheet over, renaming it, many times within
the same workbook. The sheet has close to 30 named cell. I have to
"reconfirm" the each of the 30 cell names for each new sheet each time. this
gets to be a pain.

How can I duplicate/copy multiple sheets without haveing to reconfirm cell
names ??

You want a '3-D reference'
http://office.microsoft.com/assistan...&respos=6&rt=2
--
Was this helpful? Then click the Ratings button. Voting helps the web
interface.
http://www.microsoft.com/wn3/locales...eAPostAsAnswer
Mark L. Ferguson
..

"Robert M" <> wrote in message
news:5A9A6962-3661-4289-BD08-...
> I duplicate/copy the same tab/ worksheet over, renaming it, many times
> within
> the same workbook. The sheet has close to 30 named cell. I have to
> "reconfirm" the each of the 30 cell names for each new sheet each time.
> this
> gets to be a pain.
>
> How can I duplicate/copy multiple sheets without haveing to reconfirm cell
> names ??

I'll look into this, however, the values in the cells are unique & relate
only to that worksheet, no "link" to other workseets.

"Mark L. Ferguson" wrote:

> You want a '3-D reference'
> http://office.microsoft.com/assistan...&respos=6&rt=2
> --
> Was this helpful? Then click the Ratings button. Voting helps the web
> interface.
> http://www.microsoft.com/wn3/locales...eAPostAsAnswer
> Mark L. Ferguson
> .
>
> "Robert M" <> wrote in message
> news:5A9A6962-3661-4289-BD08-...
> > I duplicate/copy the same tab/ worksheet over, renaming it, many times
> > within
> > the same workbook. The sheet has close to 30 named cell. I have to
> > "reconfirm" the each of the 30 cell names for each new sheet each time.
> > this
> > gets to be a pain.
> >
> > How can I duplicate/copy multiple sheets without haveing to reconfirm cell
> > names ??
>

I don't use excel so I cant't help. Sorry
"Robert M" <> wrote in message
news:5A9A6962-3661-4289-BD08-...
>I duplicate/copy the same tab/ worksheet over, renaming it, many times
>within
> the same workbook. The sheet has close to 30 named cell. I have to
> "reconfirm" the each of the 30 cell names for each new sheet each time.
> this
> gets to be a pain.
>
> How can I duplicate/copy multiple sheets without haveing to reconfirm cell
> names ??