Updating Worksheet with specific Vlookup data from a user form

seanjon

New Member
Joined
Dec 23, 2017
Messages
10
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.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
6,473
Office Version
  1. 2019
Platform
  1. Windows
I need to find the Part number, find the location that they pulled from, or where they restocked it, and update the qty accordingly.

Hi,
You have already identified likely resolution to your problem but to offer assistance it would be helpful if you could either publish the code behind the userform or better, place copy of your workbook with dummy data on a file sharing site like dropbox & provide a link to it.


Dave
 

seanjon

New Member
Joined
Dec 23, 2017
Messages
10
1604085948989.png


This is "DATA" worksheet

1604086004394.png

This is the RemoveStock userform

1604086091848.png


This is the code for the userform.

Operators are going to scan the product (it will fill in under "Scan Item Barcode", then they will scan the barcode for where they are pulling it from, and lastly, they will populate the quantity they are pulling. The black textbox's populate based on what they are scanning to ensure they are selecting the right item, location and quantity.

The barcode is a direct translation for the part number of the item, same with the location. What I am trying to do;

Once they hit enter, I want excel to find the row that the part number is on, find that location, and delete the qty from what is there.

So:

Item number scanned - 123123 - location scanned - 13A5B - Qty removing 20. Then I hit enter.
I want it to go to that part number (in this case B2) that location (F2) and subtract 23 from G2).

I dont know how to share this from dropbox, so my apologies.

I hope this is enough info. Thank you in advance for your time and expertiese.

SJ
 

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
6,473
Office Version
  1. 2019
Platform
  1. Windows
I dont know how to share this from dropbox, so my apologies.


SJ

MrExcel provides ability for you to share code using code tags which is available on the toolbar - just press VBA to add the tags & then insert your code between them.
You can also install the the Xl2BB addin to share your spreadsheet: XL2BB - Excel Range to BBCode

To share a file which is more helpful you can get a free file sharing utility like dropbox: Dropbox Basic (Free account)

Hope helpful

Dave
 

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
6,473
Office Version
  1. 2019
Platform
  1. Windows
Hi,
link works ok - will take a look asap

Dave
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,126,893
Messages
5,621,480
Members
415,844
Latest member
Reda Fouad Ramzy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top