Hi,
Been racking my brains for a way of doing this for a while now and have had no luck.
I have a spreadsheet with the following data:
Product Code | Component Code | Quantity | Location
1 | 123 | 100 | 4
1 | 234 | 100 | 4
I need a userform to search for all occurances of the product code and display the Component Code, Qty and Location on each row.
However, I need to be ale to edit the Quantity and Location for all of the results in the user form.
Is this possile?
Bookmarks