Hello, I am trying to figure how to automatically add a new worksheet tab
name to the first worksheet. For example, when I create a new worksheet, I
will change the tab name to something like 2500 and so on. I want the name
of that tab, when created, automatically added to the for worksheet which is
like a log of all the 2500 names. I also want, next a specific function to
be done automatically next to the name of the sheet, based on a number on
that new sheet.
thanks
adam
You could try the free Excel add-in quot;Excel Extrasquot;.
It will create a Table of Contents of all sheets in the workbook.
Each sheet name is hyperlinked to the sheet.
If you add a sheet then just run the program again (from an item on the Insert menu).
It does other stuff too. Comes with an install/use Word.doc file.
Download from... www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA
quot;adamquot; wrote in message
Hello, I am trying to figure how to automatically add a new worksheet tab
name to the first worksheet. For example, when I create a new worksheet, I
will change the tab name to something like 2500 and so on. I want the name
of that tab, when created, automatically added to the for worksheet which is
like a log of all the 2500 names. I also want, next a specific function to
be done automatically next to the name of the sheet, based on a number on
that new sheet.
thanks
adam
- Mar 13 Thu 2008 20:43
Adding worksheet tab names to the first worksheet
close
全站熱搜
留言列表
發表留言