Hi,
I am a creating an inventory database with about 100+ items. I am using a userform to select the ITEM PART via combobox, PO# via textbox and QUANTITY via textbox then enter it into my inventory database. What I would like it to do is search for the item number that was selected in the combobox in columns A1:AA1, then find the last empty row in that column and input the PO number and quantity.
My inventory database looks something like this, where as row 1 is the ITEM PARTS
<tbody>
</tbody>
What I would like it to do is if I select and enter the following
ITEM PART: Item5
PO#: 12345
QUANTITY: 1000
it would find the column with Item5 and populate as below
<tbody>
</tbody>
Any help is much appreciated!
Thanks!
I am a creating an inventory database with about 100+ items. I am using a userform to select the ITEM PART via combobox, PO# via textbox and QUANTITY via textbox then enter it into my inventory database. What I would like it to do is search for the item number that was selected in the combobox in columns A1:AA1, then find the last empty row in that column and input the PO number and quantity.
My inventory database looks something like this, where as row 1 is the ITEM PARTS
A | B | C | D | E | F | G | H | I | |
1 | Item1 | Item2 | Item3 | Item4 | Item5 | Item6 | Item7 | Item8 | Item9 |
2 | |||||||||
3 | |||||||||
4 |
<tbody>
</tbody>
What I would like it to do is if I select and enter the following
ITEM PART: Item5
PO#: 12345
QUANTITY: 1000
it would find the column with Item5 and populate as below
A | B | C | D | E | F | G | H | I | |
1 | Item1 | Item2 | Item3 | Item4 | Item5 | Item6 | Item7 | Item8 | Item9 |
2 | PO# 12345 | ||||||||
3 | 1000 | ||||||||
4 |
<tbody>
</tbody>
Any help is much appreciated!
Thanks!