copy worksheet with formulas but not data
 

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.

copy worksheet with formulas but not data
 

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.

copy worksheet with formulas but not data
 

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.