Insert a line in excelsheet in some section

[aman1234]

Hi guys

Please find attached two spreadsheets. The first one "Sample" is the spreadsheet that my client used to use earlier. The second one "Project" that I am making to replace the old one.

Now in "Sample" workbook, in the worksheet "PCs and scanners" when the user click on New scannerline button on the worksheet then a new line gets inserted in the scanning section only.

I want to do the same thing in the workbook "Project" like in the userform when the user click on Enter button then it should check if the "new scanner line" textbox is empty and if yes then no line should be inserted in scanning section other wise a line should be inserted as in workbook "Sample".

Thanks

[aman1234]

Hi All

Can anyone please figure out my problem?

Thanks a lot.

[aman1234]

All Excel Gurus, I am looking for your help. Please help me out to figure out my problem.

[mohd9876]

Dear aman,
please try the following code

Please Login or Register  to view this content.

[aman1234]

Thanks . This is working absolutely fine. Could you please also tell me if I want to insert new scanner details before Total then how can we do that.

Thanks a lot again.

[mohd9876]

Try this

Please Login or Register  to view this content.

[aman1234]

Thanks a lot. It worked perfectly fine. You are gr8.