View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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?