Find Jobs
Hire Freelancers

Consolidate several excel files in one

$30-250 USD

Completato
Pubblicato quasi 10 anni fa

$30-250 USD

Pagato al completamento
Hello, we would like to have a function/macro/etc. to read all the excel spreadsheets inside one directory, and do the following: - Create a new excel spreadsheet with as many tabs as different tabs are in all the excels - Inside each tab, we need to create the first column with the name of the source spreadsheet and as many columns as different columns in the whole set (it should be the same structure in all but we can not guarantee 100%) and all data consolidated below Samples attached. The real set of spreadsheets are 40
Rif. progetto: 5979560

Info sul progetto

15 proposte
Progetto a distanza
Attivo 10 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
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$66 USD in 0 giorno
4,9 (166 valutazioni)
6,5
6,5
15 freelance hanno fatto un'offerta media di $104 USD
Avatar dell'utente
Hi there. I have seen the attached Excel files and I can write the VBA macro in one day that would process and copy all the sheet tabs in your required order. If you are interested, I can write the macro for you and you may pay me after checking is functionality. Regards. Usman.
$100 USD in 1 giorno
5,0 (72 valutazioni)
7,1
7,1
Avatar dell'utente
Hello, Greetings from Shweta, Bangalore India. I can provide you with a simple desktop application that can get this done for you. Will provide more details if you are interested. Cheers, Shweta
$100 USD in 1 giorno
4,9 (89 valutazioni)
6,0
6,0
Avatar dell'utente
I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. However, please explain what is the source of column Ubicación in result sheet Almacenamiento (the values are Madrid)! In the source spreadsheets the appropriate values are Valgrande. In sheet Redes there are matching values (Cloud Datacenter01, Montes Sierra, etc.) Regards
$75 USD in 2 giorni
4,9 (62 valutazioni)
5,7
5,7
Avatar dell'utente
Hello, I checked your file and like to do this project. I have done many related projects and maybe do this project with cheap price, if I have more time to work on it.
$79 USD in 1 giorno
4,8 (75 valutazioni)
5,4
5,4
Avatar dell'utente
Hello, I have read your descriptions and examined the attached files, and I think I can do the work for you. The macro shall do exactly as you need , but first I need to know about the following: The sample Source 2 file contrains two sheetas as follows: "Base de Datos" and "Resumen" These two sheets contains multiple tables (or a single table, which does not start from Cell A1). What do you want the macro to do in such cases? Shall it ignore the second table, or any table that does not start from column A1? I have done several jobs like this in freelancer where the macro had to read several files from a single folder and manipulate data. So you can be sure that I'll deliver you a high quality job. With thanks & best regards Raad
$60 USD in 3 giorni
5,0 (32 valutazioni)
5,3
5,3
Avatar dell'utente
Hi, I am highly interested to your Data Entry project. I have the necessary qualification to attain your desire goal. I will follow your instruction exactly and will send you detailed report in excel sheet. So please check my profile and give me opportunity for demonstrate my career with your company. Thanks
$66 USD in 3 giorni
4,7 (2 valutazioni)
1,0
1,0
Avatar dell'utente
Hello Sir, Greetings..!! We are Octane Infosolution Pvt. Ltd. , a leading information technology services company, situated in Kolkata, India, delivering consulting and outsourcing solutions to clients across various industry verticals. We are a 15 member team equipped with a wide range of skill sets such as HTML/HTML5, CSS3, Wordpress, PHP, MYSQL, jQuery, AJAX, PayPal Integration, Paypal Adaptive Mode and Social networking. WE READ ALL YOUR REQUIREMENTS AND FOUND THAT THERE IS A MATCH WITH YOUR REQUIREMENTS AND OUR SKILL SET. Sir,Hence we are new in Freelancers,but I have got to tell you at this point of time that we have a very highly skilled team of programmers and designers who are well equipped to handle this project. So, you can expect to get the very best kind of service from us in the whole industry with a good turnaround time. That's a OIS's. guarantee . Some of our previous work specimens are as follows: As we have also some excellent guys for data procesing,so *we can do this Consolidate several excel files in one job* Some of our other PHP expertise areas are as follows: 1. HTML with responsive development. 2. PayPal Integration. 3. Facebook API. 4. Any Plugin customization. 5. HTTP to HTTPS conversion. 6. Google Maps API. 7. Video Integration. Kindly provide us a chance and we assure your time & money won't go to a waste. Looking forward to do business with you, Regards, OIS TEAM
$147 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi I am Mandar from India. Work with Tata Steel Ltd. as a Business Analyst. I am proficient in Microsoft Excel and do the same day in day out. Assure you the precise and timely delivery.
$111 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
having six years of work ex in working with excel spreadsheets, believe in delivering quality jobs to customers. if u think i am suitable please feel free to contact.
$250 USD in 7 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Dear Concern I am a data entry operator and new freelancer. I can show you my full commitment towards your jobs. I enjoy working with people. I have experience in data entry, MS Office (Word, Excel ), typing,Windows desktop, emailing, web research, Gmail, and Facebook. I will apply my knowledge to projects and aim to please the client with the results. If I hired by you I will deliver my best work at a high standard. Thank You
$66 USD in 10 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hello, I have experience in working with microsoft excel, creating intelligent and self padding that will facilitate the work of your company spreadsheets. for further information, questions, or suggestions please contact. thank you, Ronniel
$45 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: SPAIN
Santiago de Compostela, Spain
5,0
276
Metodo di pagamento verificato
Membro dal ago 6, 2003

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.