How do I copy / duplicate a worksheet within a workbook without having to
reconfirm all the cell names each time I copy the sheet over?

My worksheet has some 27 cell names & I may copy the sheet over many times
within the workbook - thus spending a lot of time pressing "Enter" to accept
the default.

Please advise / Thanks

If I read your request correctly, you want an exact copy of a Worksheet to a
new Tab/Worksheet. If so try this;

On the original sheet, in A1 Ctrl A , Ctrl C, open a new Tab/Worksheet
& Ctrl V.

Bob

"Robert M" wrote:

How do I copy / duplicate a worksheet within a workbook without having to
reconfirm all the cell names each time I copy the sheet over?

My worksheet has some 27 cell names & I may copy the sheet over many times
within the workbook - thus spending a lot of time pressing "Enter" to accept
the default.

Please advise / Thanks

Thanks - Tried It, However, I still had to reconfirm reusing all the same
names in the new tab/worksheet, it also lost all the column width & row
heigth settings.

"robert morris" wrote:

If I read your request correctly, you want an exact copy of a Worksheet to a
new Tab/Worksheet. If so try this;

On the original sheet, in A1 Ctrl A , Ctrl C, open a new Tab/Worksheet
& Ctrl V.

Bob

"Robert M" wrote:

How do I copy / duplicate a worksheet within a workbook without having to
reconfirm all the cell names each time I copy the sheet over?

My worksheet has some 27 cell names & I may copy the sheet over many times
within the workbook - thus spending a lot of time pressing "Enter" to accept
the default.

Please advise / Thanks