Ολοκληρωμένο

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.

Ικανότητες: Εισαγωγή Δεδομένων, Επεξεργασία Δεδομένων, Excel, Αρχιτεκτονική Λογισμικού, Visual Basic

Περισσότερα: 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

Σχετικά με τον Εργοδότη:
( 0 αξιολογήσεις ) United States

Ταυτότητα Εργασίας: #17877652

Ανατέθηκε στον:

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 freelancers κάνουν προσφορές κατά μέσο όρο $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
royalcalif

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 Περισσότερα

$30 USD σε 1 μέρα
(84 Αξιολογήσεις)
5.5
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
jsb1156

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 Περισσότερα

$15 USD σε 2 μέρες
(13 Αξιολογήσεις)
3.7
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
$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
$50 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
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
$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0