I have my pension tracked for 2004
Now I wish to copy all the formatting and formulas to a new worksheet for
2005
I no how to just copy, but the formatting doesn't follow and I will have to
clear all the data info.

So can I tell it to copy the 2004 worksheet to a NEW worksheet named 2005
and retain the column size, formatting, and formulas etc.


Please and thank you.

--


-----------------------------------------------------
"This tagline is identical to the one you are reading."
-----------------------------------------------------

Bill H. in Chicagoland