View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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?