Sedang Disiapkan

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.

Kemahiran: Pemprosesan Data, Excel, Kejuruteraan Perisian, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: 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

Tentang Majikan:
( 2 ulasan ) Calgary, Canada

ID Projek: #17395909

Dianugerahkan kepada:

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 Lagi

$30 USD dalam sehari
(157 Ulasan)
6.7

49 pekerja bebas membida secara purata $40 untuk pekerjaan ini

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 Lagi

$75 USD dalam 0 hari
(759 Ulasan)
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 Lagi

$70 USD dalam 0 hari
(275 Ulasan)
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 Lagi

$30 USD dalam sehari
(353 Ulasan)
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 Lagi

$35 USD dalam sehari
(212 Ulasan)
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 Lagi

$30 USD dalam sehari
(156 Ulasan)
6.7
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 Lagi

$47 USD dalam 10 hari
(70 Ulasan)
6.0
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 Lagi

$50 USD dalam sehari
(60 Ulasan)
5.6
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 dalam 2 hari
(20 Ulasan)
5.1
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 Lagi

$19 USD dalam 10 hari
(72 Ulasan)
5.1
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 Lagi

$75 USD dalam 0 hari
(43 Ulasan)
5.3
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 Lagi

$50 USD dalam 3 hari
(65 Ulasan)
5.1
$30 USD dalam 2 hari
(25 Ulasan)
4.9
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 Lagi

$30 USD dalam sehari
(22 Ulasan)
4.7
$50 USD dalam sehari
(31 Ulasan)
5.0
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 dalam 10 hari
(21 Ulasan)
4.7
scorpionobaid01

Hi Can we discuss this

$25 USD dalam 3 hari
(16 Ulasan)
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 dalam sehari
(15 Ulasan)
3.6
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 Lagi

$30 USD dalam sehari
(15 Ulasan)
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 Lagi

$59 USD dalam 3 hari
(9 Ulasan)
3.6
Saliths

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 dalam 6 hari
(6 Ulasan)
3.1