Automatically Adding info from one sheet to another over and over again in new empty Cell



I am trying to creat an excel program that keeps track of truck parts inventory.

So far I have gotten the code working to eep track of what is scanned in and out. 

I am no trying to keep a log everytime someone scans something in from sheet one and log it on sheet 2. 

I have added the excel file on here to make it easier so that you can actually open it and see what I am trying to do.

Thank you in advance



Hi Chance and welcome to the Forum 

I'm not clear on a couple of things:

1) When logging scanned items to sheet "Inventory Records", what should be recorded under the (single) column "Items In" (or Out)? The barcode, one of the corresponding entries from "Inventory List" or that plus the quantity In/Out?

2) Will you use Data Validation for the Mechanic Name (to avoid effort / the chance of errors)?

Please edit your original question to explain. (Note that other may reply and won't necessarily look at the Discussion thread).
John_Ru (rep: 1917) Sep 11, '21 at 6:09 am
Hi Chance. 
Given no answer from you, can I assume you figured it out? 
John_Ru (rep: 1917) Sep 15, '21 at 3:55 am
Chance? Not replying?
John_Ru (rep: 1917) Sep 16, '21 at 3:33 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login