Find Jobs
Hire Freelancers

Excel Macro Extension to worksheet

£20-250 GBP

In Progress
Posted about 9 years ago

£20-250 GBP

Paid on delivery
I have a workbook that contains lists of tasks across a couple of worksheets. This should be a straight forward project to extend for reporting. Currently there are two macros that run across the sheets and build a report based on the status and priority of projects. I want to: 1. Set up the list of sheets from data in a control spreadsheet (i.e. populate a hard coded array from a control sheet) 2. Change the titles on the report sheet automatically to reflect the status of a task. 3. Create a new routine that enables a report to be pulled out based on the owner of a task (go through the sheets, compile list of owners, use a pop-up to select and then generate the sheet) 4. Create a new routine based on the completion date of tasks - overdue, due within X days (where X is a variable that defaults to 30 days but can be user-defined) 5. Create an overview report page that shows: A. Number of tasks in each sheet by status, prioity and time B. Number of tasks assigned to each individual by status, priority and time. Attached is the current sheet for your reference.
Project ID: 7334295

About the project

15 proposals
Remote project
Active 9 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
15 freelancers are bidding on average £144 GBP for this job
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
£100 GBP in 6 days
5.0 (476 reviews)
8.4
8.4
User Avatar
HI I would like to work with you. If you think you need a good worker then you can hire me.........Thanks
£222 GBP in 7 days
4.9 (360 reviews)
7.9
7.9
User Avatar
Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
£125 GBP in 3 days
5.0 (485 reviews)
8.0
8.0
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
£147 GBP in 2 days
4.9 (332 reviews)
7.7
7.7
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
£125 GBP in 4 days
5.0 (321 reviews)
7.4
7.4
User Avatar
A proposal has not yet been provided
£140 GBP in 1 day
4.9 (263 reviews)
7.7
7.7
User Avatar
Hi: Please note that I have 100% completion rate and 5-star feedback on all projects. More than 90% of my projects are related to Excel and macro. Please connect with me to discuss more.
£111 GBP in 3 days
4.9 (176 reviews)
7.1
7.1
User Avatar
Hey, I reviewed the spreadsheet that you have attached. I am an expert in creating excel dashboards, reporting, analysis and can complete the required routines in an elegant and efficient manner. Also, please send a message to me if you would like to see some sample of work that I have done. I can assure you of quality work like I have been doing for past 6+ years as you would see my work history. I have been highly rated and recommended for solutions I provide. Please let me know if you would like me to work on this project for you and we may discuss the details and the next steps. Look forward to hearing from you. Thanks and Regards, Shikha (Automyze Consulting)
£150 GBP in 3 days
4.9 (230 reviews)
7.3
7.3
User Avatar
A proposal has not yet been provided
£150 GBP in 3 days
4.9 (162 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
£100 GBP in 7 days
4.9 (153 reviews)
6.5
6.5
User Avatar
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. I have worked on lot of advance Excel dash boarding and VBA coding using Microsoft access database, SQL, MYSQL,SQL server and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
£150 GBP in 2 days
4.9 (18 reviews)
5.7
5.7
User Avatar
I have gone through the description. I am very much interested to work on your project. I’ll I have provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST. Tasleem Naz (Female)
£200 GBP in 3 days
4.8 (88 reviews)
5.2
5.2
User Avatar
Hello I will do this job perfectly assuring professional results Ready to start the work immediately Regards
£177 GBP in 3 days
5.0 (31 reviews)
4.3
4.3
User Avatar
Hello, I work a lot with advanced formulas and VBA in the reporting environment for my regular job @Oracle as global reporting analyst so anything you throw at me, if described correctly should be no problem to fix Please let me know if you think you need me and we'll take it from there my Skype: vasilicutza Thanks!
£100 GBP in 3 days
5.0 (11 reviews)
3.9
3.9
User Avatar
A proposal has not yet been provided
£166 GBP in 15 days
5.0 (1 review)
2.1
2.1

About the client

Flag of UNITED KINGDOM
Ashtead, United Kingdom
5.0
23
Payment method verified
Member since Mar 13, 2005

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.