ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   subrow names must appear in consolidating by category as tab name (https://www.excelbanter.com/excel-worksheet-functions/29047-subrow-names-must-appear-consolidating-category-tab-name.html)

khacpt

subrow names must appear in consolidating by category as tab name
 
when consolidating in one xls (eg ConsOfRegions.xls) having several tabs
(north, south, east,) using category method (ie. with several common row
names) I see that when pressing the "2" in top left hand corner of spread
sheet to expand the consolidated totals to display the corresponding cource
rows on the separate tabs, the file name appears eg "ConsOfRegions" rather
than the row being labled as the name of the source tab eg"South, East, North
etc"

How does one get the correct source ie tab anme as the raw name?

Kai Albrecht


All times are GMT +1. The time now is 11:17 PM.

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