View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Christine Christine is offline
external usenet poster
 
Posts: 147
Default Name a worksheet tab based on the value in a cell.

Hello all,

I have found a lot of posts about how to populate a cell with the value in
the worksheet tab name, but not the other way around. I would like to
automatically name the worksheet tab based on the value in a specific cell.

I'm ok with formula's but not "up" on VB. Is there a formula I could use to
accomplish this?

Thanks in advance for any help you can give me.

Christine