Đang Thực Hiện

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.

Kĩ năng: Xử lí dữ liệu, Excel, Kiến trúc phần mềm, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: 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

Về Bên Thuê:
( 2 nhận xét ) Calgary, Canada

ID dự án: #17395909

Được trao cho:

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 Thêm

$30 USD trong 1 ngày
(157 Đánh Giá)
6.7

49 freelancer đang chào giá trung bình $40 cho công việc này

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 Thêm

$75 USD trong 0 ngày
(759 Nhận xét)
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 Thêm

$70 USD trong 0 ngày
(275 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(353 Nhận xét)
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 Thêm

$35 USD trong 1 ngày
(212 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(156 Nhận xét)
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 Thêm

$47 USD trong 10 ngày
(70 Nhận xét)
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 Thêm

$50 USD trong 1 ngày
(60 Nhận xét)
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 trong 2 ngày
(20 Nhận xét)
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 Thêm

$19 USD trong 10 ngày
(72 Nhận xét)
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 Thêm

$75 USD trong 0 ngày
(43 Nhận xét)
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 Thêm

$50 USD trong 3 ngày
(65 Nhận xét)
5.1
$30 USD trong 2 ngày
(25 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(22 Nhận xét)
4.7
$50 USD trong 1 ngày
(31 Nhận xét)
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 trong 10 ngày
(21 Nhận xét)
4.7
scorpionobaid01

Hi Can we discuss this

$25 USD trong 3 ngày
(16 Nhận xét)
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 trong 1 ngày
(15 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(15 Nhận xét)
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 Thêm

$59 USD trong 3 ngày
(9 Nhận xét)
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 trong 6 ngày
(6 Nhận xét)
3.1