
Completed
Posted
Paid on delivery
On the attached excel sheet is a 'settlement sheet' we use globally. It's formatted in USD where highlighted. I'd like to be able to put the local currency we might be using into cell "G12" and then when I do it automatically formats the highlighted yellow cells to reflect that currency. Currently when we go from US to a different currency I have to select the cells, 'command 1' to get my dropdown menu for format cells, select number, select accounting, select currency drop down menu, choose the currency that I'll be using. It's not that difficult but it is a handful of extra steps I'm trying to alleviate and streamline. Is this possible? Would love cell G12 to be a simple dropdown menu where I can put in a data field for my most common currencies.
Project ID: 40577570
58 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
58 freelancers are bidding on average $110 USD for this job

Hello, As an experienced web service provider, I’ve had extensive exposure to diverse programming languages including PHP. This expertise puts me in a unique position to streamline the currency conversion process for your settlement sheet. Imagine the convenience of simply selecting your desired currency from a dropdown menu in cell G12, and having all the relevant cells format automatically. This is what I can deliver for you. At Our Software, we pride ourselves on providing solutions that add value to our clients' lives by automating time-consuming tasks. Your project aligns perfectly with this philosophy; I understand the hassle you go through with repetitive manual formatting. By eliminating these extra steps and leveraging the capabilities of Excel, my customized solution will save you time and effort, allowing you to focus more on core business operations. Partnering with me means prioritizing excellent customer service, attention to detail, and going the extra mile to meet client needs. I understand how important it is for your project outputs to be accurate so as not to have any mismanaged accounting records. Rest assured, I believe in bringing miracles into my works and this project will certainly be no exception. Let's work together to turn this vision into a reality! Thanks!
$180 USD in 2 days
8.6
8.6

HI there already i have checked file job is clear so please contact me then i can do it now, thank you
$30 USD in 1 day
8.7
8.7

With over a decade of experience in Full Stack Development, Mobile App Design, and Corporate Identity, I have successfully completed over a thousand projects for organizations of all sizes. I specialize in WordPress development, SAAS projects, UX/UI design, and branding. I can help streamline your currency conversion process in the settlement sheet. By creating a dropdown menu in cell G12, you can easily switch between currencies, automating formatting for yellow cells. This will save you time and effort on manual updates. I aim to deliver efficient results promptly and propose a fair rate for this enhancement. Your feedback will be crucial in tailoring the solution to your exact needs. Let's work together to optimize your workflow seamlessly.
$225 USD in 5 days
8.8
8.8

Hi, I reviewed the project and the main requirement is to automate currency formatting of the highlighted yellow cells in the settlement sheet when a currency is selected in G12. I'll implement this using Excel Macros and Excel VBA to create a simple G12 currency dropdown and a responsive macro that applies the correct Number/Accounting format to the highlighted range. I'll use a compact mapping approach for common currencies with a maintainable Data Management approach, ensuring the updates happen without manual steps. You can expect quality, responsiveness, clean work, and easy management on ongoing adjustments. Let's discuss here now.
$150 USD in 7 days
8.4
8.4

Hi there, ★★★ Excel Expert ★★★ I can create a solution that allows you to select your local currency from a dropdown in cell G12. This will automatically format the highlighted yellow cells to reflect the selected currency without the need for multiple steps. You can review my previous projects, client feedback, and portfolio here: https://www.freelancer.com/u/techplusintl Could you please clarify which currencies you would like to include in the dropdown menu? Happy to discuss the details.
$30 USD in 2 days
8.2
8.2

⭐⭐⭐⭐⭐ Streamline Currency Formatting in Your Excel Settlement Sheet ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project requirements and see you're looking for a way to automate currency formatting in Excel. Look no further; Zohaib is here to help you! My team has completed over 50 similar projects for Excel automation. I will create a dropdown menu in cell G12 for your most common currencies, allowing highlighted cells to automatically format to the selected currency. This will save you time and simplify your workflow. ➡️ Why Me? I can easily handle your Excel automation needs as I have 5 years of experience in Excel and VBA programming. My expertise includes data manipulation, formula creation, and spreadsheet optimization. Not only this, I have a strong grip on other relevant tools, ensuring a smooth and efficient process for your project. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing this with you in our chat. ➡️ Skills & Experience: ✅ Excel Automation ✅ VBA Programming ✅ Data Formatting ✅ Formula Creation ✅ Spreadsheet Optimization ✅ Dropdown Menus ✅ Data Validation ✅ Error Handling ✅ Reporting Tools ✅ Data Analysis ✅ User Interface Design ✅ Workflow Improvement Waiting for your response! Best Regards, Zohaib
$150 USD in 2 days
8.0
8.0

The Excel Currency Converter Automation project is right up my alley as a data analyst with extensive experience in MS Excel. I specialize in streamlining processes and minimizing tedious tasks, which aligns perfectly with your request of making cell G12 a simple drop-down menu. By leveraging Excel macros and formulas, I can create a solution that allows for easy conversion of currencies and automatically updates the yellow cells accordingly. In addition to my excel skills, I am proficient in data entry, analysis, and mining which are all essential for this project. My mastery of web scraping and research will enable me to gather real-time currency exchange rates from reliable sources, ensuring the accuracy and timeliness of your currency conversions. Throughout my career, I've continuously sought to improve efficiency and accuracy in data-related tasks. This is evident from my ability to provide effective solutions that save valuable time and effort. I look forward to bringing these capabilities to bear on your project and helping you optimize your settlement sheet. Let's work together to free you from the repetitive formatting process so you can focus on other important aspects of your work!
$140 USD in 1 day
7.7
7.7

Warm greetings! I specialize in Excel VBA, Macros, and workflow automation that simplify repetitive tasks and improve accuracy. With over 9 years of experience, I can create a dropdown in cell G12 that automatically updates the highlighted cells to the selected currency format, eliminating the manual formatting steps. Here's how I can help: * Add a currency dropdown with your most-used currencies * Automatically apply the correct accounting/currency format * Keep the worksheet easy to maintain and expand * Ensure the solution works reliably without disrupting existing formulas Could you share the workbook and confirm whether you're using Excel for Mac, Windows, or both, so I can ensure full compatibility?
$140 USD in 7 days
7.3
7.3

Hello, I can help automate your settlement sheet so that selecting a currency from a simple drop-down in cell G12 automatically updates all the highlighted currency cells. This can be done without affecting your existing formulas, making the sheet faster and easier to use across different countries. I have experience with Excel automation, VBA, data validation, and custom formatting, and I can deliver a clean, reliable solution that streamlines your workflow. I look forward to working with you. Best regards, Saddam
$120 USD in 1 day
6.9
6.9

Hi, I understand you want the currency selected in cell G12 to automatically update the formatting of all highlighted cells, eliminating the need to manually change the currency each time. I can add a simple dropdown in G12 with your preferred currencies and automate the formatting using Excel VBA, so every highlighted cell updates instantly while preserving your existing formulas and layout. Best regards, Muhammad Usman
$185 USD in 3 days
6.9
6.9

Hello, I have analyzed the project requirements and understand the need for automating the currency conversion process in the Excel settlement sheet. Let's chat and discuss it further. To handle your project, I will start with creating a VBA macro that will allow you to input the local currency in cell "G12" and automatically format the highlighted yellow cells accordingly. I will utilize Excel VBA along with relevant libraries to ensure seamless automation of the currency conversion process. The clear deliverables of the project will be a user-friendly Excel spreadsheet where you can easily select the desired currency from a dropdown menu in cell "G12" to automatically update the highlighted cells with the corresponding currency format. Before signing-off my bid, I would like to ask a question, i.e., would you need any specific currencies preloaded in the dropdown menu in cell G12? Best Regards, Aneesa.
$100 USD in 1 day
6.7
6.7

As a full-stack developer with a strong emphasis on automation and data management in my decade-long career, I’m confident in my ability to streamline and simplify your currency conversion process. My skills in Excel and PHP, combined with my penchant for automation, position me perfectly to develop a customized solution for you. Operating on your user-friendly layout, through an interactive dropdown menu, users will simply need to enter the desired local currency into cell "G12" and the rest of the formatting changes will be handled automatically. But why stop there with just the currency conversion? Leveraging my capability in business analytics and data integration, we can also add a feature that incorporates live exchange rates into your settled transactions. This will ensure that not only are your highlighted yellow cells formatted correctly, reflecting the chosen local currency but also aligned with the latest conversion rates for superior accuracy. Choosing me for this project will guarantee you not only a functional currency converter automation tool but also an inherent drive to understand and meet your unique business requirements. Let’s enhance your current process through a robust, efficient solution specially tailored to increase productivity while saving valuable time and effort on every currency change!
$30 USD in 3 days
6.9
6.9

Hi, Yes, this is absolutely possible and can be done without changing your existing workflow. I can update your settlement sheet so cell G12 becomes a dropdown containing your most-used currencies (USD, EUR, GBP, AUD, CAD, ZAR, etc.). When you select a currency, all designated yellow cells will automatically update their number format to the corresponding accounting/currency format—eliminating the need to manually open Format Cells each time. The solution can be implemented with Excel VBA (recommended for full formatting control) or, where appropriate, using Office Scripts if you're using Excel Online. I'll ensure the workbook remains easy to maintain, allowing you to add or remove currencies from the dropdown in the future. The deliverable will include the updated workbook, cleanly documented VBA code (if used), and brief instructions on how to customize the currency list later. This will reduce your workflow to a single dropdown selection in G12.
$100 USD in 7 days
6.2
6.2

150+ Projects | 80+ All 5-Star Ratings | 99% Completion Rate Hello, Yes, this is absolutely possible. I can configure your settlement sheet so that selecting a currency from a simple dropdown in cell G12 automatically updates the number format of all the highlighted currency cells—eliminating the need to manually change the formatting each time. You will receive: 1. A dropdown list in G12 with your preferred currencies. 2. Automatic currency formatting applied to all designated cells based on the selected currency. 3. A clean VBA or Excel-based solution that is easy to maintain and expand. 4. Preservation of all existing formulas, calculations, and workbook functionality. 5. A fully tested workbook with clear instructions for adding new currencies in the future. I have extensive experience automating Excel workflows using VBA, dynamic formatting, and advanced spreadsheet solutions. My goal is to simplify repetitive tasks while keeping the workbook reliable and user-friendly. Regards, Naresh
$100 USD in 1 day
6.0
6.0

I appreciate your need for efficiency in managing currency conversions on your settlement sheet. Automating this process to allow for seamless currency formatting will not only save time but also reduce the likelihood of errors when switching currencies. To achieve this, I can create a dynamic solution in Excel that links the dropdown in cell G12 directly to the highlighted currency cells. This way, selecting a currency from the dropdown will automatically trigger the formatting changes for all relevant cells, streamlining your workflow significantly. I will ensure that this solution is user-friendly and easily adaptable for future currency needs. Moreover, I would like to clarify a crucial point to tailor this system effectively: How do you envision the dropdown options for the most common currencies?
$30 USD in 12 days
5.6
5.6

Greeting! We can automate your settlement sheet so selecting a currency from cell G12 instantly updates the formatting of all highlighted cells, eliminating the need to manually change currency settings each time. We’re a team of 62 professionals with over 9 years of experience in Excel automation, VBA, financial models, and spreadsheet optimization. Here’s how we can help: • Create a dropdown list in G12 with your most frequently used currencies • Automatically apply the selected currency format to all designated cells • Preserve existing formulas, calculations, and accounting formatting • Build a clean, scalable solution that allows new currencies to be added easily • Test the workbook to ensure consistent behavior across all settlement sheets We’ll implement this using Excel’s built-in features or lightweight VBA, depending on your preference, so the workflow remains fast and reliable. Are you using Microsoft Excel for Windows or Mac? Should the dropdown use currency codes (USD, EUR, GBP) or full currency names? You’ll have a streamlined settlement sheet where one selection in G12 updates every relevant currency field instantly while keeping the workbook easy to maintain.
$140 USD in 7 days
5.5
5.5

Hi, I reviewed your project: Excel Currency Converter Automation. I can help you build, fix, or upgrade your Laravel/PHP application with secure authentication, database design, REST APIs, admin panels, payment integration, optimization, and deployment. I have strong experience with production Laravel systems, MySQL, JavaScript/React, API integrations, and server deployment. Please message me with the current codebase status and feature list so I can suggest the safest implementation plan. Portfolio: https://www.freelancer.com/u/irfanui Regards, Mohammad 4th Dimension Partners
$75 USD in 3 days
4.9
4.9

Will this settlement sheet be used mainly in Excel for Mac, Windows, or both? Also, are you comfortable saving it as a macro-enabled workbook (.xlsm), or do you prefer a no-macro solution if possible? Yes, this is absolutely possible. I can set up G12 as a dropdown for your common currencies and automate the formatting of all highlighted yellow USD cells so they switch to the selected local currency instantly. I’m ready to handle the dropdown setup, currency mapping, formatting rules, and make it clean enough for global use. I’m young, a fast learner, and available 24/7 to get this done quickly and correctly. Let’s have a quick chat so I can confirm the answers and review the attached sheet. Kind regards, Haroon Z.
$140 USD in 1 day
4.9
4.9

Hello there , Good evening! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in React/Redux, Angular JS, Node JS, Ruby on Rails, html/css as well as javascript and jquery. I have rich experienced in Data Analysis, Data Management, Visual Basic, Excel, PHP, Excel VBA, Software Architecture and Excel Macros. For more information about me, please refer to my portfolios. I am checking your attachment, I'll update you shortly... I’m ready to discuss your project and start immediately. 'll be using. It' Looking forward to hearing you back and discussing all details.. With regards
$155 USD in 2 days
4.5
4.5

With your Global Currency Conversion project, I can offer solutions that'll automate the currency conversion process in your 'settlement sheet'. Leveraging my decade-long expertise in full stack development, I'll design an intuitive dropdown menu in cell G12 where you can input the local currency for your most common currencies. My proficiency in PHP and Software Architecture ensures that as you simply select a different currency, the highlighted yellow cells will be automatically reformatted to reflect the new currency saving you time and streamlining the process extensively. I pride myself on delivering efficient, maintainable, and future-ready digital solutions tailored to each client's unique needs. This means I will integrate clean, scalable and robust code into your excel sheet – so much more than just a macro designed to handle your current problem; it would be an intelligently written piece of software architecture that can be built upon for varied future use-cases. My clients have found me to be a dependable communicator who deploys projects on time while maintaining an unwavering fidelity to quality. I am committed to understanding your business objectives and providing scalable solutions that don't just solve immediate issues but lay foundations for long-term success. Let's collaborate and eliminate the tedium of manual formatting procedures on your sheet!
$30 USD in 7 days
5.0
5.0

St Augustine, United States
Payment method verified
Member since Jul 12, 2026
$250-750 USD
₹12500-37500 INR
$10-30 USD
$75-100 USD
₹1500-5000 INR
£20-250 GBP
₹12500-37500 INR
₹600-1500 INR
₹750-1250 INR / hour
$25-50 USD / hour
₹600-1500 INR
₹12500-37500 INR
$250-750 USD
₹1500-12500 INR
₹1500-12500 INR
£20-250 GBP
₹50000-75000 INR
₹12500-37500 INR
₹600-1500 INR
$15-25 USD / hour