Forum Discussion
Solved
automate data entry
hi,
i work on a lot of inventory data entry and still do it manually. this is how i do it, ctrl+F the product name, and enter the amount of product inventory on the next cell. is there any way to eliminate searching steps? and automate it?
thank you for the help
i work on a lot of inventory data entry and still do it manually. this is how i do it, ctrl+F the product name, and enter the amount of product inventory on the next cell. is there any way to eliminate searching steps? and automate it?
thank you for the help
5 Replies
- thank you for response. would you enlight me with that, i would try it .. and hope it could be the answer i searched for.
- The formula is
=INDEX (tblInventory[Inventory], MATCH( I5, tblInventory[Product], 0) )
for more details on this check out my blog here
https://accessanalytic.com.au/index-match/
What is the source of information? It seems to me that is a crucial factor to automation. e.g., being able to scan a barcode or even a packing slip that contains the product name and quantity.
- thank you for the response. its a inventory stock report, that i must update it every month. actually ive developed some automation in client side, using google forms, but the server side, i found it hard to meet the report requirement using excell. so i must put it manually every month.
client - order <g forms> - submit - spreadsheet - collect by warehouse officer. >>> entered manually in excell (head office has not yet develop this step)
