Hi, can someone help me. I want to make sheet 1 which new data process can continue sequence form existing excel file.
For example: This is existing file sheet eligible. From this sheet, if have run another process it will be create sheet 1. Sheet 1 you can see the below.
Main : what I want is sheet 1 should continue the sequence from eligible sheet when run new process and same goes continue with e-policy no.
This is sheet 1, as you can see the column N_SEQ and E-Policy No is empty
Can someone assist me how to do?
This is vba we use for sequence. how I want to do in this vba to continue the sequence from another sheet. I’m not pro in vba. can someone teach me.
Dim sht As Worksheet
Dim LastRow As Long
Dim LastColumn As Long
Dim StartCell As Range
Set sht = Worksheets(“Sheet1”)
LastRow = sht.Cells.Find(“*”, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
sht.Range(“O2:O” & LastRow).Formula = “=ROW(A1)”