Find Jobs
Hire Freelancers

Excel VBA Macro project - Macro to generate a report from data in multiple files

$30-250 CAD

ที่ทำเสร็จแล้ว
โพสต์ ประมาณ 4 ปีที่ผ่านมา

$30-250 CAD

ชำระเงินเมื่อส่งงาน
Hello, This is a Excel VBA macro project to create a macro that pulls information from multiple sheets into one report. The macro needs to gather data from a number of different uniform spreadsheets (same template) into one complete sheet. Each individual Excel spreadsheet is for a different project and all relevant data in each template will be stored on row 2 on a tab called “ExportData”. The location of the files will change (i.e. different people will be running the Report Macro) but the project spreadsheets will always be in the same folder as the Report Macro Excel file. I need a macro that will: -Be stored in an Excel file called Report. -It needs to copy line 2 on “ExportData” tab from every Excel file that is in the same folder as the Report Excel file. Note that line 2 column count is not yet known so it should pull the whole row. -Needs to pull all of these rows into the Report Excel beginning on line 2 (line 1 will be the description of what each column is). -Needs to confirm it is finished and how many files it pulled. -Needs to provide pop up warning if an Excel file does not have “ExportData” tab or similar pull error, but be able to continue once you acknowledge the error. -Needs to first clear all of the data on the Report sheet except for the row 1 descriptions (i.e. resets every time it is run). -The Report sheet needs two buttons – One being “Run Report” to run the macro, and a second button called “Clear” to remove all report data. -Needs to have notes describing what parts of the code do. -Needs to be unlocked, not password protected. Note – If you can also make a second version of the macro that only pulls information from new files added since the macro was last run - instead of deleting and re-adding everything from scratch - this would be very helpful. There are cases where a few additional reports might be added after an initial run. If you can do this please note in your response. Thank you.
รหัสโปรเจกต์: 24048784

เกี่ยวกับโปรเจกต์

29 ข้อเสนอ
โปรเจกต์ระยะไกล
ใช้งานอยู่ 4 ปีที่ผ่านมา

กำลังมองหาการสร้างรายได้ใช่ไหม?

ประโยชน์ของการประมูลกับ Freelancer

กำหนดงบประมาณและกรอบเวลาของคุณ
รับเงินจากการงานของคุณ
อธิบายข้อเสนอของคุณในภาพรวม
ลงทะเบียนและเสนอราคาฟรี
หมอบหมายให้:
รูปอวาตาร์ของผู้ใช้
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 macro that will pull data from several workbooks and will log changes. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $160* and can deliver within five days (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 having completed over 360 projects successfully in less than 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.
$160 CAD ใน 5 วัน
5.0 (526 รีวิว)
8.5
8.5
29 freelancers are bidding on average $146 CAD for this job
รูปอวาตาร์ของผู้ใช้
Hello, I can help you with your project - Excel VBA Macro project - Macro to generate a report from data in multiple files I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$240 CAD ใน 5 วัน
4.9 (554 รีวิว)
8.4
8.4
รูปอวาตาร์ของผู้ใช้
Hello, I’m 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.
$200 CAD ใน 2 วัน
5.0 (499 รีวิว)
8.0
8.0
รูปอวาตาร์ของผู้ใช้
Hi, I am an expert and guru in Financial, Math and Microsoft Office/Excel/VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database. , especially with exporting databases to and vice versa (+ automation with VBA). I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (including preparation of reparation of graphical and visualisation reports, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts). I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. With these skills, I develop financial modules including business valuation methodology & ratios* for investors (including pitch decks, business plans, due diligence, financial modules like feasibility studies, and financial projections with dynamic scenarios). *(NPV, IRR, DSCR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, ROI, LTV, Terminal Value, TWR, S-Curve, sensitive analysis, optimisation, correlation and regression)
$200 CAD ใน 5 วัน
4.9 (95 รีวิว)
7.5
7.5
รูปอวาตาร์ของผู้ใช้
Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Excel, of course, familiar. Regards, Vladimir
$140 CAD ใน 1 วัน
4.9 (200 รีวิว)
6.9
6.9
รูปอวาตาร์ของผู้ใช้
Hello, I would like to work on your project. I have a great experience using excel macros / VBA, data formatting and data manipulation in excel, working with multiple files, transferring data with/without changing the data format. I can create the macro as required also it can work only with files recently added after the latest run of the macro. Let's discuss further details on chat. Regards.
$125 CAD ใน 2 วัน
5.0 (174 รีวิว)
6.9
6.9
รูปอวาตาร์ของผู้ใช้
$ 49 CAD only ------ In just 5 Hours ------ I can build your VBA Macro Program to pull data from different files absolutely as you described, I have done this type of project before. ------- Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5* rattings ------ I can start right now, please message me to discuss more.
$49 CAD ใน 1 วัน
5.0 (384 รีวิว)
6.8
6.8
รูปอวาตาร์ของผู้ใช้
Hi, Keen to work on this project. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Google maps, sending email through Outlook, Image handling, Userforms, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 15 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$90 CAD ใน 5 วัน
4.9 (197 รีวิว)
6.8
6.8
รูปอวาตาร์ของผู้ใช้
Dear sir/madam, I have done several projects on data mining, visualization, data scrapping, and then produced cohor analysis, dashboards, market segmentation, linear discriminant analysis etc. Over the years , my work load has increased and I have a partner who worked in the quantitative finance industry in the US and also a faculty at University of Dallas, TX. Competency wise there is not much that we cannot do for such project, the rest can be discussed further when we talk. We have expert level proficiency in Excel, Tableau, Python, R , SQL, and SAS. Thanks
$200 CAD ใน 7 วัน
4.9 (198 รีวิว)
7.0
7.0
รูปอวาตาร์ของผู้ใช้
Hi employer! Really like how the project was explained in detail. I like to work in this kind of projects. I am a software developer with experience working with VBA macro for Excel. I understood the project's requirements. No problem placing the buttons in the menu. I estimate it can be done in a couple of days. Looking forward to working with you.
$180 CAD ใน 3 วัน
5.0 (65 รีวิว)
6.4
6.4
รูปอวาตาร์ของผู้ใช้
Hello, I propose the Report file to have two sheets: "Control" and "Report". The "Control" sheet is where the buttons "Run Report" and "Clear" will be located. The "Report" sheet is solely for storing the data, with row 1 for descriptions (never gets cleared) and row 2 and beyond for data pulled from other files. I would also add a checking whether the other Excel files exist in the same folder as the Report file. If not, then the macro will display a browse dialog so the user can point to a different folder where the other Excel files are. I can write second version of the macro that only pulls new information. All the requirements are clear and I confirm I can deliver those. I look forward to hearing from you. Thank you.
$115 CAD ใน 7 วัน
4.9 (105 รีวิว)
6.1
6.1
รูปอวาตาร์ของผู้ใช้
Hi there, Need to have a macro that will populate data from "ExportData" tab of raw files into the Report File? Aside from the requirements mentioned in the job post of what the Macro should do or have, for the automation to be more efficient and flexible in the long-run, I think it's better to also have a macro that will enable its user to choose the location of the "Report File" and can record all the files that it was previously processed. Please message me thus we can discuss further my last two suggestion/ addition in the macro. I'll be standing by to help. -Reggie
$120 CAD ใน 2 วัน
5.0 (43 รีวิว)
5.4
5.4
รูปอวาตาร์ของผู้ใช้
Hi there, I have good VBA experience and can write you the macro for both the conditions you have mentioned. Warm regards Reuben
$80 CAD ใน 2 วัน
5.0 (25 รีวิว)
5.1
5.1
รูปอวาตาร์ของผู้ใช้
Hi there, I am a Microsoft Certified Professional in Excel & VBA as an Expert. Have deep knowledge to handle large number of data in Multiple Excel files. Good and Deep understanding in gathering requirements. Will deliver your work within a day with 100% quality Awaiting your message.
$100 CAD ใน 1 วัน
5.0 (43 รีวิว)
5.2
5.2
รูปอวาตาร์ของผู้ใช้
Hi, I can write this script in VBA for you, also the location of files can be changing by user. I will add a setting tab in your report Excel, in this setting you can modify the location of each Excel file that needs to pull data from it, and also every time you press on "run" macro, the vba will write in front of each Excel file, if pulling data from one Excel file was successful or not. Please send me message to discuss more.
$250 CAD ใน 3 วัน
5.0 (14 รีวิว)
5.0
5.0
รูปอวาตาร์ของผู้ใช้
Hi there I am a senior software engineer with 10 years of practical programming experience. I have excellent programming and development skills in various programming languages and frameworks. I am interested in your project. I will provide an efficient, robust and well documented solution with dedicated support. I will anticipate to discuss the details to get started. Thanks Farah Saif
$250 CAD ใน 7 วัน
5.0 (34 รีวิว)
4.4
4.4
รูปอวาตาร์ของผู้ใช้
Hello i m laureat of high School of ingeneer with long expérience in the field, I can do this work, and i can do the seconde version.
$111 CAD ใน 3 วัน
5.0 (11 รีวิว)
4.1
4.1
รูปอวาตาร์ของผู้ใช้
Hello Sir, I am keen on working on this project. If you are interested can you please contact me so that we discuss the details and maybe see a sample of what the "Report" Workbook would look like , and a sample of the template data file . Thank you
$120 CAD ใน 3 วัน
5.0 (1 รีวิว)
0.7
0.7
รูปอวาตาร์ของผู้ใช้
Dear Sir/Madam, I've been working on data processing and analysis for almost five years within a worldwide well known company. I've also worked on development projects Our foremost customers are payment establishment. Therefore, accuracy and rigor are my main values. I’ll be honored to provide you with my services for this project. If you are interested to know more about my path, I’ll be happy to share with you my detailed resume. Thank you in advance for considering my proposal. Best regards, Hamza.
$130 CAD ใน 3 วัน
0.0 (0 รีวิว)
0.0
0.0
รูปอวาตาร์ของผู้ใช้
Hi got your point. I am from India I can run macro that put all your file in one sheet or book. And will do vba to copy from line 2 of each file. Will do in 2 to 3 days time Will give result. Thanks Relevant Skills and Experience Excel vba Combine multiple files Export data. Pivot_table Report generstion Multiple Pivot_table combined Database create
$77 CAD ใน 3 วัน
0.0 (0 รีวิว)
0.0
0.0
รูปอวาตาร์ของผู้ใช้
Hi, I am a Data Analyst with ample experience in data and text processing. I can start with your project immediately and finish precisely in timely manner. Please kindly contact me for more details. Thank you.
$80 CAD ใน 2 วัน
0.0 (0 รีวิว)
0.0
0.0

เกี่ยวกับลูกค้า

ปักธงของ CANADA
Calgary, Canada
5.0
1
ยืนยันวิธีการชำระเงินแล้ว
เป็นสมาชิกตั้งแต่ ต.ค. 6, 2015

การยืนยันลูกค้า

ขอบคุณ! เราได้ส่งลิงก์สำหรับเครดิตฟรีให้คุณทางอีเมลแล้ว
เกิดข้อผิดพลาดขณะส่งอีเมลของคุณ กรุณาลองอีกครั้ง
โลโก้ Freelancer Thailand / ภาษาไทย ช่วยเหลือและสนับสนุน FreelancerประเภทโปรเจคการประกวดFreelancerองค์กรแพ็กเกจสมาชิกโครงการ Freelancer ชั้นแนวหน้าการจัดการโปรเจคงานในพื้นที่Photo Anywhereหน้าจัดแสดงผลงานAPI สำหรับนักพัฒนาได้รับการยืนยันDesktop App เกี่ยวกับเกี่ยวกับเราวิธีใช้งานความปลอดภัยนักลงทุนแผนผังเว็บไซต์เรื่องราวข่าวออกสื่อทีมรางวัลข่าวประชาสัมพันธ์ร่วมงานกับเรา ข้อกำหนดนโยบายความเป็นส่วนตัวข้อกำหนดและเงื่อนไขนโยบายลิขสิทธิ์ข้อพึงปฏิบัติค่าธรรมเนียมและค่าบริการหุ้นส่วนEscrow.comLoadshiftWarrior Forum แอปโลโก้ Apple App Store โลโก้ Google Play
ไม่สามารถคัดลอกไปยังคลิปบอร์ดได้ โปรดลองอีกครั้งหลังปรับเปลี่ยนการอนุญาต
คัดลอกไปยังคลิปบอร์ดแล้ว
ผู้ใช้ที่ลงทะเบียน งานที่มีการโพสต์ทั้งหมด
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
กำลังโหลดตัวอย่าง
ได้รับอนุญาตสำหรับตำแหน่งทางภูมิศาสตร์
เซสชั่นการเข้าสู่ระบบของคุณหมดอายุและคุณได้ออกจากระบบแล้ว กรุณาเข้าสู่ระบบอีกครั้ง