ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting List Subtotal Headings (https://www.excelbanter.com/excel-discussion-misc-queries/158473-formatting-list-subtotal-headings.html)

Ivy

Formatting List Subtotal Headings
 
I have used the vlookup function to add data from one spreadsheet to another.
I then used the list subtotal function. When I collapse the data to create
a summary report, the subtotal row automatically adds the function to the
data name, e.g. tables count. Is it possible to modify this label? My pivot
table cell reference would have to be changed for the subtotal rows. I have
about 25,000 rows of data.

Thank you.
--
Ivy


All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com