can a tab name/# chg. when a cell name/# chgs. automatical Excel
 

I have a master workbook (ONE) and the account numbers changes which changes
the account numbers in workbook (TWO). When the account number changes is
there a way to automatically update the tab in workbook (TWO) to reflect the
new account number?

can a tab name/# chg. when a cell name/# chgs. automatical Excel
 

See

http://www.mcgimpsey.com/excel/event...efromcell.html

In article ,
LauryC wrote:

I have a master workbook (ONE) and the account numbers changes which changes
the account numbers in workbook (TWO). When the account number changes is
there a way to automatically update the tab in workbook (TWO) to reflect the
new account number?