Find Jobs
Hire Freelancers

Excel spreadsheet batch manipulation required.

$30-250 USD

已完成
已发布将近 4 年前

$30-250 USD

货到付款
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.
项目 ID: 25685232

关于此项目

75提案
远程项目
活跃4 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在2天之内
5.0 (16条评论)
3.5
3.5
75威客以平均价$113 USD来参与此工作竞价
用户头像
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 在1天之内
5.0 (1061条评论)
8.2
8.2
用户头像
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 在1天之内
5.0 (488条评论)
8.0
8.0
用户头像
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 在1天之内
4.9 (373条评论)
8.1
8.1
用户头像
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 在1天之内
5.0 (634条评论)
7.3
7.3
用户头像
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 在1天之内
4.9 (427条评论)
7.6
7.6
用户头像
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 在1天之内
5.0 (313条评论)
7.3
7.3
用户头像
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 在1天之内
4.9 (481条评论)
7.4
7.4
用户头像
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 在2天之内
4.9 (97条评论)
6.6
6.6
用户头像
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 在3天之内
4.8 (74条评论)
6.1
6.1
用户头像
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 在2天之内
4.9 (154条评论)
5.9
5.9
用户头像
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 在7天之内
4.9 (77条评论)
6.1
6.1
用户头像
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 在1天之内
5.0 (47条评论)
5.8
5.8
用户头像
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 在3天之内
4.8 (125条评论)
6.0
6.0
用户头像
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 在2天之内
5.0 (41条评论)
5.4
5.4
用户头像
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 在1天之内
5.0 (39条评论)
5.3
5.3
用户头像
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 在3天之内
5.0 (17条评论)
5.2
5.2
用户头像
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 在1天之内
5.0 (21条评论)
5.0
5.0
用户头像
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 在2天之内
4.9 (43条评论)
4.8
4.8
用户头像
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 在2天之内
5.0 (27条评论)
4.5
4.5
用户头像
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 在1天之内
4.6 (26条评论)
4.9
4.9

关于客户

UNITED KINGDOM的国旗
ogmore vale, United Kingdom
5.0
30
付款方式已验证
会员自6月 13, 2010起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。