Find Jobs
Hire Freelancers

help improve an excel document

$30-250 USD

Completed
Posted about 3 years ago

$30-250 USD

Paid on delivery
I am a teacher and I have created a template excel file, and I will be asking other teachers to fill in the file. Once they have done so, they will send it back to me and I will copy and paste the data into another master file and run a macro that I have created and it edits the data and produces 1 document. But, there are a bunch of other things I would like my macro to do. I'm not sure if all these things are possible: - Instead of producing 1 document, produce multiple documents, based on the amount of columns in the template excel file - and save them separately with different names, possibly in different folders - Also, password protect multiple tabs in the output documents - some with different passwords to one another - Also I have another macro that prints something, but the user has to select the area - I'd like the macro to automatically select a desired area automatically so the user does not have to select the area - Also, in the final output document, I'd like to delete the macros, so the end user can only use the print macro - Also, I'd like the macro to be edited, so that it resizes columns in the output document, if they are not wide enough to see certain information - Also, in the template file, which I'll send out to other teachers - I am worried that they might not be very good with excel and I want to minimize errors they might make. So, to create some error messages or dropdown boxes based on things they input in other areas of the document. I'd like to know how much this would cost to do - can you list the prices per part if possible - just because I am doing this myself and don't have that much of my money to spend on it - my school won't pay for this help.
Project ID: 28952808

About the project

20 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$0 USD in 3 days
4.9 (360 reviews)
8.1
8.1
20 freelancers are bidding on average $109 USD for this job
User Avatar
Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + 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 Digital screencast
$180 USD in 3 days
4.9 (417 reviews)
8.3
8.3
User Avatar
Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project. Also, I can send some of my VBA apps. I can complete your job successfully in your mind. Wishing for your response. Let me try at your job. Thanks
$200 USD in 1 day
4.9 (119 reviews)
6.3
6.3
User Avatar
✅ Expert on Advanced Excel ✅ Hi there! I can help you to develop the master template as on your requirements. I’m expert on Advanced Excel, VBA, Macro, Power Query, Power BI, User Form, Login Form, Pull API/JSON/XML/Live Data, Pivot Table, Graph & Chart, Dynamic Dashboard, Conditional Formatting, Data Validation, Drop Down, Advanced Filter, Finance & Accounts and Microsoft Advanced Excel Automation related various administration tasks. Familiar with DATEDIF, SUBTITUDE, VLOOKUP, HLOOKUP, FIND, SUMIF, SUMIFS, COUNTIF, COUNTIFS, IF, NESTED IF, AND, OR , CONCATINATE, INDEX, MATCH LEFT, RIGHT, MID, ARRAY, AVERAGE, AVERAGEIFS etc. Gantt Chart, PERT Chart, Column Chart, Line Chart, Pie Chart, Doughnut Chart, Bar Chart, Area Chart, XY (Scatter) Chart, Bubble Chart, Stock Chart, Surface Chart, Radar Chart, Combo Chart etc Knock me over chat. So, we can discuss more about this project and start work. I hope to hear from you soon! Kindest regards, Aquib Javed
$200 USD in 5 days
4.9 (72 reviews)
5.8
5.8
User Avatar
Hello, I went through the details of the project. Contact me and send me your file and I will take look This can be done and I will provide some ides to solve your issues. I look forward to hearing from you thanks regards thushara
$150 USD in 3 days
5.0 (33 reviews)
5.0
5.0
User Avatar
Get it started now. Hi, Greetings for the day! ✅checked your project details: Improve excel doc using vba. consolidate data to master file ✅Completion Time: On project deadline I have worked on 300 + Projects. I have 7 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. 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 service includes: 1. Coding with proper comments for future use 2. Suggestions on improvement areas apart from client requests 3. First time configuration at right time My Portfolio Items: https://www.freelancer.com/u/FaiziTechy 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 Hydru P Automation Expert
$30 USD in 1 day
5.0 (10 reviews)
4.5
4.5
User Avatar
Hi. I'm a specialist in Excel and VBA. I can complete with my knowledge the remaining parts of your code to achieve all goals.
$30 USD in 7 days
4.9 (11 reviews)
3.8
3.8
User Avatar
Hi, I will provide you perfect work. Sure we will work again and again on upcoming tasks as well....
$111 USD in 10 days
5.0 (6 reviews)
3.1
3.1
User Avatar
I have over twenty years experience in Excel and can write the macro that you want. As I am looking for my first completed job on this site I am eager to do a great job for you to start building my reputation.
$120 USD in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
hi, looking for an opportunity, I am new to freelancer and seeking opportunity to prove my skill and ability.
$56 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I am a student, I pursuing my PG in 3rd semester, I have done more these type work before joining the freelancing .
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have superb typing speed. Excellent attention to detail and is able to juggle a variety of tasks whilst maintaining exceptionally high standards of work & reliability
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hii, I am certified data entry operator. I am interested in your job request. I Will provide you the best service at low cost.
$112 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
The project you have assigned is simple and it can be completed within a day , where I have an experience of working under this kind of projects so I kindly regard you to assign this project to me .
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I worked in such institution where such type of work are routine based. so decided to do it as a freelancer as well.
$139 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very hard working person and I always try to complete my work before timeline. please give me a chance to show my skills to you.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Dear! I have read your project; it’s quite simple and easy for me. I am interested in doing this job. I have more than 10 years of experience in data entry, typing, editing, image editing, photoshop editing, MS Office, copy pasting and conversion of files from one format to other formats. Consider me for this job if you want quality work with high accuracy of data within a time. Best Regards, Arif Mehmood AEO
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MALAYSIA
Semenyih, Malaysia
5.0
1
Payment method verified
Member since Jan 16, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.