"Next Year" function

[Philip Carey]

Is there a way to clear (delete) values from a worksheet
while retaining other information; i.e., can one derive
a "next year" worksheet in one, easy operation?

 

[Jonathan Rynd]

Is there a way to clear (delete) values from a worksheet
while retaining other information; i.e., can one derive
a "next year" worksheet in one, easy operation?

What do you mean by "values"? Please be more specific.

Do you mean "anything numeric that is not a calculation"? If so, then you
can definitely write a VB macro to do so. (and it's really simple too)

 

[Randall Roberts]

you can use this macro
then just select the sells you want to clear and run the macro

Sub clearvalues()
Selection.SpecialCells(xlCellTypeConstants, 23).ClearContents
End Sub

Randall