I would like to add a new sheet in workbook that the name is in sequence for example "customer 001" then "Customer 002" so everytime i had a sheet follows on.
I can do this in a macro but it only name's it 'sheet xxx' example "sheet 01"
any ideas
2007-03-26 02:39:10 · 7 answers · asked by Anonymous in Computers & Internet ➔ Software
On the Menu bar
1.Click on the insert option.
2.In insert option click "worksheet".
3.After inserting the sheet,rightclick on the sheetname (which is right at the bottom) and click on the option of rename.
Hope it will help.
2007-03-26 02:54:20 · answer #1 · answered by ♥The ≈ μŊđīş¢¤vέřệÞ ≈ Me♥ 2 · 0⤊ 0⤋
Go to Insert in the menu, then Worksheet. It adds a new sheet for you. Then to rename it, right click on the sheet name and hit rename.
2007-03-26 02:43:01 · answer #2 · answered by Anonymous · 1⤊ 0⤋
At the top of your computer window:
Insert | New Worksheet.
It will give it a number as a name. You can change it to what you want by right clicking on the tab at the bottom and selecting "rename".
You can also move it left or right to where you want it among your pages by left clicking the tab and dragging it where you want.
FWIW.
2007-03-26 04:14:36 · answer #3 · answered by carl j 3 · 0⤊ 0⤋
Yeah.... I'm afraid you're just going to have to insert new and overtype.
If you wanted to use a macro consider having your customers on the same worksheet
2007-03-26 02:46:30 · answer #4 · answered by Anonymous · 0⤊ 0⤋
down on the botom of the screen where you change pages right click on one of them and there will be an option of add or duplicate or insert page pick one
2007-03-26 02:42:43 · answer #5 · answered by flackjack 2 · 0⤊ 0⤋
Source code below will help
2007-03-26 18:05:59 · answer #6 · answered by unnga 6 · 0⤊ 0⤋
Can you not just do it manually? Overtype the name on each one.
2007-03-26 02:42:36 · answer #7 · answered by Anonymous · 0⤊ 0⤋