Hello everyone,

First, I'm a newbie so this question might be quite basic e possibly already answered somewhere (i did not find it though).

I want to select a cell that has a reference number, and then click a button to insert that cell number on the next blank row in other sheet.

Then, I will fill the other columns in that other worksheet using index match (it depends from that reference number).

Finally I want to copy/paste that new row as values to other workbook.

For now this is my code.

Sub create_new()

Line = ActiveCell.Row

MsgBox Line

claim_number = Worksheets("New Master").Cells(1, 3)

Workbooks.Open Filename:="C:\Users\sroc05.JCAMILO-SROC\Desktop/AAM Claims Master.xlsx"

Windows("AAM Claims Master.xlsx").Activate

Worksheets("N_Master").Calculate

'claim_number = Worksheets("N_Master").Cells(1, 3)

MsgBox claim_number

End Sub
I've managed to create the button, and open the other workbook. I also have a formula (on the cell (1,3)) that gives the next blank row.

Unfortunatelly for now, the only step I'm sure is that when I have the reference number inserted, i will record a macro, write the index/match, save the macro, and that will give the necessary code.

Thank you for your help,

Rui Farinha