Jlamarre
New member
- Joined
- Nov 29, 2018
- Messages
- 22
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hello all. 1 post so please tell me if I'm not doing this correctly.
I'm not at work at the moment. I did read in other posts that having a real file to work with helps. I'll get to that tomorrow.
I have a file where my staff will scan a product (barcode) and input the quantity that is on the shelf. I have a vlookup that gets information from a Sql file (min/max, description of the product, etc). If I see that I need to order more I create a purchase order in our software. I have the information from the table where the orders are placed and I can see if a line has been received. What I can figure out is how to make the search. PO and Product number then fetch the column that has the received information.
Thanks for your feedback.
Oh I have no experience with VBA and macros. But have literally started reading on the subject.
JL
I'm not at work at the moment. I did read in other posts that having a real file to work with helps. I'll get to that tomorrow.
I have a file where my staff will scan a product (barcode) and input the quantity that is on the shelf. I have a vlookup that gets information from a Sql file (min/max, description of the product, etc). If I see that I need to order more I create a purchase order in our software. I have the information from the table where the orders are placed and I can see if a line has been received. What I can figure out is how to make the search. PO and Product number then fetch the column that has the received information.
Thanks for your feedback.
Oh I have no experience with VBA and macros. But have literally started reading on the subject.
JL