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
> can i continue a number a sequence from one worksheet to another?
brenda - 20 Apr 2007 17:08 GMT
Yes, but I meant from one workbook to another, not worksheet.
> Do you mean something like, having 1 in worksheet Sheet1, cell A1, you
> want 2 in worksheet Sheet2 (in the same workbook), cell A1?
[quoted text clipped - 4 lines]
>
> > can i continue a number a sequence from one worksheet to another?
JE McGimpsey - 20 Apr 2007 17:15 GMT
See
http://www.mcgimpsey.com/excel/sequentialnums.html
> Yes, but I meant from one workbook to another, not worksheet.
>
[quoted text clipped - 6 lines]
> >
> > > can i continue a number a sequence from one worksheet to another?
brenda - 20 Apr 2007 17:30 GMT
THANK YOU!
> See
>
[quoted text clipped - 10 lines]
> > >
> > > > can i continue a number a sequence from one worksheet to another?