automate data entry

[daril rahmatullah]

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

[#2]

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.

[#3 · Accepted solution]

Hi @daril rahmatullah,  

Is this the sort of thing you mean?

[#4]

thank you for response. would you enlight me with that, i would try it .. and hope it could be the answer i searched for.

[#5]

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)

[#6]

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/