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.

Please Login or Register  to view this content.
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