How to continue the sequence from another sheet in new sheet

Help Studio
1

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.

image
image1062×305 89.5 KB

This is sheet 1, as you can see the column N_SEQ and E-Policy No is empty

image
image1278×217 86.6 KB

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.

Sub seqNocopy()

Dim sht As Worksheet
Dim LastRow As Long
Dim LastColumn As Long
Dim StartCell As Range

Set sht = Worksheets(“Sheet1”)

Worksheets(“Sheet1”).UsedRange

LastRow = sht.Cells.Find(“*”, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

sht.Range(“O2:O” & LastRow).Formula = “=ROW(A1)”

End Sub

Thank you.

2

Create a link to another worksheet
Select the cell or cells where you want to create the external reference.
Type = (equal sign).
Switch to the worksheet that contains the cells that you want to link to.
Select the cell or cells that you want to link to and press Enter.

Regards,
Will

3

can you share a workflow or show the steps, I am pretty new to this still. Thanks in Advance