VBA Macro - Roll up value and auto-vlookup

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

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

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

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

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

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

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

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

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

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

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

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

Hi Can we discuss this

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

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.

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.

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

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

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

Done Excel vba projects before, can do it in approx 15-30 min.

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.