seanjon
New Member
- Joined
- Dec 23, 2017
- Messages
- 12
Good Day - Here is my dilemma. I have user forms that I am using to keep my inventory updated. I have one to pull stock and one to restock.
I want the userform information to take the data and update the sheet (data), but I need it to be on the same row that the part numbers are on. When they pull stock from a location, I want that location qty to be updated. So, just adding the data from the userform to an empty row will not work.
I need to find the Part number, find the location that they pulled from, or where they restocked it, and update the qty accordingly.
I hope this makes sense and appreciate all help.
I want the userform information to take the data and update the sheet (data), but I need it to be on the same row that the part numbers are on. When they pull stock from a location, I want that location qty to be updated. So, just adding the data from the userform to an empty row will not work.
I need to find the Part number, find the location that they pulled from, or where they restocked it, and update the qty accordingly.
I hope this makes sense and appreciate all help.