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.
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
Bookmarks