Truly duplicating a sheet in a workbook?


Salmon Egg

Suppose I have a sheet in a workbook for which everything is just the
way ( want it. To be specific, I am using a sheet of basic drugs for
which I need to get refills. It prints the way I want it, it is oriented
correctly, print areas are correct, column widths are correct, and so is
everything I can think of.

I now wish to take a copy of this sheet and paste it into a new sheet.
That sheet can now be modified for a specific listing for a refill
order. Copy and Paste seems to do a good job on the data as does Copy
and Paste Special. Nevertheless, it seems that I need additional
operations to get all the other properties correct.

My question: How can I transfer ALL the information from one sheet to
another sheet in the same or another workbook without wondering if I get
everything done correctly?



Conservatives are against Darwinism but for natural selection.
Liberals are for Darwinism but totally against any selection.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question