Fishbonker

If it's as simple as you say, select the data in sheet 1 and press delete.
Then go to FileSave as... and save as the new file with this year's name or
something.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Fishbonker" wrote in message
...
I've got a wookbook with 16 sheets. All of my data is on the first sheet.
The
other 15 have formuals to automatically count, sum, average, add to a
chart
etc etc from the first sheet.

How do I start over for the new year? I want to start another wookbook
with
all the same formulas, formatting and pivot tables minus last years data.

Thanks, and PLEASE keep it simple.

TT
--
Its better to remain silent and be thought a fool than open ones mouth and
remove all doubt. Creditied to Mark Twain.

So I guess I''''ve removed all doubt.