Sheet4 is the “Orders” page, column “K” is a counter to give each order line a unique number to make search easier, this is the “Product9.Value”.
If “Product9” is blank do nothing
Finds the Row with the “Product9” counter value & pastes “Product7” value (Amount Received) plus the value already received in the Tracker column (column 12) this code works perfect if the userform is open up on the Orders page.
Next
This code changes the active sheet to “Product1 value” (Supplier) e.g. “Allfix” or “3 Monkeez”.
To find the correct row we now find “Product3 value from the UserForm, this is the “Our Code” column on the active Suppliers page
Finds the Row with the correct “Our Code” value & pastes Product7 value to the in-stock column but also adds what was already in stock also so the stock value is exact. Next line puts what is still outstanding on the order into the “On Order” column. Again, this code works perfect when the userform is opened up on the supplier page. I need all the above to work from the “Start” page, hope this helps Richard? Thanks again - Marco
Bookmarks