
Completed
Posted
Paid on delivery
I have an existing Excel workbook with a dashboard sheet that displays key project metrics. I need a single button added to that dashboard—label it “Update Tracker”. When I click it, the workbook should: • Look at the unique project number that’s already selected or visible on the dashboard. • Copy the associated numerical data fields exactly as they appear—no summarising or filtering. • Paste this data into the next available row on a separate worksheet called “Tracker”, keeping the project number alongside the values for traceability. Please build this with clean, well-commented VBA so I can adjust ranges later if needed. Once done, send back the updated workbook and the macro code in a text file for reference. That’s all I need to get the dashboard and tracker working together smoothly.
Project ID: 40197808
123 proposals
Remote project
Active 2 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
123 freelancers are bidding on average £105 GBP for this job

Hi Sir Im excel vba macro and formula expert I can help you build button update tracker like you need. Please ping me for discuss more and im free now Thank you Sincerely Galih
£135 GBP in 7 days
7.9
7.9

As an experienced data analyst and Excel guru, I bring a wealth of skill and knowledge to your project. With my expertise in Excel's VBA language, I can seamlessly incorporate the "Update Tracker" button into your dashboard. This will allow you to retrieve the unique project numbers and copy over its associated numerical data fields precisely into the "Tracker" sheet as you require. I understand the importance of keeping track of valuable project metrics, and I assure you my solution will provide just that. Additionally, rest assured that I'll always leave a paper trail for future reference by providing you with clean, well-documented VBA code in a separate text file. Your satisfaction is my main drive, which is why I offer free demos, consultation, and limited editions of what you require upfront. I want you to be confident in my abilities before hiring me. Beyond the immediate completion of this task, I will also continue to support you at no extra cost in case any issues arise or if you need further assistance. Let's discuss how I can best exceed your expectations and get your dashboard and tracker working together flawlessly!
£30 GBP in 1 day
7.6
7.6

I can add an “Update Tracker” button to your dashboard that reads the selected project number, copies the exact numeric fields, and logs them to the next row in the Tracker sheet with full traceability. I’ll use clean, well-commented VBA and return the updated workbook plus the macro code in a text file.
£80 GBP in 1 day
7.3
7.3

Hello, I’ve reviewed your project requirements and fully understand that you need a seamless way to push dashboard data into a Tracker sheet with a single click. With experience in Excel VBA, macros, and data management, I can confidently create a solution that keeps all numerical values intact, traceable, and easy to manage. My approach starts by building a clean, well-commented VBA macro that reads the selected project number on your dashboard, copies the associated fields exactly as they appear, and pastes them into the next available row on the Tracker sheet. The code will be structured so ranges and fields can be easily adjusted in the future, ensuring flexibility and long-term usability. I will also add a clearly labeled “Update Tracker” button, and provide the macro code in a text file for reference. The result will be a smooth, reliable workflow between your dashboard and Tracker sheet. Are you ready to have this workflow integrated so your dashboard updates instantly at the click of a button? Lets chat and discuss further! Best Regards, Aneesa
£90 GBP in 1 day
6.8
6.8

We can add a single “Update Tracker” button to your dashboard that reads the selected project number, captures the exact numerical values shown (no aggregation or filtering), and appends them to the next available row in the Tracker sheet with full traceability. We’ll implement this using clean, well-commented VBA, structured so ranges and logic are easy to modify later. You’ll receive the updated workbook plus the macro code in a separate text file for reference. Can you share the workbook and confirm how the project number is selected or displayed on the dashboard so we can implement this cleanly and quickly?
£200 GBP in 6 days
6.9
6.9

As a seasoned professional with over a decade of experience in Python and web automation, I bring the expertise needed to successfully complete your project. My skills in data extraction, scraping, and process automation are perfectly aligned with your specific needs. I have designed and implemented various customized solutions that mirror the task at hand closely. One such project involved automating data extraction from platforms like FlashScore, Wyscout, and Fotmob, providing clean, organized data just like you need. Additionally, I've successfully managed projects involving VISA booking bots with features like stealth browsing, date selection, and 24/7 monitoring - attributes that mirror what you're looking for perfectly. Using my robust knowledge in Python and VBA coupled with my focus on result-driven solutions will ensure that your Excel workbook receives a clean yet powerful Update-Button macro. I will carefully comment on the code so that you can adjust ranges with ease if required. I guarantee a smooth fusion of your dashboard and tracker for optimal tracing capability. Let me take this off your plate and provide you with an impactful solution that's fit for your unique project tracking needs.
£100 GBP in 1 day
6.7
6.7

Hey, I’ve reviewed your project and understand you need a simple yet robust VBA solution to link your dashboard to a “Tracker” sheet. The focus will be on adding a single “Update Tracker” button that, when clicked, captures the currently visible or selected project number, copies all associated numeric fields exactly as they appear, and appends them to the next available row in the Tracker sheet with full traceability. I can deliver clean, fully-commented VBA code embedded in your workbook, so you’ll be able to adjust ranges or add fields later without confusion. You’ll receive the updated Excel workbook with the button in place, along with the macro code in a separate text file for reference. This ensures smooth, repeatable tracking of your project metrics directly from the dashboard. Best regards, Muhammad Adil Portfolio: https://www.freelancer.com/u/webmasters486
£120 GBP in 4 days
5.9
5.9

Hello, I can add a clean, reliable “Update Tracker” button to your dashboard that captures the currently selected project number, copies the exact numerical fields as displayed (no filtering or summarising), and appends them to the next available row in the Tracker sheet with full traceability. I’ll build this using clear, well-commented VBA so ranges and logic are easy to adjust later, test it to ensure it works smoothly from the dashboard, and return both the updated workbook and the standalone macro code for reference. This will neatly connect your dashboard and tracker with a single click and zero manual effort. Regards, Zafar
£20 GBP in 1 day
6.2
6.2

Hi, I will add an “Update Tracker” button to your dashboard that copies the selected project number and its displayed data, then appends it to the next row in the “Tracker” sheet. The solution will use clean, commented VBA, and I’ll provide the updated workbook plus the macro code file. Best Regards, Virendra
£45 GBP in 3 days
6.2
6.2

Hi, Thank you for considering my proposal. With over 8 years of real-world and freelance experience in Excel, I am confident in my ability to assist with your project. I have carefully read through your requirements for adding an "Update Tracker" button to your existing Excel dashboard. I would like to connect with you in chat to discuss your project further and ensure that I fully understand your needs. Please feel free to reach out so we can collaborate on this project. Regards
£20 GBP in 1 day
6.3
6.3

Hi there, ★★★ Excel VBA Expert ★★★ 10+ Years of Experience ★★★ I will complete this project by implementing a button in your existing Excel dashboard to update the tracker. The process involves the following steps: 1. Analyze the existing Excel workbook structure and identify the relevant data and dashboard components (2 hours) 2. Create the 'Update Tracker' button using Excel VBA and write the necessary code to copy and paste data (4 hours) 3. Test the button functionality to ensure accurate data transfer and implement error handling (2 hours) 4. Clean up the code with comments for future adjustments and prepare the workbook for delivery (1 hour) What I need from you: 1. Access to the current Excel workbook with the dashboard and tracker sheets 2. Any specific requirements or preferences for the button's design or location 3. Confirmation of the project number's format to ensure accurate data retrieval I look forward to connecting at your convenience to ensure the project's success. Best Regards, TechPlus Team
£250 GBP in 2 days
5.6
5.6

Hello, I’ve built several similar "Update" macros for dashboard-to-database workflows, and I can set this up for you with clean, modular VBA. I'll ensure the code is well-commented so you can easily tweak the ranges yourself, and I’ll include the logic to automatically find the next empty row on your "Tracker" sheet. I can have the updated workbook and the source code file back to you quickly.
£95 GBP in 4 days
5.7
5.7

Hi There, I am Md. Anowar Hossain, a fulltime freelancer with years of experience in Microsoft Office Program, specially VBA and Macros. I can add update Tracker button for easy to use. I am ready to start right away and will complete the task within the given deadline. I look forward to working with you. Thanks, Anowar
£40 GBP in 2 days
5.5
5.5

Hello, I understand you need a smooth way to push dashboard data into a tracker with one click while keeping everything accurate and traceable. I have strong expertise in Excel dashboards and VBA automation, and I will create a clearly labeled “Update Tracker” button that reads the selected project number, captures the exact numerical values shown on the dashboard, and pastes them into the next available row of the Tracker sheet alongside the project number. I will write clean, well-commented VBA so you can easily modify ranges later, and I always ensure accuracy, reliability, and timely delivery. Let’s get started and make your dashboard work smarter—message me to proceed.
£130 GBP in 2 days
5.6
5.6

Hi, I am excited about the opportunity to enhance your Excel workbook with a functional "Update Tracker" button. Your dashboard already showcases key project metrics, and I understand how crucial it is for you to streamline the data transfer process efficiently. With my extensive experience in Excel VBA and data management, I will create a well-commented macro that copies the relevant numerical data linked to the selected project number. This will ensure easy traceability as the information gets pasted correctly into the "Tracker" worksheet. My approach will focus on clarity and adaptability, allowing you to make adjustments whenever necessary. Once I have completed the task, I will send you both the updated workbook and the macro code in a text file for your reference. I estimate that I could have this ready in 3 days. Best regards,
£200 GBP in 1 day
5.3
5.3

Excel VBA developer, ready to do the required Dashboard to "Tracker" sheet update Button with the necessary automation VBA code .
£30 GBP in 1 day
5.2
5.2

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project not only means benefiting from my extensive skills in Excel and data analysis but also entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev
£50 GBP in 7 days
5.2
5.2

Hi there. I am very excited with your project because I have completed similar project recently. The skills required for your project are my main specialty. I can handle this perfectly and have abundent experiences. Please confirm that I am one of the best fits for you and drop me a message for further discussion. Thanks and Best Regards.
£200 GBP in 7 days
5.2
5.2

With years of experience in advanced data management and analysis, I am well-equipped to handle your project. The addition of the 'Update Tracker' button to your Excel workbook is a task that falls right within my expertise. With seasoned skills in Excel and VBA scripting, I will ensure clean and well-commented code, allowing you to easily adjust ranges if needed for your project. As an AI and Machine Learning specialist, I bring the same reliability and accuracy in handling projects at the core of data management and analysis. Data security is paramount and with my skillset, you can trust that all project metrics will be copied exactly as they appear - no summarizing or filtering. Moreover, my flexibility in using multiple programming languages including Python, R, SQL makes me adaptable to any changes your project may undergo. I'm not just here to complete the job but to do so efficiently and provide you with added value. Partner with me for a seamlessly functional dashboard and tracker that will significantly improve your project metrics tracking.
£30 GBP in 3 days
4.8
4.8

As a highly experienced and multi-disciplinary professional, I am confident I have the skills and expertise to excel at your Excel Dashboard update task. "Proficient in Excel" is an understatement for me - I am a Power User who has successfully streamlined numerous data automation tasks using VBA. With the thorough understanding of your project's requirements, I can easily write a clean and well-commented VBA script that adds the 'Update Tracker' button to your dashboard efficiently. My deep interest in data science and years of experience in programming lends itself perfectly to tasks of this nature. My prowess in Python, R and VB alongside my knowledge of BeautifulSoup will ensure that the update retrieves and copies only relevant data without any summarization or filtering, as per your specific requirement. I would love to bring all my skills as an Electrical Engineer, Data Scientist, Business Analyst, and Excel Developer together for this project. Rest assured that you will receive an update workbook with properly commented macros for easy future modification. Looking forward to helping you streamline your dashboard-tracking process with my lean solutions!
£135 GBP in 7 days
4.9
4.9

Yarm, United Kingdom
Payment method verified
Member since Jun 9, 2023
£20-250 GBP
₹600-1500 INR
$10-30 AUD
₹1500-12500 INR
£20-250 GBP
₹12500-37500 INR
₹750-1250 INR / hour
₹100-101 INR / hour
₹750-1250 INR / hour
₹400-750 INR / hour
$1500-3000 USD
₹12500-37500 INR
$10-30 USD
₹600-1500 INR
$10-30 USD
₹1500-12500 INR
₹1500-12500 INR
₹1500-12500 INR
₹12500-37500 INR
€8-30 EUR
₹100-101 INR / hour