VBA Project for Automated Reporting

$30-250 USD

Slutfört

Publicerad

fyra månader sedan

$30-250 USD

Betalning vid leverans

I need to create a reporting module from a csv file. I will provide you the input csv and the target XLSX output The file you will have two tabs: 1) a dashboard with some information and buttons and 2) hidden config page with a dictionary for naming conventions and filter for column header and values that will be used to suppress records from the reports. The dashboard will be locked and show a PC signature, a place to enter a key, valid until field, and a button to run report. When the user clicks the button, if there is a valid key, a dialog will open to prompt the user to upload a csv. The PC signature you need to grab via VBA different metrics of the CPU, OS, and whatever else in order to make a PC signature. When a user opens the excel file, he will need to send me the PC signature. I need you to make a second xlsm file that will allow me to enter the oc signature and a expiration date then create an incrypted key. Then the user will enter the key, click apply, and then will see the date change and will be able to run unlimited reports until the expiration date. When the user clicks run, and selects the csv, you should validate that the csv is correct and show an error if not. Then you will basically create the XLSX file as I will share. The report will be a separate file. Let me know your questions and include watermelon in your bid so I know you read this.

Excel

Visual Basic for Apps

Project ID: 38547684

Om projektet

51 anbud

Distansprojekt

Senaste aktivitet fyra månader sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

Tilldelad till:

@GdevDataSceince

Watermelon! Your VBA project for automated reporting requires an expert, and I assure you, my 14 years of experience includes extensive work with Excel. My mastery of Excel VBA, Macros, Pivot Tables, Power Query and more will ensure I can handle your task with ease. I'm highly capable at validating and analyzing data and then creating reports precisely as required. I can use Python, which is perfect for the task you have in mind. Additionally, your project asks for you to find the PC signature metrics using VBA for security purposes. My deep understanding of Microsoft Office Suite allows me to create well-functioning mechanisms to meet your unique needs - creating a separate key generator file and allowing unlimited report runs with specified expiration dates. Lastly, as a data analyst, I am adept at managing large amounts of data in the most efficient way possible. This would be essential for your project from the point of uploading the csv files to creating the XLSX files correctly. My skills extend to ensuring that data is clean, correct and ready for analysis. I'd love to discuss this project further with you so we can get started!

$100 USD Om 7 dagar

5,0

(15 omdömen)

4,8

51 frilansar lägger i genomsnitt anbud på $142 USD för detta uppdrag

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

$180 USD Om 3 dagar

4,9

(538 omdömen)

8,5

@Tanmoy236

"I am an Excel Expert with Professional experience working with Excel VBA Macro Coding, Formula Generation and Automation/scripting. Developing and designing complicated VBA/Macro programs are part and parcel of my daily work. Completed more than 350+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadlines and do not compromise on quality. Profile Link: https://www.freelancer.com/u/Tanmoy236 I am a startup founder of one of the largest startups in my country. I work part-time to make a few extra bucks to support my expenses. I understand the value of time and quality and I can assure you I will ensure your satisfaction. You do not need to pay me a penny until you are 100% satisfied. Profile Link : https://www.freelancer.com/u/Tanmoy236 Thanks"

$150 USD Om 2 dagar

4,9

(270 omdömen)

7,1

@daniyal3214

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.

$50 USD Om 1 dag

4,8

(247 omdömen)

7,4

@SShtv

Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.

$250 USD Om 5 dagar

4,9

(137 omdömen)

6,7

@snehamehta525

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh

$250 USD Om 3 dagar

4,8

(55 omdömen)

6,0

@merinsinha

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.

$140 USD Om 7 dagar

4,8

(145 omdömen)

5,7

@zu02

Hi there I was very interested in your MS Excel project. I can code this via Excel or via Access. I'm an Access/Excel/SQL/VBA expert and a mathematician from Georgia- a full-time freelancer. I have been coding for over 20 years in this field. Please visit https://www.freelancer.com/u/zu02?w=f Here you can also find reviews such as: "Zurab is an MS ACCESS genius","Zurab is Messi of Office" etc. If you award me the project, I’d be pleased to discuss this further and get started for you as soon as possible. Thanks! Zurab

$250 USD Om 7 dagar

4,8

(33 omdömen)

5,7

@faisal9263

Watermelon Dear client, I can create the reporting module as specified, ensuring seamless integration of CSV data into a locked XLSX output with a dashboard and hidden config page. The PC signature will be securely captured via VBA, and I'll develop an additional XLSM file to generate encrypted keys for validation. The system will check CSV file correctness and upon validation, generate the required report. I’ll ensure accuracy, security and smooth functionality, meeting your requirements. Please share the CSV and XLSX files to begin. Looking forward to working together. Let's discuss further.

$150 USD Om 1 dag

5,0

(24 omdömen)

5,5

@stheven19

Watermelon , veo que eres de colombia, si quieres conversamos en español. As a dedicated Excel and VBA expert with a strong focus on automation, I am confident that I have the skills and experience necessary to excel in your project. Having completed over 20 projects on renowned online marketplaces, I have had plenty of opportunities to master complex Excel tasks and streamline reporting processes - just as you require with this project. By leveraging my strong understanding of macros, pivot tables, and data validation, I can develop a robust reporting module from the provided csv file that allows you to generate customized reports effortlessly.

$50 USD Om 1 dag

4,9

(27 omdömen)

5,0

@ZohaibRoy

❇️ VBA Automated Reporting Module ➡️ "Do you Need to streamline your CSV reporting process? ⏺️ I can create an automated VBA module that will transform your CSV input into a well-organized XLSX output. This module will feature a secure dashboard with PC signature verification, a key entry system, and user-friendly buttons for running reports. You'll be able to filter data according to your naming conventions and suppress unwanted records, ensuring only the critical information gets reported. With my expertise in VBA, Excel automation, and data validation, you'll get a reliable reporting tool that saves time and reduces errors. Let's chat about your needs and get this project rolling!" ### Let's get started! ------------------------------------------------ ➡️ Here are some of my relevant Projects: ✅ CSV to XLSX Converter ✅ Excel Dashboard Creator ✅ VBA Secure Key Module ✅ PC Signature Generator ✅ Data Filtering and Naming Convention ✅ Automated Report Generator ✅ Hidden Config Page Implementer ✅ Excel Button Functionality ✅ Data Validation and Error Checker ✅ VBA Dynamic File Generator --------------------------------- Waiting for your response in chat! Best Regards, Zohaib ---------------------------------

$250 USD Om 2 dagar

4,9

(12 omdömen)

5,1

@vw1514518vw

Like 2 slices of "Watermelon" , 2 DELIVERABLES, The Excel report generator and the Key generator tool. Ready to create the required reporting module from a csv file. the dashboard, the config/settings tab and the generating of output .xlsx report and the security key generator, keys are linked to PC signature and expiry date set. most welcome. CHEERS

$250 USD Om 3 dagar

4,9

(12 omdömen)

4,6

@arslanu2

Hi! We are proficient in MS Excel, Google Sheets, Spreadsheet accounting, and its use in business and analysis. We can enter, arrange, analyze, as well as present your data with accuracy. Please contact back for completion of your work in time and within budget. Regards McKenzie Business Solutions

$250 USD Om 7 dagar

5,0

(2 omdömen)

4,1

@arunodaya123

Hello, Watermelon I am a senior VBA developer with 15+ years of experience in automating Excel tasks, including reporting modules, dashboard creation, and data manipulation. I’ve reviewed your project requirements and am confident in delivering a secure and fully automated solution. Key Features I Will Implement: Dashboard Creation with user input fields and validation for a seamless experience. CSV Validation to ensure data integrity before processing. PC Signature Capture leveraging system metrics to generate a unique identifier. Encrypted Key Mechanism for access control, including automated expiration management. Automated XLSX Report Generation following your specifications, with a locked and professional design. I’ll ensure this module is user-friendly, efficient, and secure for your reporting needs. Looking forward to your response!

$60 USD Om 3 dagar

5,0

(8 omdömen)

3,0

@CongJP

Hello I am a Vietnamese person with 8 years of experience in Excel, and Excel VBA especially data conversion/ analysis, and user interface. I am interested in your task and would like to apply. If possible please discuss this in more detail. Thank you.

$140 USD Om 7 dagar

5,0

(4 omdömen)

2,7

@excelthamizha

Having read your project description in detail and understood your requirements thoroughly, I am confident that I am the best candidate for this VBA automated reporting project. My extensive experience, profound knowledge of Excel and VBA/Macro programming (including the skills required to manipulate csv files), and dedication to delivering high-quality solutions will ensure we achieve the results you desire. Over the past 9 years, I have had hands-on involvement in several challenging projects with a focus on streamlining processes via automation. A particular project that aligns with your needs is my creation of an inventory management system for a retail company that involved handling large csv files, dynamically filtering data based on certain criteria, and generating insightful reports. These skills parallel what needs to be done in this job. In conclusion, my extensive background in Excel coupled with my consistent track record of exceeding clients' expectations make me a perfect fit for this task. With my deep knowledge of VBA scripting and ability to create efficient, user-friendly dashboards and reports, I am excited to tackle this project for you. The use of the keyword 'watermelon' let's me know you've read everything so drop me a message if you'd like to hear more!

$140 USD Om 1 dag

5,0

(4 omdömen)

2,5

@mauhoa3

☑️ Expert of Excel, ExcelVBA, Macro, Data Processing HERE ☑️ Hello I am a senior developer with enough experiences on Excel, ExcelVBA, Macro For 7+ years. I have full confident to complete your project. I can work by full time for your project and trying to satisfy the requirements. I would appreciate if you give me more spec via private chat. Thanks Regards.

$30 USD Om 1 dag

5,0

(2 omdömen)

2,1

@Sotn

⚛️ Expert for Excel and ExcelVBA, Macro, Data Processing able to start right now ⚛️ Hello, I am senior developer with enough experiences on Excel and ExcelVBA, Macro, Data Processing For 7+ years. so I have confident to complete your project. I can work by full time for your project and trying to satisfy the requirements. I am designing the project from scratch and structure it well. "Client's idea + Programmer's robust coding is the perfect result" This is my idea. If you want to the perfect result, please contact with me. Thanks Be regards

$30 USD Om 1 dag

2,4

(1 omdöme)

2,6

@panduputra1

Hi there! Watermelon I’m ready to help you build a custom reporting module from your CSV file and set up the associated encryption system. Here’s a brief overview of my approach: Reporting Module: - Dashboard Setup: Create a locked dashboard with a PC signature, key entry, and report button. - PC Signature: Use VBA to gather system metrics for a unique PC signature. - CSV Validation: Implement error handling to validate the CSV file format and contents. - Report Generation: Generate the target XLSX file based on your specifications. Encryption System: - Key Generation: Develop an XLSM file to generate encrypted keys based on PC signature and expiration date. - Key Validation: Ensure the key is validated and applied correctly, with access granted until the expiration date. Why Choose Me: - VBA Expertise: Advanced skills in VBA for custom functionality and encryption. - Attention to Detail: Ensuring all features, including validation and encryption, work flawlessly. - Efficient Delivery: Quick turnaround while maintaining high-quality standards. Questions: Can you confirm the CSV format requirements and any validation rules? I’m available to start immediately and look forward to creating a robust solution for you! Best, Pandu

$30 USD Om 1 dag

5,0

(2 omdömen)

1,2

@ajayyadav98570

Hi, my name is Ajay, and I'm excited about your project. As an expert in Excel formulas and macros, data analysis, extraction, summarization, visualization, and having intricate knowledge of VBA as well, I have precisely what it takes to automate your reporting process. Combined with extensive experience working with large datasets from various sources, including CSV files, I can assure you a robust and efficient solution that meets your specific needs.

$90 USD Om 1 dag

5,0

(2 omdömen)

0,4

@emdi85

With over 8 years of experience as a FullStack developer, I've gained a profound understanding of digital elements. I have a significant expertise in Excel including its VBA and therefore possess the skills required to effectively fulfill this task. My keenness for clean code ensures optimized performance and its easier maintenance. I am comfortable working collaboratively to solve problems by understanding user expectations and delivering beyond par solutions. One aspect that sets me apart is my ability to work productively with large data sets, as often required in complex automated reporting tasks, ensuring reliable and efficient results. My extensive knowledge in handling different file formats proficiently equips me to validate CSV files accurately before generating the desired XLSX reports. I'm also proficient with encrypting sensitive data. In this case, on top of securing report access, I can assist you in generating encrypted keys with distinct expiration dates thereby enabling tight access control. Furthermore, my familiarity with your project tools including VBA and my past experiences dealing with report generation projects makes me an excellent fit for this job. My commitment to producing scalable applications that promote an enriched user experience aligns coherently with your requirements."Watermelon" is hereby included in my bid :)

$140 USD Om 7 dagar