Find Jobs
Hire Freelancers

Excel Macro/VBA - Summarize Table Data and Lookup New Fields

$30-250 USD

Completato
Pubblicato più di 5 anni fa

$30-250 USD

Pagato al completamento
I need to manipulate a data file I will receive each month (similar to attached). The data file includes a list of managers (Column B-D) and all of his direct reports (Columns H-AB). I want the file to create a table from the original showing a summary table detailing each managers direct reports on a seperate row (see summary sheet for example). The example below has 3 rows of data, but the actual file may have >30,000 rows, so the Macro must be able to handle many rows. Once the summary sheet is created, it should vlookup data from the Details tab to the Summary Sheet for 3 columns. The final summary sheet should include a list of each manager and each individual direct report on a separate row, as well as the 3 columns of vlookup data.
Rif. progetto: 17489899

Info sul progetto

17 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Hello, I can help to deliver this with quick turnaround. Looking to hearing from you soon. Kind regards, Rina
$55 USD in 3 giorni
5,0 (98 valutazioni)
6,2
6,2
17 freelance hanno fatto un'offerta media di $105 USD
Avatar dell'utente
Hello, I can help with you in your project Excel Macro/VBA - Summarize Table Data and Lookup New Fields I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 370+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$160 USD in 3 giorni
4,9 (349 valutazioni)
8,0
8,0
Avatar dell'utente
Hi, my name is Selim. I read your "Excel Macro/VBA - Summarize Table Data and Lookup New Fields" project descriptions carefully before bidding. I checked the attached template as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$150 USD in 3 giorni
4,9 (326 valutazioni)
7,9
7,9
Avatar dell'utente
Hello. I have good skills in Excel/VBA. I have read your project description carefully and i can do it. Contact me please. Thanks........................
$155 USD in 3 giorni
4,8 (100 valutazioni)
5,9
5,9
Avatar dell'utente
Hi, Being experienced in handling excel functions/vba macro related tasks extensively, I can take up the task to complete quickly and efficiently. I assure you of quality work and making any other minor changes as per your need, if any. Waiting for your response to take discussion forward to start the work. Thanks.
$45 USD in 1 giorno
4,8 (111 valutazioni)
5,9
5,9
Avatar dell'utente
Hi - I have built complex macros that manipulate csvs of over a million rows in size so what you have mentioned does not sound scary to me. Lets discuss if you are interested and take it forward. Regards,
$138 USD in 3 giorni
4,9 (26 valutazioni)
4,8
4,8
Avatar dell'utente
hello there I am an excel vba developer and expert with experience in working on various of projects of dynamic vba utilization as for your project here I have code to split and vlookup using vba as per your project needs and I utilise code which can hand multiple rows but also not affect the performance I will arrange all the tabs/sheets of summary and others as per your requirements Hope to hear back from you
$66 USD in 4 giorni
4,7 (11 valutazioni)
3,6
3,6
Avatar dell'utente
I have been programming for more than 20 years in Excel VBA macros. Please contact me via chat if you have any questions.
$55 USD in 1 giorno
4,9 (13 valutazioni)
3,3
3,3
Avatar dell'utente
Hello, I am an excel expert with 10+ years of experience in generating reports from excel. I have 200+ reviews on my profile & I can provide you best results within given time & budget. Vlookup for VBA, I have done these tons of time in my career. I am an expert on it. My expertise are Excel, Advance excel, VBA, Macros etc.
$80 USD in 0 giorno
5,0 (1 valutazione)
0,0
0,0
Avatar dell'utente
Hey! I'm John Alexander I have reviewed your complete job description. I have fully understood your requirements and I fulfill all the qualifications required for this project. Quality work is my Priority. Let’s discuss rest details over chat. My Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps THANKS Regards John Alexander
$50 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Excel Automation using VBA and DB Solutions with ACCESS / Excel Training (Basic, Adv & VBA/MACRO) I worked in various engineering companies where i was responsible for processing engineering data generated from various surveys / data extracted from various data modelling softwares eg PDS, STAAD, SP3D etc and converting it into information specially using EXCEL VBA. I can be helpful in providing solutions for your problems using skills a Learned during my job. I have extensively used EXCEL VBA and access database as these does not require any third party software and easy to troubleshoot and assist from remote location. I can help in extracting information from ascii files generated from software and generate report in the required format, analysing data, scraping information, etc. Iam also expert in MS ACCESS, VB, VB.net, Powerpoint, PowerBI, VISIO, VISIO Macro, AutoCAD VBA, etc.
$55 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi, i can do the job.
$155 USD in 5 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
green brook, United States
5,0
6
Metodo di pagamento verificato
Membro dal ott 31, 2016

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.