camiller722
New Member
- Joined
- Apr 11, 2017
- Messages
- 1
I'm hoping someone here can answer this question.
What I'm trying to do is set up a worksheet with product information (barcode number, item description, and unit price) to use as a databse and then set up a separate worksheet with invoice information (invoice number, product code, item description, unit price, quantity, and total). The eventual intent is that I will be able to access the workbook from our handheld scanner and scan the barcode into the workbook and have the rest of the info auto-fill so I can reference it for writing up invoices.
What I need help with is that I would like for the second worksheet, when the barcode number is entered, to auto fill the description and unit price. Even if I have to put a separate table on the same worksheet, I would be willing to do it that way, but I can't get my references to work. I even tried using a few of the formulas in some of the other threads, but can't seem to make them work. What formula should I be using?
Any help would be greatly appreciated.
What I'm trying to do is set up a worksheet with product information (barcode number, item description, and unit price) to use as a databse and then set up a separate worksheet with invoice information (invoice number, product code, item description, unit price, quantity, and total). The eventual intent is that I will be able to access the workbook from our handheld scanner and scan the barcode into the workbook and have the rest of the info auto-fill so I can reference it for writing up invoices.
What I need help with is that I would like for the second worksheet, when the barcode number is entered, to auto fill the description and unit price. Even if I have to put a separate table on the same worksheet, I would be willing to do it that way, but I can't get my references to work. I even tried using a few of the formulas in some of the other threads, but can't seem to make them work. What formula should I be using?
Any help would be greatly appreciated.
