How to create a new couple of worksheets with same characteristics as...

[kras]

Hi,

I've searched the forum for a similar question but no results found.

I don't know if it is possible to be done, but I will ask.

Well, I have two worksheets in my workbook - the first one I use as a
data base and enter my data in a few tables; the second one I use for
statistical purposes and it contains formulas and tables that use the
information from the first worksheet. My question is, how can I create
a new couple of worksheets that have the same relationships /which
means to save the formats and formulas between the two sheets, but not
the data/ as these two worksheets?

Any help is welcome.

Thank you.

 

[Dave Peterson]

I think that this should work.

Close excel
Use windows explorer to copy the file to a new name.
Open excel
Open the copied workbook
Rename those "new" worksheets to what you want.
Open the original workbook
Move the worksheets from the copied file into the original workbook.

(I didn't test it, but it kind of sounds like it should work.)

 

[kras]

It works, Dave!

Thank you.

kras