Fullført

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.

Ferdigheter: Databehandling, Excel, Programvarearkitektur, Visual Basic, Visual Basic for apper

Se mer: 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

Om arbeidsgiveren:
( 2 omtaler ) Calgary, Canada

Prosjekt-ID: #17395909

Tildelt til:

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 Mer

$30 USD på 1 dag
(162 omtaler)
6.7

48 frilansere byr i snitt $40 for denne jobben

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 Mer

$75 USD på 0 dager
(781 Omtaler)
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 Mer

$70 USD på 0 dager
(292 Omtaler)
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 Mer

$30 USD på 1 dag
(372 Omtaler)
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 Mer

$35 USD på 1 dag
(214 Omtaler)
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 Mer

$30 USD på 1 dag
(165 Omtaler)
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 Mer

$47 USD på 10 dager
(72 Omtaler)
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 Mer

$75 USD på 0 dager
(58 Omtaler)
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 Mer

$50 USD på 1 dag
(78 Omtaler)
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 Mer

$19 USD på 10 dager
(83 Omtaler)
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 på 2 dager
(20 Omtaler)
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 Mer

$50 USD på 3 dager
(65 Omtaler)
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 på 10 dager
(24 Omtaler)
4.8
$50 USD på 1 dag
(34 Omtaler)
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 Mer

$30 USD på 1 dag
(25 Omtaler)
4.7
$30 USD på 2 dager
(30 Omtaler)
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 Mer

$30 USD på 1 dag
(15 Omtaler)
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 Mer

$59 USD på 3 dager
(11 Omtaler)
3.8
scorpionobaid01

Hi Can we discuss this

$25 USD på 3 dager
(16 Omtaler)
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 på 1 dag
(15 Omtaler)
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 Mer

$29 USD på 2 dager
(5 Omtaler)
3.0