VBA Finding next empty row if value in specific textbox entered

Hi,
I need help on following VBA. i am preparing voucher and have voucher-number in textbox1. sometime i need to have 3 debit entries (mean 3 times values in textbox 7) against one credit entry (textbox 8). i want to link value of textbox1 with textbox7 and 8. if there is value in textbox 7 or 8 then value of textbox1 should be posted in database sheet againt row of that filled textbox. if any of textbox(7 or 8) is empty, the value of textbox1 should not go in database against that empty textbox...
i don't know its explained or not

Please Login or Register  to view this content.

You see in attached file i posted two debit entries and one credit....see at database date and voucher number are posting meaningless at row number 6,8,9
I don't want data in row 6,8,9 in this example because there is no debit or credit entry in these rows

Thanks

If there is no data in H, I then that row should be deleted..

To be more clear,,,,if there is data either in column H or Column I, then keep row otherwise delete row...you see in this example there is no data in column H & I against rows 6,8,9...
thanks for your support

Thank you for your continues support !

This can be one of solution but is there any way that instead of deleting rows data entry stop if there is no debit or credit? actually i have some formulae in column K and L which also get deleted. isn't it?

Well, I very new and don't know much about coding and can't suggest anything to you atleast, i just want to lookup row if there is no entry in debit or credit(Column H, I in this example), data shouldn't be posted in database sheet. or other option can be to delete only values leaving formula as it is??

The attached file isn't helping me lot!

Yes you got what i want,
I ran this code but this line shows error, don't know why

LR = ActiveSheet.UsedRange.Rows.Count

Ah great its working !
But it deleted formula in K & L

I am happy more than half of the way im done, thank you

Ah its Working there was something wrong at my end!
But this action deleted formula in column K and L

I am happy, almost done with this project with your help