Tab Names

  • Thread starter Thread starter Mark Adams
  • Start date Start date
M

Mark Adams

Hi

Is it possible to rename a worksheet tab name automatically with reference
to a cell. ie. the sheetname automatically changes when text within a cell
on another sheet is altered.

I have Sheet1 with 20 cells into which 20 jobs nos are entered, and a
further 20 sheets which I would like meaningfull tab names instead of
"job1", "job2" etc

I would rather not use VB...

Thanks

Mark
 
Back
Top