Hi all,



I'll try not to make this to long. What I have is an inventory database. A table Inventroy transactions, which I update daily with 5-6 spreedsheet of inventory items sold. (our designed does the spreadsheet, one of the fields in the spreadsheet which is using vlookup for the product/price)

In my Inventory transaction table, I have product ID with a dropdown to select that product.

What I want to do is transfer that spreadsheet into my table, so I don't have to entry these sheets manually. Is that possible.

Keep in mind, I am a novic at excell and access.