Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Assigning names to a spreadsheet that updates | New Users to Excel | |||
Tab Names II | Excel Discussion (Misc queries) | |||
macro to change the names and delete closed books | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |