View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BM BM is offline
external usenet poster
 
Posts: 10
Default Create tabs named after a group of cells?

Is it possible to create multiple tabs each being named after a particular
cell.

For example:

a1 Apple
a2 Pear
a3 Grape
a4 Banana

Could I somehow select that group of cells and have tabs automatically
generated named, Apple, Pear, Grape, and Banana?

I have a rather large list and would like to automate the process if possible.

Thanks in advance!