Find Jobs
Hire Freelancers

Excel spreadsheet batch manipulation required.

$30-250 USD

Imekamilika
Imechapishwa almost 4 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
I have approximately 3000 workbooks that I need a simple task completed on. I need from all the separate sheets to filter column C , EVENT_NAME by HC and copy that data into a separate sheet and create an overall master woorkbook.
Kitambulisho cha mradi: 25685232

Kuhusu mradi

75 mapendekezo
Mradi wa mbali
Inatumika 4 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hi, I have read your requirement and this can be comfortably done in Python using Openpyxl library. I have a very good knowledge on working with large number of Excel data sheets. This is going to be my first project in freelancer and i promise to deliver the best as per your need in short time.
$30 USD ndani ya siku 2
5.0 (16 hakiki)
3.5
3.5
75 wafanyakazi huru wana zabuni kwa wastani $113 USD kwa kazi hii
Picha ya Mtumiaji
HI, I am good at Excel and VBA. I have referred the csv file and image. You want to run the macro for 3000 files and filter some HC from colum C and paste the data into a new file? I can create Excel VBA macro to process all the files in a folder. Please share the file. Looking forward to work on the project. -Chandra
$60 USD ndani ya siku 1
5.0 (1061 hakiki)
8.2
8.2
Picha ya Mtumiaji
Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 USD ndani ya siku 1
5.0 (488 hakiki)
8.0
8.0
Picha ya Mtumiaji
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will filter a big number of Excel/CSV files on column C and will copy the filtered results into a Master database. I plan to use VBA code to accomplish this. The Excel file will run on PCs and will be reusable. I will charge you $100* and can deliver within a few hours (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers, I have completed nearly 400 projects successfully in 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$100 USD ndani ya siku 1
4.9 (373 hakiki)
8.1
8.1
Picha ya Mtumiaji
Hello, this is not complicated and it can be automated. I am available to start immediately, and i have few follow up questions (simple ones). If you are interested in working with me, feel free to message me and i will help you right now. Thanks, Milan
$65 USD ndani ya siku 1
5.0 (634 hakiki)
7.3
7.3
Picha ya Mtumiaji
Hello Sir Im excel VBA macro and formula Expert :) i can make tools for filter and copy data from your 3000 file and paste it into database master file and im able to start working right now Thank you Galih
$50 USD ndani ya siku 1
4.9 (427 hakiki)
7.6
7.6
Picha ya Mtumiaji
Hi, how are you?, my name is Cristian and i am Excel/VBA expert. I am available to write a fully reusable macro that does what you need. You can see my previous work and the comments that employers have left me in the following link: https://www.freelancer.com/u/elqueabandona Contact me to discuss the details. Cheers
$100 USD ndani ya siku 1
5.0 (313 hakiki)
7.3
7.3
Picha ya Mtumiaji
Dear client I understand the scope of work involved in the project. I can do it by writing script. I ensure the work will be spot on. Roy
$60 USD ndani ya siku 1
4.9 (481 hakiki)
7.4
7.4
Picha ya Mtumiaji
Hello, I can create custom php script to create master spreadsheet from 3000 workbook files. I can deliver you output file in <24 hours.
$150 USD ndani ya siku 2
4.9 (97 hakiki)
6.6
6.6
Picha ya Mtumiaji
NOTE : I HAVE EXPERTISE IN VBA AND EXCEL/MACROS. I CAN DELIVER THIS IN QUICK TIME With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed few projects which involved Programming, scripting, excel. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$70 USD ndani ya siku 3
4.8 (74 hakiki)
6.1
6.1
Picha ya Mtumiaji
Hello, I am proficient with Excel and VBA and this would be pretty simple task for me. I would really love to help you with creating one master Excel file per your instructions, I could do it relatively quick. Please contact me for more information.
$64 USD ndani ya siku 2
4.9 (154 hakiki)
5.9
5.9
Picha ya Mtumiaji
Hi There, I can help you in effective way. I have good experience in email campaign, internet searching and database management. Let's talk more in details. Please text me. Best Regards, Prakash
$100 USD ndani ya siku 7
4.9 (77 hakiki)
6.1
6.1
Picha ya Mtumiaji
Good day! I can do that in less than 24 hours, I understand that the filter is 'HC', so it's pretty clear and direct Just message me and I will start immediately
$40 USD ndani ya siku 1
5.0 (47 hakiki)
5.8
5.8
Picha ya Mtumiaji
Hi, I am experienced data analyst and macro developer. I have excellent knowledge and experience of manipulating and exchanging data in multiple sheets, using advanced formulas, critical programming, developing system for management and creating reports. I have done mostly excel vba programming jobs. So, i can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
$140 USD ndani ya siku 3
4.8 (125 hakiki)
6.0
6.0
Picha ya Mtumiaji
Hello, I can make a python script that can do this task. the script will create a master workbook from the 3000 other workbooks. the script will select the folder having all the workbooks and one by one will get the data based on the filters.
$75 USD ndani ya siku 2
5.0 (41 hakiki)
5.4
5.4
Picha ya Mtumiaji
Hi there, Need to have the HC events record pulled out from 3000 cvs files into a master file? Please contact me if this is any of what you need. I’ll be standing by to help. -Reggie
$60 USD ndani ya siku 1
5.0 (39 hakiki)
5.3
5.3
Picha ya Mtumiaji
I can help here. Been doing Excel automation with Python for 5 years. Let me know if you would like to discuss further.
$139 USD ndani ya siku 3
5.0 (17 hakiki)
5.2
5.2
Picha ya Mtumiaji
Hi there I can deliver this project to extract the information from the spreadsheets and consolidate the data. All you have to do is keep the 3000 files in a directory and click the button. Regards Reuben
$45 USD ndani ya siku 1
5.0 (21 hakiki)
5.0
5.0
Picha ya Mtumiaji
Only 30$ ------------ Hey, I can create excel macro which will make master workbook from the all the 3000 workbook after doing filter column C , EVENT_NAME by HC and copy that data into a separate sheet. Please ping me for further details.........Thanks
$30 USD ndani ya siku 2
4.9 (43 hakiki)
4.8
4.8
Picha ya Mtumiaji
I can do the job! I would generate a macro to open and filter column and consolidate in other workbook. Would also have a summary sheet with all files processed and if errors where found in that file. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$90 USD ndani ya siku 2
5.0 (27 hakiki)
4.5
4.5
Picha ya Mtumiaji
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a day. If interested, we can discuss this further on chat.
$80 USD ndani ya siku 1
4.6 (26 hakiki)
4.9
4.9

Kuhusu mteja

Bedera ya UNITED KINGDOM
ogmore vale, United Kingdom
5.0
30
Njia ya malipo imethibitishwa
Mwanachama tangu Jun 13, 2010

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.