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