Excel Macro for matching and updating quantity

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.

Habilidades: Entrada de datos, Procesamiento de datos, Excel, Arquitectura de software, Visual Basic

Ver más: match macro, excel find matching values in two worksheets, excel vba match column, how to compare two columns in two different excel sheets using macro, excel vba compare two columns different workbooks, excel vba compare cell values different sheets, excel macro match, excel vba index match from another workbook, macro copy paste excel applications, macro copy data excel, macro copy paste excel file, copy paste excel spreadsheet macro, copy cell excel con macro, macro move contents cell cell excel, macro find data copy cell excel, write macro cut paste excel, copy paste excel button macro, write macro excel lotto, excel vba stop updating, macro copy paste excel cell browser

Información del empleador:
( 0 comentarios ) United States

Nº del proyecto: #17877652

Adjudicado a:


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 Más

$30 USD en 1 día
(41 comentarios)

11 freelancers están ofertando el promedio de $29 para este trabajo


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 Más

$30 USD en 3 días
(216 comentarios)

Let me review the spreadsheet with few rows of data for appropriate duration and cost as well. I would like to discuss little bit more about the project. Pm me Royalcalif Hi Mr. Employer, Glad to contact with you. I Más

$30 USD en 1 día
(84 comentarios)

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, Más

$25 USD en 1 día
(36 comentarios)

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 en 1 día
(14 comentarios)

Experienced project professional, US based, MBA, EXCEL and MS Project expert; also experienced with complex formulas, LOOKUPS, PIVOTS, and charts. I would be glad to assist with your EXCEL formulas. Thanks https Más

$15 USD en 2 días
(13 comentarios)

"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 Más

$30 USD en 3 días
(12 comentarios)
$25 USD en 1 día
(0 comentarios)
$50 USD en 3 días
(0 comentarios)

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 Más

$25 USD en 1 día
(0 comentarios)
$25 USD en 1 día
(0 comentarios)