| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get subtotals results as a variable
Hi, every month I've got spreadsheet with payments (thousands of rows).
Usually I'm using subtotals to get sums grouped by currency. I know how to write code in VBA for subtotals, but how can I get the results for subtotals eg. as a variable? Number of payments is different every month, so I can't used hard references to cells. Or is it possible to name (named range) cells with subtotals results? -- Przemek Now playing: nothing |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| provide simultaneous results for a range of a particular variable | Excel Discussion (Misc queries) | |||
| Why do i have blank lines in my subtotals results | Excel Worksheet Functions | |||
| Define drop-down results that are variable and dependent upon the. | Excel Discussion (Misc queries) | |||
| Subtotal results in new column and then sorting subtotals | Excel Worksheet Functions | |||
| Variable results to new workbook | Excel Programming | |||
Threaded Mode
