A
Anna in Istanbul
sheetHi everyone,
I was wondering if there is any way to have the name of a worksheet change
as a function of an entry in a specific cell. The sheets themselves are
created manually.
Specifically, I have a data entry sheet where the names (ie locations) of
some new branches are entered once. Then each location has a sheet, which now
carries the (fixed) branch code. But for more clarity, the customer would
prefer to see the branch names here without having to enter them in each
sheet name again.
I was wondering if there is any way to have the name of a worksheet change
as a function of an entry in a specific cell. The sheets themselves are
created manually.
Specifically, I have a data entry sheet where the names (ie locations) of
some new branches are entered once. Then each location has a sheet, which now
carries the (fixed) branch code. But for more clarity, the customer would
prefer to see the branch names here without having to enter them in each
sheet name again.