Find Jobs
Hire Freelancers

VBA Macro - Roll up value and auto-vlookup

$10-75 USD

Completed
Posted over 5 years ago

$10-75 USD

Paid on delivery
I have an item spreadsheet that has : Item, Color, Size, Qty on Tab 1 (the data on this tab has multiple repeating records) SKU, ,Item, Color, Size on Tab 2 (the data on this tab is a lookup table) I need a macro to run and do the following : 1. Do a vlookup to Tab 2 and populate the SKU alongside Item, Size, Color, Qty on Tab 1 2. Sum up all repeating records in a new spreadsheet by SKU # and put output on Tab 3 3. Transform the data for consumable format.
Project ID: 17395909

About the project

46 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I can come up with a macro to generate Tab 3 (all records summed up based on SKU) after matching Tab 1 and Tab 2 data. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. Implemented lot of automation & handled complex voluminous workbook. Last 24 MONTHS , spent 250 HOURS on automation in Excel every month. Proposed Milestones $30 USD - Macro for Roll up Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Weekend! Srinivasan Krishnamoorthi
$30 USD in 1 day
5.0 (223 reviews)
7.0
7.0
46 freelancers are bidding on average $39 USD for this job
User Avatar
HI, I am good at Excel and vba. I can transfer the data from 2 sheets to a new sheet based on the match of 4 columns. Please share an example file with the inputs and output sample that helps. Relevant Skills and Experience Excel vba, vlookup, matching Proposed Milestones $75 USD - Milestone
$75 USD in 0 day
5.0 (964 reviews)
8.1
8.1
User Avatar
Hello Sir, I have reviewed your job details and I am sure i can deliver you the job with you satisfaction. Relevant Skills and Experience I have more than 5 year of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps. Please ping me for more discussion. Proposed Milestones $70 USD - VBA Macro - Roll up value and auto-vlookup
$70 USD in 0 day
4.9 (418 reviews)
8.2
8.2
User Avatar
My name's Paris Pallas. I will create a macro that will implement steps 1-3. What do you mean in step 3 exactly? In case this is a huge workload I may need to adjust my bid. Relevant Skills and Experience I'm an experienced and skilled Excel developer and I've completed more than 230 projects over the last 5 years. Proposed Milestones $30 USD - Deliver the final file with which you feel satisfied I'd like to talk further about this project with you whenever you're available. Please, let me know when it's a suitable time to communicate. I'm looking forward to hearing from you soon. Paris Pallas
$30 USD in 1 day
4.9 (283 reviews)
7.7
7.7
User Avatar
Hello , have read your project description and understood your requirement. I have 2.5 years experience in Excel advanced concepts like Pivot table, Vlookup, Charts, Data analyser etc. Relevant Skills and Experience Excel, Macro, Excel Formulas VBA, Macro, Proposed Milestones $30 USD - Project
$30 USD in 1 day
4.9 (477 reviews)
7.6
7.6
User Avatar
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. Best regards Relevant Skills and Experience VBA/Excel/Reports Proposed Milestones $35 USD - final delivery
$35 USD in 1 day
4.9 (287 reviews)
7.1
7.1
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Relevant Skills and Experience Willing to take up your project. Thank you, Regards. Proposed Milestones $75 USD - Task
$75 USD in 0 day
5.0 (134 reviews)
6.6
6.6
User Avatar
I shall make a vlookup to Tab 2 and populate the SKU alongside Item, Size, Color, Qty on Tab 1 and . Sum up all repeating records in a new spreadsheet by SKU # and put output on Tab 3 Relevant Skills and Experience Excel VBA Proposed Milestones $47 USD - VBA
$47 USD in 10 days
5.0 (96 reviews)
6.4
6.4
User Avatar
I can write a macro to do the necessary vlookup and to sum up the repeating records Relevant Skills and Experience I have excellent command on MS Excel. I have completed complex projects in Excel before. Proposed Milestones $50 USD - Completion of work Few of my past projects - Create a schedule for delivery trucks pick-up and drop for optimal utilization of resources based on various constraints - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites. - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs. - Built a POS and inventory management system. - Built a hotel price comparison that pulls data using the website's API. You can see the reviews of the same in my profile. Thanks, Archana
$50 USD in 1 day
4.9 (104 reviews)
6.1
6.1
User Avatar
am not a random bidder... Please ping me if you are interested with my proposal.. thank you.. Relevant Skills and Experience VBA Proposed Milestones $83 USD - final
$83 USD in 10 days
4.9 (30 reviews)
5.1
5.1
User Avatar
I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server Relevant Skills and Experience And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., Proposed Milestones $50 USD - Milestone
$50 USD in 3 days
5.0 (65 reviews)
5.1
5.1
User Avatar
Hi This is an easy work using excel formulas and VBA macro. I can use my expertise to develop all the things that your requirement has. Work with me and let's collaborate Relevant Skills and Experience I've been doing excel enhancement using vba macro for over 7 years now. I am a subject expert matter, a certified and has a strong knowledge with MS excel. Proposed Milestones $50 USD - Project Completion
$50 USD in 2 days
4.9 (48 reviews)
4.8
4.8
User Avatar
Hi Can we discuss this
$25 USD in 3 days
5.0 (23 reviews)
4.2
4.2
User Avatar
Hi, I am Microsoft excel expert and would like to help you with your project. Quality is a guarantee. Relevant Skills and Experience Microsoft excel master Proposed Milestones $10 USD - on completion of project
$10 USD in 1 day
5.0 (15 reviews)
3.6
3.6
User Avatar
Hi there! I read the project's description and I'm sure that I can help you with this and I have the knowledge to do it Relevant Skills and Experience I have a large experience working with advanced Excel, using formulas, functions, graphs, pivot tables and Macros using VBA. Proposed Milestones $30 USD - Completion of the job I perfectly know what you need, we just have to set the details and I’ll start working immediately The most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
$30 USD in 1 day
5.0 (15 reviews)
3.8
3.8
User Avatar
Hi there, by your description it is not necessary to use macros to achieve #1 and #2. As for #3 I imagine it is a export based on template, is that correct? I can certainly help you with your project, please share more details and I will gladly build you a prototype. I am at your disposal to discuss on chat. Thanks for the attention.
$59 USD in 3 days
5.0 (11 reviews)
3.8
3.8
User Avatar
I can create Macro for the Rollup and lookup values. Relevant Skills and Experience Has been working as a Data Analyst and visual basic tools is something I use on a daily basis Proposed Milestones $11 USD - Payment
$11 USD in 6 days
5.0 (6 reviews)
3.1
3.1
User Avatar
Identify the column that contains the key for the vlookup Create macro to do vlookup from tab 2 to tab 1 to get SKU on tab 1 sum up quantity by SKU and display on Tab 3 do up presentation Relevant Skills and Experience I have done a lot of work related to macros, VBA and vlookups especially for requirements such as yours. Should not take more than an hour. Proposed Milestones $10 USD - Deliver spreadsheet with macro
$10 USD in 0 day
5.0 (8 reviews)
2.1
2.1
User Avatar
To do vlook up or find duplicates record and sum up all repeating record in Tab 3 Relevant Skills and Experience excel vba for 3 years Proposed Milestones $72 USD - Project Milestone
$72 USD in 5 days
2.3 (6 reviews)
4.1
4.1
User Avatar
Done Excel vba projects before, can do it in approx 15-30 min.
$20 USD in 1 day
5.0 (3 reviews)
1.4
1.4
User Avatar
Bidding minimum to win. I have sound knowledge in excel vlookup, macros and VBA. I would be able to complete the job specified in 2 days within the specified budget Stay tuned, I'm still working on this proposal.
$20 USD in 2 days
5.0 (3 reviews)
1.4
1.4

About the client

Flag of CANADA
Calgary, Canada
5.0
5
Member since Apr 22, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.