View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anna in Istanbul Anna in Istanbul is offline
external usenet poster
 
Posts: 1
Default Making name of worksheet a function

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.