Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

0

Hello, 

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

Answer
Discuss

Discussion

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: 6092) Sep 11, '21 at 6:09 am
Hi Chance. 
Given no answer from you, can I assume you figured it out? 
John_Ru (rep: 6092) Sep 15, '21 at 3:55 am
Chance? Not replying?
John_Ru (rep: 6092) 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