inventory update macro will stop on empty row and out of sequence produce id entry

[xntdriver]

couple problems with this macro: A) random Product ID entry on invoice will stop the macro from running after the first inventory update. Product must be listed on the invoice in the same order as iit's listed on the product sheet.
B) Macro stops on empty row.

I need this macro to run regardless of entry order and ignore empty cell and run to the last row.
I have very limited VBA skill, I would really appreciate any help.
Thank you.

Please Login or Register  to view this content.

[rcm]

This routine updates every filled line in invoice by seeking (Product ID) in the inventory. Give it a try

Please Login or Register  to view this content.

[/CODE]

[xntdriver]

WOW! you da man. that works great. I guess there's no way around the empty cell issue. Thank you so much for your time.

[rcm]

This version will allow blank lines in between.

Please Login or Register  to view this content.

[xntdriver]

RCM, thank you very much!

[rcm]

You are welcome. Please take time to mark this thread as solved

[6StringJazzer]

xntdriver, your post does not comply with Rule 3 of our Forum Rules: Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have added them because you are a new member but in the future, please include them or your thread will be locked until it's resolved.

[xntdriver]

I will adhere to all rules. Sorry about that.