Quote from Derk
The error on line
ii = Application.Match(lv, vendors.Columns(1), 0)
means there is a vendor code on the Master sheet that is not on the Vendors sheet. You should be able to locate it because there will be an #N/A error for the vendor name in the bad row of the Master sheet. (The sheet names can be changed as desired, but none of the sheets can be deleted without fouling up everything.) This error shows when the Order sheet is being prepared, so the program stops because it can't locate the vendor information it needs.
You may be correct, but there is something else, because the Vendor page was changed as per the private post, and whenI added a bunch of new information on the Inventory page, this is what the Master page looks like:
[Blocked Image: http://www.natt.net/temp/error.jpg]
Nevertheless, notice in cells C5 and C6, I hand entered a valid Vendor code "S" for southern, but the n/a did not go away, despite the fact that row 5 says:
And, the vendors page does have an entry for Southern. I think something else is going on.
So what is the proper sequence for the end user?
1. Make sure products page and vendors pages are complete.
2. Build Inventory page as needed. Click "Send to Data Base Button" when finished.
3. Goto Master page and hand enter values for Vendor Code, PC# and Case value.
4. Reclick "Send to Data Base" button on inventory page.