View Single Post
 
Old 09-07-2018, 08:32 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

another possibility:


assuming the 58 in your example is in A34, try this in A35 and drag down
Code:
=IF(B35="","",MAX($A$34:$A34)+1)
don't know where the first number on sheet 2 would be, but something like this in the cell should get the next number
Code:
=MAX(Sheet1!$A$34:$A$500)+1
Reply With Quote