A
Aussiegirlone
::In sheet called Database Column A are employee names. In column B ar
employee’s ID number. :
:: :
::A1 of Every other sheet in workbook is linked to a cell in thi
database sheet column A so that renaming sheet tabs are now quite easy
:
:: :
::Can someone create this macro for me Please?:
:: :
::What I would like is a macro that if I do not put an employee name i
cell e.g. A50 in database sheet, that the sheet named “Employee 50” tha
is linked to this cell in the database sheet is replaced with the I
number in cell B50 of database sheet.:
:: :
::Then I would like the sheet that has been renamed with the ID numbe
to be automatically hidden….. UNTIL ……..a name has been entered in A5
of database sheet. :
::If a name is then entered in A50 then sheet that had been renamed t
“50” automatically becomes unhidden and is named by A50 “Employee 50” o
database:
employee’s ID number. :
:: :
::A1 of Every other sheet in workbook is linked to a cell in thi
database sheet column A so that renaming sheet tabs are now quite easy
:
:: :
::Can someone create this macro for me Please?:
:: :
::What I would like is a macro that if I do not put an employee name i
cell e.g. A50 in database sheet, that the sheet named “Employee 50” tha
is linked to this cell in the database sheet is replaced with the I
number in cell B50 of database sheet.:
:: :
::Then I would like the sheet that has been renamed with the ID numbe
to be automatically hidden….. UNTIL ……..a name has been entered in A5
of database sheet. :
::If a name is then entered in A50 then sheet that had been renamed t
“50” automatically becomes unhidden and is named by A50 “Employee 50” o
database: