How to copy only the formulas in a column to another column [SOLVED]

[slight]

I have a Worksheet with the months of the year as the column headings.

The columns contain data and SUBTOTALS.

Is it possible to highlight a column and copy only the SUBTOTALS to a blank column?

 

[Luke M]

With your data selected:

Hit Ctrl+g, this will bring up the Go To dialogue

Select special...

Select Formulas, Ok out.

You now have all the formulas selected and can copy them.


Alternatively, copy all the data over, then select the region, Go to, Special, constants, and hit the delete key to clear out the old data.

 

[slight]

Thank you.

It works perfectly.

This will save me so much time in the future.

 

[Luke M]

Glad I could help, thanks for the feedback.