Auto-numbering in Excel
 

can i continue a number a sequence from one worksheet to another?

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?

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?

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?

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?