Duplicating rows to another sheet with update button problem

[ericmday]

I know this similar request has been made before on other posts but I can't find a solution to this particular issue.

I am using the below code to copy row data from one sheet to another based on criteria in a column. Easy enough. I have an "update" button to call the macro and it works well, save two features.

If there is missing info in a row I wanted a box to pop up "Please fill out row" or something like that. Right now an error box with "400" displays.

Second, if I delete the first row on the "Master" sheet and run the macro, it won't reflect that deletion on the sub sheet. This only happens for the first row because I don't know how to program a "clear contents" that deals with the change/update. I have also attached a sheet.

Bonus -- how could I make this code refer to table data?

Please Login or Register  to view this content.

[ericmday]

bump. anyone?