
Suoritettu
Julkaistu
Maksettu toimituksen yhteydessä
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.
Projektin tunnus (ID): 40197808
125 ehdotukset
Etäprojekti
Aktiivinen 12 päivää sitten
Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
125 freelancerit tarjoavat keskimäärin £104 GBP tätä projektia

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 7 päivässä
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 1 päivässä
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 1 päivässä
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 1 päivässä
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 6 päivässä
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 1 päivässä
6,7
6,7

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 1 päivässä
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 3 päivässä
6,2
6,2

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 4 päivässä
5,8
5,8

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 1 päivässä
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 2 päivässä
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 4 päivässä
5,7
5,7

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 2 päivässä
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 1 päivässä
5,3
5,3

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 2 päivässä
5,5
5,5

Excel VBA developer, ready to do the required Dashboard to "Tracker" sheet update Button with the necessary automation VBA code .
£30 GBP 1 päivässä
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 7 päivässä
5,2
5,2

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 7 päivässä
4,9
4,9

As an Excel expert with a strong background in Macros and VBA programming, I am an ideal candidate for your project. I understand the need for clean, well-commented VBA code that can be easily adjusted should you wish to modify any ranges in the future, and I can certainly provide this for you. Not only do I have extensive experience working with Excel and its applications, but I also pride myself on my ability to devise efficient and effective solutions to complex data management problems such as yours. With your project, I would leverage my skills in data processing, management and of course VBA to deliver a streamlined workflow that seamlessly updates your tracker based on the information on your dashboard. Most crucially, however, I guarantee customer satisfaction; not just upon delivery, but also long after the project has been completed. My support services are complimentary, so should you ever encounter any issues or require any further assistance with the solution provided, I'll be readily available to help without any additional cost. Let's get started on transforming your dashboard and tracker into a more efficient unit today!
£135 GBP 3 päivässä
5,4
5,4

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 7 päivässä
5,2
5,2

Yarm, United Kingdom
Maksutapa vahvistettu
Liittynyt kesäk. 9, 2023
£20-250 GBP
₹750-1250 INR/ tunnissa
$10-30 CAD
min £36 GBP/ tunnissa
$15-25 USD/ tunnissa
$15-25 CAD/ tunnissa
₹12500-37500 INR
₹12500-37500 INR
₹600-1500 INR
£250-750 GBP
₹750-1250 INR/ tunnissa
₹750-1250 INR/ tunnissa
£250-750 GBP
€30-250 EUR
$30-250 USD
£20-250 GBP
₹600-1500 INR
₹750-1250 INR/ tunnissa
₹600-1500 INR
₹750-1250 INR/ tunnissa
$15-25 USD