| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NAME SHEETS sequentially
I have 100 sheets(Invoices).
I want to number these Invoices. I want to name the first sheet #1000 and the rest to be renamed sequentially after that. How can I do this with as few keystrokes as possible? Also, how can I then put that Invoice number in a cell on each sheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete sheets from a workbook without creating linked formulae | Excel Discussion (Misc queries) | |||
| insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
| Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Threaded Mode
