Change code so it can continue save from last used row

Hi patel and thanks. Here is a sample. Also i dont know but i need to put text into sheet "Lookupsheet" Column A. Other wise it come with and error.
But the main thing is to have that i can continue in sheet Match, So it donet delete preveous result. Please have a look thanks

Sincerely
Abjac