Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

renaming tabs

Comment:

I have created a purchase order workbook I need to rename 250 tabs OK1001 etc. and also number the individual sheets in a cell. Please help I know nothing about macros.

Name: DerbyDad03
Date: November 5, 2008 at 12:05:05 Pacific

Reply:

Please be more specific about the names of your sheets. Does "rename 250 tabs OK1001, etc." mean OK1001, OK1002, up to OK1250? Please be more specific about "number the individual sheets in a cell". What cell? What is the numbering sequence? What is the numbering format? etc? The more detail you supply, the easier it is to give you an answer.

0

Name: seawatch
Date: November 18, 2008 at 14:04:25 Pacific

Reply:

Use this: http://www.asap-utilities.com/ you can rename all the tabs using several various inputs. A diplomat is a man who always remembers a woman's birthday but never remembers her age. Robert Lee Frost

0

Internet Explorer History

Find and Delete numbers i...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, I used to be able to right click on the MS Excel Sheet1,Sheet2,Sheet3 tabs and get the menu "Insert+Delete+Rename ..etc". All of a sudden, If I do a right click on the Sheets tab, there's nothing ...

Summary: Yes, using the keyboard. From the cell to sheet tab just right click and select copy on the cell. Right click the Sheet tab and select Rename and then hit Ctrl+V to paste it. To go from the sheet: Rig...

Summary: re: Any easy way to create this? Create what? A workbook with 31 tabs? Or the functions required to import totals from previous day's tab? The following code will create a workbook with 31 tabs, named...