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.