I have a worksheet with formulas that I need to copy for each month.
The worksheet is filled in with data, but I only want the formulas, lables,
headings, formats etc not the actual data.
How can I do this?
Any help is appreciated greatly.

How about copying the worksheet exactly and then clearing all the data?
After copying, enter and run this small macro:

Sub clearit()
Dim r As Range
For Each r In Selection
If IsNumeric(r.Value) Then
If r.HasFormula Then
Else
r.Clear
End If
End If
Next
End Sub

It will clear numbers, but l;eave formulae and text alone.

--
Gary's Student


"Candyk" wrote:

I have a worksheet with formulas that I need to copy for each month.
The worksheet is filled in with data, but I only want the formulas, lables,
headings, formats etc not the actual data.
How can I do this?
Any help is appreciated greatly.

Thank you!
Works great.
Sincerely, Candyk

"Gary''s Student" wrote:

How about copying the worksheet exactly and then clearing all the data?
After copying, enter and run this small macro:

Sub clearit()
Dim r As Range
For Each r In Selection
If IsNumeric(r.Value) Then
If r.HasFormula Then
Else
r.Clear
End If
End If
Next
End Sub

It will clear numbers, but l;eave formulae and text alone.

--
Gary's Student


"Candyk" wrote:

I have a worksheet with formulas that I need to copy for each month.
The worksheet is filled in with data, but I only want the formulas, lables,
headings, formats etc not the actual data.
How can I do this?
Any help is appreciated greatly.