Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy within a subtotal
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??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy within a subtotal
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 "nitengale" wrote: 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotal copy and paste | Excel Discussion (Misc queries) | |||
To copy subtotal into another sheet | Excel Discussion (Misc queries) | |||
How do I copy just the collapsed subtotal lines? | Excel Discussion (Misc queries) | |||
copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
copy the result of a subtotal | New Users to Excel |