Excel Macro for matching and updating quantity

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

We are using a barcode scanner to do an inventory in our stores. We will scan every item UPC code and it writes it to a txt file on the device. If we have 2 of the same item it will write UPC twice in the text file etc... I plan to copy the txt file contents to a column in the same inventory spreadsheet we will be working with called SCANNED UPCS. In the inventory spreadsheet I have all the existing product UPC codes in one column (UPCS), and descriptions and style codes in other columns - I also have a quantity column for each product called QUANTITY. I need an excel macro made that will update QUANTITY for each item based on if the UPC code is present in the SCANNED UPCS column. If there are 2 or more of the same UPC code present in the SCANNED UPCS column - it needs to make the quantity for that item 2 etc..

Also please make note in Macro where I can change the column location where it targets and writes to please.

Введення даних Обробка даних Excel Архітектура ПЗ Visual Basic

ID Проекту: #17877652

Про проект

11 заявок(-ки) Дистанційний проект Остання активність 5 роки(ів) тому

Доручено:

sloker18

I am proficient with excel macro/VBA development, I can write the macro to calculate scanned UPC, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat Більше

$30 USD за 1 день
(41 відгуків(-и))
4.8

11 фрілансерів(-и) готові виконати цю роботу у середньому за $29

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Більше

$30 USD за 3 дні(-в)
(216 відгуків(и))
6.8
daniyal3214

I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to develop highly dynamic and automated dashboards and templates for data analysis, Більше

$25 USD за 1 день
(36 відгуків(и))
5.1
tausy

Hi, I'm a software developer with over 5 years of experience working on data in many forms. I can handle your work efficiently. Let's discuss it further if you're interested. Thanks, Tofii

$35 USD за 1 день
(14 відгуків(и))
3.8
dataexplorer

"Hello, I am happy to inform you that I have read your project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working he Більше

$30 USD за 3 дні(-в)
(12 відгуків(и))
3.1
saykovdi

BI, Data Science, R Script, Pythone, VBA, SQL BI - Microsoft Power BI, Tableau. Data collection, processing and structuring Formation of reporting of all kinds, automation of the compilation process. Analysis of Більше

$25 USD за 1 день
(0 відгуків(и))
0.0