Completed

VBA Macro - Roll up value and auto-vlookup

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.

Skills: Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps

See more: oscommerce attribute color size, vba macro excel unicode, excel vba macro paste adjacent column, vlookup return drop down list, vba code to vlookup from another workbook, excel drop down list vlookup example, vba code for vlookup function, vba code for vlookup between two workbooks, vlookup in data validation list, vba code for vlookup between two worksheets, select drop down item and use vlookup to return multiple attributes, data entry, data processing, excel, visual basic, visual basic for apps, microsoft excel, next empty cell vba macro paste, vba macro trial, vba macro generate report excel word

About the Employer:
( 2 reviews ) Calgary, Canada

Project ID: #17395909

Awarded to:

ksriniravi

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. Impl More

$30 USD in 1 day
(162 Reviews)
6.7

48 freelancers are bidding on average $40 for this job

cgullapalli

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 Exp More

$75 USD in 0 days
(781 Reviews)
7.8
schoudhary1553

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 Ar More

$70 USD in 0 days
(292 Reviews)
7.6
SBITServices

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 E More

$30 USD in 1 day
(372 Reviews)
7.3
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. Best regards Relevant Skills and Experi More

$35 USD in 1 day
(214 Reviews)
6.8
paris2785

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 exper More

$30 USD in 1 day
(165 Reviews)
6.8
MohsanEijaz

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 Ex More

$47 USD in 10 days
(72 Reviews)
6.0
periyannas

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, Rega More

$75 USD in 0 days
(58 Reviews)
5.5
archanaoswal

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 Mil More

$50 USD in 1 day
(78 Reviews)
5.8
sourabhg98

I will provide a fully functional macro as per your specifications. Relevant Skills and Experience I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg More

$19 USD in 10 days
(83 Reviews)
5.3
AlexandrUKR

please send the file and i will provide first result for your test within 24H and adjust if it will be needed within next 24H Relevant Skills and Experience >16Y experience Proposed Milestones $75 USD - the project

$75 USD in 2 days
(20 Reviews)
5.2
prabakarm23

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 Exper More

$50 USD in 3 days
(65 Reviews)
5.1
vmadhavan15

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
(24 Reviews)
4.8
$50 USD in 1 day
(34 Reviews)
5.1
jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 7 years usi More

$30 USD in 1 day
(25 Reviews)
4.7
$30 USD in 2 days
(30 Reviews)
4.9
lherreraz

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 formu More

$30 USD in 1 day
(15 Reviews)
3.8
cranius

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 m More

$59 USD in 3 days
(11 Reviews)
3.8
scorpionobaid01

Hi Can we discuss this

$25 USD in 3 days
(16 Reviews)
4.0
mrfarhanzahid

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
(15 Reviews)
3.6
dkozh

Hello. Ready to start work immediately. I fully read with your assignment and am sure that I will do it. Great experience in similar works. I try to optimize the development process as much as possible and save you tim More

$29 USD in 2 days
(5 Reviews)
3.0