Looking to copy a worksheet with all formats and formulas without coping inputed data
 

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

Looking to copy a worksheet with all formats and formulas without coping inputed data
 

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

Looking to copy a worksheet with all formats and formulas without coping inputed data
 

Why do not you try "edit" - "special past" - "format"


--
lgarcia
------------------------------------------------------------------------
lgarcia's Profile: http://www.excelforum.com/member.php...fo&userid=9520
View this thread: http://www.excelforum.com/showthread...hreadid=480194

Looking to copy a worksheet with all formats and formulas with
 

me too!
--
paul
remove nospam for email addy!



"Anne Troy" wrote:

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