I
Ian
i have a budget with a bunch of sheets. The first sheet (sheet1) is to be a
summary sheet.
In the summary sheet I'd like to be able to make a cell name dependent on
the tab name of other sheets. That way I only have to change the name in one
place.
For instance in the summary sheet the first column will be all the sheet names
item1 (sheet 2 name)
item2 (sheet 3 name)
item3 (shhet 4 name)
where each item is a sheet name. If there a formula to do it?
summary sheet.
In the summary sheet I'd like to be able to make a cell name dependent on
the tab name of other sheets. That way I only have to change the name in one
place.
For instance in the summary sheet the first column will be all the sheet names
item1 (sheet 2 name)
item2 (sheet 3 name)
item3 (shhet 4 name)
where each item is a sheet name. If there a formula to do it?