Завершен

Expand 3 developed projects in Excel / VBA / Macro from 5 to 10 companies data

I have 2 in 1 files for the same project.

File_1_All_Suppliers: (developed in freelancer) In this attached excel file I have to put products data from different suppliers (Sheet 1). On that time I thought 5 suppliers will be enough, but no: I NEED TO EXPAND TO 10 SUPPLIERS and maintain the procedure: DUPLICATE VALUES (will highlight all the duplicate values in sheet 1); EXTRACT DUPLICATES will transfer duplicated data to sheet 2; EXTRACT UNIQUE, will copy no duplicate data to sheet3.

ONLY NEED TO EXPAND THE FIELDS FROM 5 PRE DEFINED COMPANIES TO 10

File_2_Combine_Duplicates: (developed in freelancer) I will copy all the duplicated data from the sheet2 that I grab in File_1_All_Suppliers.

So in this file, I ALSO NEED TO EXPAND TO 10 SUPPLIERS like previous file. We should maintain the procedure: EXTRACT DATA will grab all the duplicated data and align it in sheet2 (extracted data) puting the best price in each company.

I would like, if not so heavy, to aggregate these 2 files:

In file 1 the macro will detect, extract unique values and the duplicates can go to shet2 (like right now) or go straight to the file 2. From here, the procedure will be the same.

Навыки: Excel, Visual Basic, Visual Basic для приложений, Ввод данных, Обработка данных

Показать больше: excel vba macro paste adjacent column, paste excel vba macro, excel vba macro databases, excel vba macro programming bids, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel vba macro optimization, excel vba macro protect cell, excel vba macro charts, running excel vba macro sql server, excel vba macro scripter, download historical stock data excel vba macro, excel vba macro copy columns data, convert excel vba macro standalone application, excel vba macro download yahoo stock data, excel vba macro worksheet name, select column copy excel vba macro, excel vba macro freelance

О работодателе:
( 21 отзыв(-а, -ов) ) Vila Real, Portugal

ID проекта: #24197132

Поручен:

ksriniravi

SOLUTION READY! Greetings! It is very simple and straightforward. I had some free time - I have already completed individual file updates. I can combine the 2 files into one Workbook so that it is easier to manage. I Больше

$15 USD за 1 день
(207 отзывов(-а))
6.9

18 фрилансеров(-а) готовы выполнить эту работу в среднем за $33

KulfiSoftwares

Excel VBA Expert!! I have seen the files, and understand your requirement.. I can extend the script for 10 suppliers, and also aggregate the 2 files.. ➤ZERO ERROR GUARANTEED!! Please read my ~450 reviews. I am here to Больше

$75 USD за 3 дней(-я)
(335 отзывов(-а))
7.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.

$45 USD за 1 день
(115 отзывов(-а))
6.4
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Больше

$100 USD за 2 дней(-я)
(145 отзывов(-а))
6.2
AnowarRatul

$ 19 Only ------ In just 3 Hours ----- I can expand your VBA Macro Program to get duplicate data across the files absolutely as you want by maintaining 100% accuracy of your data ----- Excel VBA Macro Coding, Formula G Больше

$19 USD за 1 день
(87 отзывов(-а))
5.1
daniyal3214

I am a specialist VBA programmer holding years of experience in advance Excle, VBA and Macro. I will be happy to discuss in detail.

$20 USD за 1 день
(61 отзывов(-а))
5.6
writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Больше

$95 USD за 3 дней(-я)
(35 отзывов(-а))
5.0
MykolaDudych

Hello :) How are you? Thanks for your posting. I have experience in writing macros VBA for Excel. Can we discuss about your project in details? Best regards

$17 USD за 2 дней(-я)
(8 отзывов(-а))
3.4
VbaStudio

Hello. I'm a specialist in Excel and VBA. I can do everything you need. ......................................................................

$30 USD за 3 дней(-я)
(2 отзывов(-а))
3.0
raheel2k29

Hi there, I have gone through the job details carefully and I am excited to start working on this Data Entry project As a Highly Com-potent Data entry Professional I would Bring self directed and energetic attitude to Больше

$30 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
unknown1543

I checked out your files data can you please give me some idea through entered data in blank sheet so i can judge all the field completely, i found this as a duplicate entry (8433281006652). I want little bit more brie Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
bramarambikavns

Hello and thank you for visiting my profile. Being a full time freelancing professional I am mostly online for communication with my clients. Freelancing is my profession as well as my passion. I have over 2 years of e Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
camargorivasga

I want to participate in the work since I have advanced excel knowledge and that makes me the best candidate

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
renato0216

Hello! I have read your requirements and very interesting your task. I'm expert in VisualBasic for application, MS office VBA (dashboard, chart, automation,...). And i can provide high quality program in excel vba. W Больше

$20 USD за 1 день
(0 отзывов(-а))
0.0
gourpradeep

Hi, I will follow your provided instructions and then put then into an excel file. I can work full-time to finish them ASAP. I will show you few samples initially. Let's discuss and start.

$20 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
CanguruWorkana

Poderemos nos comunicar em Português se for de tua preferência. Sou brasileiro e programador há duas décadas. Eu gostaria de fazer perguntas sobre este projeto para você utilizando dois arquivos Excel. Aqui no site Fre Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
Hardaskhatri

I am Hardas Khatri. I hope you are doing well! I am very much interested in your project. It will be my great pleasure to work on your project. I have checked your requirements, yes I can do it because we already work Больше

$10 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
lakshmiprabhara3

Dear Sir/ Mam, Myself Prabha, I Have gone through the task and attachment, i will complete the task 100% without any error and i have good experience in doing excel so requesting you to provide the opportunity to prov Больше

$16 USD за 1 день
(0 отзывов(-а))
0.0