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?