| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto-numbering in Excel
can i continue a number a sequence from one worksheet to another?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Auto-numbering in Excel
Do you mean something like, having 1 in worksheet Sheet1, cell A1, you
want 2 in worksheet Sheet2 (in the same workbook), cell A1? if so, then in Sheet2: A1: =Sheet1!A1 + 1 In article , brenda wrote: can i continue a number a sequence from one worksheet to another? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Auto-numbering in Excel
Yes, but I meant from one workbook to another, not worksheet.
"JE McGimpsey" wrote: Do you mean something like, having 1 in worksheet Sheet1, cell A1, you want 2 in worksheet Sheet2 (in the same workbook), cell A1? if so, then in Sheet2: A1: =Sheet1!A1 + 1 In article , brenda wrote: can i continue a number a sequence from one worksheet to another? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Auto-numbering in Excel
See
http://www.mcgimpsey.com/excel/sequentialnums.html In article , brenda wrote: Yes, but I meant from one workbook to another, not worksheet. "JE McGimpsey" wrote: Do you mean something like, having 1 in worksheet Sheet1, cell A1, you want 2 in worksheet Sheet2 (in the same workbook), cell A1? if so, then in Sheet2: A1: =Sheet1!A1 + 1 In article , brenda wrote: can i continue a number a sequence from one worksheet to another? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Auto-numbering in Excel
THANK YOU!
"JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/sequentialnums.html In article , brenda wrote: Yes, but I meant from one workbook to another, not worksheet. "JE McGimpsey" wrote: Do you mean something like, having 1 in worksheet Sheet1, cell A1, you want 2 in worksheet Sheet2 (in the same workbook), cell A1? if so, then in Sheet2: A1: =Sheet1!A1 + 1 In article , brenda wrote: can i continue a number a sequence from one worksheet to another? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| execute auto invoice numbering in excel file | Excel Discussion (Misc queries) | |||
| is there an auto-numbering tax invoice templete for excel | Excel Discussion (Misc queries) | |||
| Auto Numbering | Excel Worksheet Functions | |||
| Is auto invoice numbering possible in Excel 2003? | Excel Discussion (Misc queries) | |||
| Where do I find the Auto Numbering icon Button for excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
