| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Calculated Column using Subtotals
I would like to write a macro to put a calculated value in a column (e.g.
ColB/ColA). The worksheet has sub-totals and the number of rows in the worksheet will vary (based on imported data). I know how to write the macro for a calculated value in a cell, but how do I copy down to the "Grand Total" row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Subtotals - Calculated field subtotal incorrect | Excel Discussion (Misc queries) | |||
| Calculating Column and off setting calculated value to another column | Excel Programming | |||
| Sumproduct with calculated column | Excel Programming | |||
| Can the sum of 1p + 3p be calculated in a column in Excel? | Excel Discussion (Misc queries) | |||
| using a calculated column value within a range | Excel Programming | |||
Linear Mode
