If it were me, I'd copy the whole sheet and delete the inputted data.
************
Anne Troy
www.OfficeArticles.com

"God's Kid" wrote in
message ...

I am looking to copy a spreadsheet from one year to the next with all
the same formats and formulas. I do not want to copy the inputed data
since the inputed data with be new with the new year. Thank you for
the input


--
God's Kid
------------------------------------------------------------------------
God's Kid's Profile:
http://www.excelforum.com/member.php...o&userid=28426
View this thread: http://www.excelforum.com/showthread...hreadid=480194