Expert Excel Dynamic Dropdowns Creation

$10-30 AUD

Completed

Posted

3 months ago

$10-30 AUD

Paid on delivery

I'm looking for a proficient Excel expert who can create dynamic dropdowns that will automatically populate client data across rows in relevant tabs based on a formula. We currently have a single workbook with 12 tabs, each corresponding to a month of the year. I would like a template workbook that can (with minimal editing) be used in future years. Responsibilities: - Develop dynamic dropdowns across the 12 tabs. - Ensure these dropdowns are linked across the workbook to auto populate client details in subsequent relevant tabs as per selected service schedules. Specifications: - The service schedules follow varying intervals of 3/6/12/24 months. - The focus is on tracking the next service due date and auto-populating clients' information across a new row in the corresponding month based on the selected drop-down. Ideal Candidate: - Knowledgeable in Excel data linking and formula creation. - Experience in creating dynamic dropdowns. - Able to work swiftly and accurately. The end goal is to have a refined, fully functional system that allows for efficient tracking of client's service schedules and can act as a template for years to come. Your expertise will significantly streamline our operation.

Project ID: 37822418

About the project

14 proposals

Remote project

Active 3 mos ago

Looking to make some money?

Email address

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:

@zubairmbafinance

Hello I am Excel Expert and I can do this job, I will create you create dropdown that will only can use in future but it will user friendly, I have successfully completed many jobs like this in this platform. Contact I have some questions so we can start.

$20 AUD in 2 days

5.0

(16 reviews)

3.7

14 freelancers are bidding on average $23 AUD for this job

@WelcomeClient

Hi Hannah S, Ready right now, Understood I'm ready to make Excel Dynamic Dropdowns Creation. I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.pk/projects/excel/business-profit-loss-reporting-excel/reviews https://www.freelancer.pk/projects/data-entry/copy-listings-from-website-another/reviews Thanks, Umer

$20 AUD in 1 day

4.8

(175 reviews)

6.3

@umairnoor32

Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, UMAIR

$15 AUD in 2 days

5.0

(55 reviews)

4.3

@tkmaina868

Yo!, I've carefully checked your requirements and really interested in this project Expert Excel Dynamic Dropdowns Creation. I'm a full time data and statistical analyst. I have worked with many clients from the U.S. and European teams. I'm offering best quality and highest performance at the most fair price. I can complete your project on time and your will experience great satisfaction with me. I have rich experienced in PHP, Data Entry, Visual Basic, Excel and Data Processing. For more information about me, please refer to my portfolios. I'm ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Thanks

$28 AUD in 2 days

4.7

(3 reviews)

3.3

@stheven19

Hi there, I'm excited about the opportunity to assist you in creating dynamic dropdowns in your Excel workbook to streamline client data tracking across multiple tabs. Here's how I can help: . Ideal Candidate: Excel Expertise: I have extensive knowledge of Excel data linking and formula creation, allowing me to efficiently set up the required functionality. Dynamic Dropdown Experience: I am experienced in creating dynamic dropdowns in Excel, ensuring user-friendly interaction and accurate data selection. Efficiency and Accuracy: I work swiftly and accurately to deliver high-quality solutions that meet your specific requirements. End Goal: My aim is to deliver a refined and fully functional Excel system that streamlines client data tracking and serves as a template for future years. With my expertise, you can expect an efficient and reliable solution that enhances your operation's productivity and effectiveness. If you're interested in moving forward with this project or have any questions, please feel free to reach out. I'm here to help and look forward to working with you.

$30 AUD in 1 day

5.0

(3 reviews)

2.2

@Bhawnaduklan

Hi there! I am Bhawna Duklan, a professional Data Analyst. I understand that you need a freelancer who know Microsoft Excel for your project. I have gone through the project details carefully and would like to tell you that I have all the required skills (vlookup, hlookup, pivot table, macro etc.) that you posted in the description. I would like to offer myself as a candidate for the job. I look forward to hearing from you soon so we can get started on this exciting project!

$30 AUD in 2 days

5.0

(3 reviews)

2.0

@janita24

Hi Hannah S., Good morning! My name is Jane a professional research writer with skills including PHP, Excel, Data Entry, Visual Basic and Data Processing. I have over 5 years in research writing. in different subjects. I have extensive experience in the following areas; - literature review - Referencing Formatting i.e APA, Havard, MLA, Chicago, IEEE etc - writing and publishing Journals - Class management i.e finance, database, mathematics, Aleks etc - Timed tests Therefore, I am confident in my ability to deliver high-quality results for this project. I am eager to discuss further details and see how I can contribute to your team. I am happy to offer a free consultation and a 10% discount for first-time clients. Please send a message to discuss more about this project. Best Jane

$25 AUD in 3 days

5.0

(3 reviews)

1.4

@Nktarch89

How are you today? I have ✅ Full Experiences in Excel formulas, functions and VBA ✅. I read your requirement carefully and I can do your work perfectly. And I can start Your work right now. Hope to discuss with you soon. Thanks for reading my words.

$20 AUD in 1 day

5.0

(1 review)

1.0

@longpdh020420

Dear Hiring Manager, I am writing to express my interest in the Excel expert position for creating dynamic dropdowns. With my extensive experience in Excel data linking, formula creation, and dynamic dropdowns, I am confident in my ability to deliver a refined and fully functional system that meets your requirements. Here's why I believe I am well-suited for this role: Excel Proficiency: I have a strong command of Excel and have successfully implemented complex data linking and formula-based solutions in previous projects. Experience in Dynamic Dropdowns: I have hands-on experience in creating dynamic dropdowns that automatically populate data based on user selections. Swift and Accurate Work: I am known for my ability to work swiftly without compromising accuracy. My approach would involve developing dynamic dropdowns across the 12 tabs and ensuring seamless data linking to auto-populate client details based on selected service schedules. I am excited about the opportunity to contribute to the development of this system and am eager to discuss further details. Thank you for considering my application. Sincerely, Long

$10 AUD in 1 day

5.0

(2 reviews)

0.6

@theshahzaibkhan

Hello Hannah S., I am Shahzaib, a PHP expert with over 5 years of experience. I have carefully read your project requirements and am confident in my ability to create dynamic dropdowns in Excel to automate client data population across multiple tabs. With my expertise in Excel data linking and formula creation, I can deliver a refined system that will streamline your operations. Please review my portfolio at Portfolio: https://www.freelancer.co.uk/u/theshahzaibkhan and let's discuss your project further. Regards, Shahzaib

$20 AUD in 1 day

0.0

(0 reviews)

0.0

@silence2000my9

I have extensive experience in Excel data linking and formula creation, along with a proven track record in developing dynamic dropdowns. My approach ensures accuracy and efficiency in populating client details across relevant tabs based on service schedules. I am committed to delivering a refined, fully functional system that will streamline your operation and serve as a reliable template for years to come. I look forward to the opportunity to contribute to your project's success.

$20 AUD in 7 days

0.0

(0 reviews)

0.0

@mian62

Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?

$10 AUD in 1 day

0.0

(0 reviews)

0.0

@Lfernandoandrade

I am highly qualified for the position, having extensive experience in this role. With a proven track record, I bring valuable expertise to the table. I have successfully undertaken similar responsibilities numerous times, demonstrating my ability to excel in this capacity. My skills, combined with my dedication and past achievements, make me an ideal candidate for the role. I am confident that I can contribute effectively to the team and help achieve organizational goals.

$20 AUD in 7 days