În desfăşurare

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.

Aptitudini: Procesare date, Excel, Arhitectură software, Visual Basic, Visual Basic pentru aplicaţii

Vezi mai multe: 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

Despre angajator:
( 2 recenzii ) Calgary, Canada

ID Proiect: #17395909

Acordat lui:

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 Mai multe

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(157 Recenzii)
6.7

49 freelanceri licitează în medie 40$ pentru acest proiect

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(759 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(275 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(353 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(212 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(156 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 10 zile
(70 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(60 recenzii)
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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(20 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 10 zile
(72 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(43 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(65 recenzii)
5.1
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(25 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(22 recenzii)
4.7
%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(31 recenzii)
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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 10 zile
(21 recenzii)
4.7
scorpionobaid01

Hi Can we discuss this

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(16 recenzii)
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

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(15 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(15 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(9 recenzii)
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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 6 zile
(6 recenzii)
3.1