I have taken on an overcoming task of trying to help a friends charity make an inventory process more efficient. I have landed myself in over my head on VBA programming and am in need of help.
I have a page that they enter in the stock number and press submit. On submit, I want it to search the inventory database column with the stock number and find it, then cut the whole row over to an "out of inventory" sheet and delete the cut row.
I have my data in a sheet called "CheckOut_Form" with the "btnsubmit" for submit and the data entered cell of "C2"
I want the C2 cell to be searched against sheet "Inventory" column "A".
Then cut that row over and add it to the next open line in sheet. "removed_Inventory"
finally the empty row deleted in the "inventory" sheet
Please and thank you for any help in advance.
I have a page that they enter in the stock number and press submit. On submit, I want it to search the inventory database column with the stock number and find it, then cut the whole row over to an "out of inventory" sheet and delete the cut row.
I have my data in a sheet called "CheckOut_Form" with the "btnsubmit" for submit and the data entered cell of "C2"
I want the C2 cell to be searched against sheet "Inventory" column "A".
Then cut that row over and add it to the next open line in sheet. "removed_Inventory"
finally the empty row deleted in the "inventory" sheet
Please and thank you for any help in advance.