Thanks... ive already tried this and it copies over all the information as
well... i just wanted the formulas and format to copy over without the
information but there doesnt seem to be an option to do this.



"ryguy7272" wrote:

Right-click on the sheet. Click Move or Copy To: New Book Create a Copy.
If that doesn't give you what you want, simply Click the little square in
the upper left hand corner, between A and 1, and hit ctrl + C go to a new
sheet right-click paste special then choose one of the options that
seems to do what you want (it's a little hard for me to imagine because there
are many possibilities...Formulas and Number Formats...maybe) . Give it a
go, and see what you get!


Regards,
Ryan---

--
RyGuy


"ambam" wrote:

Probably a very simple question but... i use excel for bookkeeping and
therefore have sheets of jan to dec with formulas in certain cells to work
out VAT etc. Im at the end of the year and want to start a fresh and make a
new workbook but keep the formulas but not copy over the figures and
information in the workbook i'm copying from... is this possible?

Many thanks