Copy within a subtotal

N

nitengale

I have a large worksheet where there is already subtotalling. I'm looking to
add a subtotal to one column.

Because of additional formulas and information that that has been added to
the subtotal lines, I cannot use the subtotal function to add one more
formula. If I can find a way to copy just the subtotal formulas from column
P into column V, that would work, but not sure of the best way to do this.

Any recommendations???
 
T

Tom-S

If the subtotal formulas you want to copy contain only absolute cell
references, then you could use Copy & Paste Special - Formulas (use a right
click in the top target cell to access the Paste Special menu).

If the subtotal formulas contain relative cell references, click in the cell
with the formula, then highlight the formula in the formula bar, copy (Ctrl +
C), press Escape, click in the target cell, then paste the formula in the
formula bar.

Regards,

Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top