Macro code to find empty row and paste the data everytime I press macro enabled Button

Hello,

I am tried a lot, but I am not able to create code to excel to find next available empty row and paste the data everytime i press macro enabled button.

I am requesting for following problem:

I have created button(with record macro option) which will copy the data from Bill sheet(attached) and pastes it in tblCustomer sheet when i press button, now when i press the same button with other details it replaces with already available information, now i want the data to be pasted next available empty row, whenever i press the Add Customer button which is in Bill sheet.

I have attached sheet for your info.

Please help.

Regards,
Pramod

The code you have is a recorded marco. I do not know the sheet name for the first line of the code, I have assumed it is sheet bill.

Thank you AB33 for the help, it worked, however i have it is clearing contents of J1:J2, but you have mentioned in the code to clear the content only for F1:F2 and K1:K2, but when i press add customer button, it is clearing the content from J1:J2, i.e; CRN and PAN(it should allways be there).

Please help.

Thanks.

Regards,
Pramod

Yes, you are right,
use this line instead

Please Login or Register  to view this content.

Thank you so much AB33, it worked

PCI, many thanks for responding to my question.