Copy and Paste Formuals only, not Content

[cvs2kids]

I have an accounting spreadsheet with totals and grand totals down 1300 rows.

Is there a way to copy and paste the formulas only without the content of the other?

So basically, only subtotals and totals are copied

[AlKey]

Copy formula, Paste Special and select Formulas

[cvs2kids]

No, to be more specific, I have the following example,
Red Dots 3
Blue Dots 5
Total Dots 8

Red Squares 1
Blue Squares 6
Total Squares 7

Total Shapes 15

What I want to do is hi-lite the row with the data and formula, and just copy the formula so the data is left out.

If I do what you say, it pastes formula and data

[BoSonic]

Hi cvs2kids,

So, I'm assuming that you want just formulas for the subtotals and totals copied (after copy they would all equal 0 because the formulas would be referring to empty cells) and it would be too time consuming to select just the individual subtotals because you have many rows. If this is the case then one might have to use VBA. You may not want to take the time delve into that realm tho. You can find tutorials using google searches on setting up new VBA modules in excel. Also, the file would have be saved as a macro-enabled excel file.

This code would copy only the formulas from column A and paste them to column B (on the same rows) in the worksheet you are currently in.

Please Login or Register  to view this content.

See the part that says: Range("A1:A2000"). You can change the A2000 to however many rows you have. Depending on some factors, the code could take a few seconds to run, but it didn't take long for me.

I'm not an excel expert and there may be a better way to do this than what I have provided, but this is one way.

Goodluck,