Find Jobs
Hire Freelancers

Dynamic Excel Hiding/Unhiding Button

$10-30 USD

Închis
Data postării: circa 2 luni în urmă

$10-30 USD

Plata la predare
I'm looking for a coder skilled in Excel particularly Excel 2016. This project is all about automating the process of hiding and unhiding excel rows. The key tasks involved are: - Creating a button that, when clicked, hides or unhides certain rows within the same sheet. - The rows to be hidden or unhidden must be determined by a dropdown selection. - The dropdown selection should be generated from existing data within the Excel sheet, not predefined. To be able to handle this job, a deep understanding of Excel is essential. Proficiency in VBA and macros will be advantageous. Proven experience with similar projects or tasks is also preferred. Your job will be to implement this feature in a seamless and user-friendly way. If everything goes well, there might be more tasks for you connected to this project in the future.
ID-ul proiectului: 37815943

Despre proiect

47 propuneri
Proiect la distanță
Activ: 20 zile în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
47 freelanceri plasează o ofertă medie de $25 USD pentru proiect
Avatarul utilizatorului
With over 7 years of experience as a Full Stack Developer, I have honed my skills in Excel, specifically Excel 2016, to ensure efficient and user-friendly automations for clients just like you. My robust grasp on VBA and macros combined with a deep knowledge of the software's functionalities permits me to successfully conceal or reveal rows at the click of a button. When it comes to dropdown menus that dynamically modify visible content, rest assured that my familiarity and expertise will deliver accurate and effective results. Moreover, your requirement for generating this dropdown selection from existing data in your Excel sheet further demonstrates why I'm tailor-made for your project - my proficiency extends beyond predefined solutions but into adaptable ones. My commitment to 100% employer satisfaction guarantees a top-notch output that meets your needs within the shortest possible time frame. As we proceed with your project, we may find further tasks connected to improving your Excel processes – know that I am not only capable but also eager to handle anything and everything you throw my way. So let's start this journey towards enhanced efficiency together!
$30 USD în 1 zi
4,9 (646 recenzii)
8,6
8,6
Avatarul utilizatorului
Hello, I am 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.
$30 USD în 1 zi
5,0 (515 recenzii)
8,1
8,1
Avatarul utilizatorului
Hello there, I am an Excel VBA developer and I can write the necessary scripts and add a button to the Excel file's ribbon into a custom tab which looks much better than buttons on a spreadsheet. I can do this in a day. Regards, Balint
$90 USD în 1 zi
5,0 (138 recenzii)
7,1
7,1
Avatarul utilizatorului
Hello, I would like to work on your project to create a button that, when clicked, hides or unhides certain rows within the same sheet. I have extensive experience using Excel macros / VBA, data formatting, and data manipulation in Excel, it will work perfectly using MS Excel 2016. I am online at this moment, so please feel free to initiate a chat with me and discuss further details. Best Regards. Zoltan
$25 USD în 1 zi
5,0 (191 recenzii)
7,0
7,0
Avatarul utilizatorului
With your project, I believe I am uniquely positioned to deliver the results you require. Throughout my career, I have translated complex business processes into streamlined, automated Excel solutions, similar to what you're looking for. My understanding of data entry, analysis, and my 8+ years experience in VBA and macros will prove invaluable in creating the dynamic hiding/unhiding button for your Excel workbook. One key advantage I bring is my ability to generate a dropdown list dynamically from existing data within the sheet - something that can enhance the user-friendliness of your tool. My proficiency in Excel automation extends beyond VBA; I am also skilled in Google App Script and Power Automate. These additional skills can potentially expand the project scope for future enhancement or cross-platform functionality. Lastly, let me emphasize my passion for learning and adapting to new technologies. If there's a more suitable technology stack for this project (JavaScript, for example), I'm equipped and eager to delve into it. The success of your project is my priority and earning a 5-star review from satisfied clients such as yourself is always highly rewarding for me. Thank you for considering my talents; I look forward to contributing positively to your project team
$20 USD în 1 zi
5,0 (81 recenzii)
5,0
5,0
Avatarul utilizatorului
Dear Client, I have sound knowledge of excel and analytics. Also, I previously carried out several projects in excel using pivot and macro. I ensure you will be happy after hiring me. Kindly contact me. Check my portfolio, Main Profile - https://www.freelancer.com/u/mhgroup21 Excel Works - https://www.freelancer.com/u/mhgroup21/portfolio/Excel-Charts--Tables-9025020?w=f&ngsw-bypass= Thank you
$30 USD în 1 zi
5,0 (46 recenzii)
5,2
5,2
Avatarul utilizatorului
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
$30 USD în 1 zi
5,0 (29 recenzii)
4,7
4,7
Avatarul utilizatorului
Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports have dynamic views and functionality to present the data Like: checkboxes, radio buttons, drop-down lists and graphical data representations (Bar charts, pie charts, heat maps, Gantt chat, etc.). Successfully delivered Dashboard, Scorecard, Heatmap & Ad-hoc requests to my clients. I can help you here; I went through the mentioned details and found that I can give you support to complete your task. Please check my portfolio once for more information. Further, we will discuss this on chat. Thanks in advance for your valuable time. Thanks, Jitender Kumar Reporting & Data Analytics EXCEL | VBA | POWER BI | SQL | OCR | Gsheet
$30 USD în 1 zi
5,0 (28 recenzii)
4,8
4,8
Avatarul utilizatorului
It's easy to create button allow to you hide/show excel rows based on requirements by drop down selection I can finish it today About me ADVANCE EXCEL , more 7 years experience I am a CERTIFIED Excel VBA Programming , CERTIFIED Business Analytics and Professional Certificate in Excel Accountant i have a MASTER of BUSINESS ADMINISRATION
$20 USD în 1 zi
5,0 (29 recenzii)
4,8
4,8
Avatarul utilizatorului
Dear Project Manager, Give my ONE HOUR time and you will have a working model to review. That's all , what I wish to say. To know a bit about my work, do visit my profile, portfolio and reviews. Happy to offer my support. Feel free to reach out, if interested. Regards, MM
$25,55 USD în 1 zi
5,0 (6 recenzii)
4,8
4,8
Avatarul utilizatorului
Hello there myself yesu I am a VBA developer I can do this you can contact me on this for further discussion thanks.
$20 USD în 1 zi
4,9 (42 recenzii)
5,0
5,0
Avatarul utilizatorului
Hey sir, it seems that you want to control the visibility of an Excel sheet rows depending on a dropdown list to choose which type of rows you want to show or hide. Also for the dropdown list, you want it to be editable based on data somewhere. We can do that easily using VBA in Excel, creating a macro for each small task we want, and integrating it with a button on the Excel sheet to be easily accessed and used. Please check this similar VBA project for manager's bonus, full automated bonus calculation sheet https://www.freelancer.com/u/nadershehata/portfolio/fully-automated-managers-bonus-sheet-in-vba-10339509?w=f&ngsw-bypass= I’m an Excel expert and VBA developer with 2 certificates in VBA from NASBA. I worked on many projects related to VBA, Linear Programming, Dashboards, and Data Analysis such as creating a fully automated sheet with a dashboard for calculating managers’ salary bonuses. I will be pleased if you contact me to work together, waiting for you, thank you.
$10 USD în 1 zi
5,0 (17 recenzii)
4,6
4,6
Avatarul utilizatorului
Like a "piece of cake". All details understood "Hide/Unhide rows based on dynamic drop-down selection based on existing sheet data".
$30 USD în 1 zi
5,0 (17 recenzii)
4,8
4,8
Avatarul utilizatorului
Hello, I'm a developer with over 10 years of expertise in VB.NET, VBA, and automations. I have a strong background in Finance. I am also organized, meticulous, and deliver neat results. I will submit the result in a max 2 hours after you contacting me. Thank you for considering my proposal. I look forward to working with you. Please let me know if you have any further questions about this proposal. Best regards, Freddy Ho
$20 USD în 7 zile
4,7 (10 recenzii)
4,1
4,1
Avatarul utilizatorului
As a seasoned Excel professional with a deep knowledge of VBA, macros, and JavaScript, I am highly qualified to handle your project. I have years of experience automating customized Excel functions like hiding/unhiding rows based on dynamic dropdown selections. This means I understand the complexities that come with determining row display conditions and can create a seamless user experience for you. Another benefit of working with me is my proficiency in understanding, managing and analyzing complex data sets. This will be crucial when generating the dropdown options from your existing data. Beyond just this current task, I aim to build long-term relationships with my clients. So if everything goes well with this project, you can confidently expect my continued commitment and excellence as we move forward. Let's get started on transforming your Excel sheets into more efficient and easy-to-use tools!
$36 USD în 1 zi
4,9 (4 recenzii)
3,7
3,7
Avatarul utilizatorului
As an experienced Excel coder with a strong proficiency in Excel 2016, I am well-equipped to automate your project efficiently and accurately. With a proven track record of successfully completing similar projects, I bring a wealth of expertise to the table. My unique value proposition lies in my ability to streamline processes and enhance productivity through automation. My approach to this project involves a thorough analysis of your requirements, followed by the development of a customized solution tailored to meet your specific needs. By leveraging advanced Excel techniques and formulas, I aim to deliver a solution that not only meets but exceeds your expectations. My estimated timeline for completion is conservative yet realistic, ensuring that quality is not compromised in the pursuit of speed. I am genuinely enthusiastic about the opportunity to work on this project and am committed to delivering exceptional results that add tangible value to your operations. Your project aligns perfectly with my skill set and passion for automation, making me the ideal candidate to bring your vision to life. Thank you for considering my proposal.
$22,50 USD în 4 zile
5,0 (4 recenzii)
3,0
3,0
Avatarul utilizatorului
I read your project details, I have 13 years experience on your project. I can do it very easily Already i completed some projects like this. Just a Close your eyes and Trust me. I am sure, you will be happy
$11 USD în 2 zile
5,0 (3 recenzii)
2,5
2,5
Avatarul utilizatorului
Good Day, I trust this message finds you well. I am excited about the opportunity to contribute to your team and assist in collecting and managing data. With a solid background in Finance, holding a degree from Commerce College and over 15 years of experience, I am confident in my ability to deliver professional and accurate results. My expertise lies in various Excel functions, web scraping, web search, Power BI, data mining, and proficiency in Access and DBMS. I have successfully utilized Microsoft Excel in the educational and analytical field, particularly in reporting and analyzing student data within a control system. Additionally, I possess excellent skills in web scraping and web searching. Regarding your specific project on Dynamic Excel Hiding/Unhiding Button, I am seeking a skilled Excel coder, particularly with expertise in Excel 2016. The primary focus of this project is to automate the process of hiding and unhiding Excel rows. Key tasks include creating a button that, when clicked, dynamically hides or unhides specific rows based on a dropdown selection. Importantly, the dropdown options must be generated from existing data within the Excel sheet, ensuring flexibility and adaptability. I am available at your convenience to discuss any queries you may have. It would be a pleasure to contribute to the success of this project. Thank you for considering my proposal. Best regards, Christine Zekrian
$15 USD în 3 zile
5,0 (4 recenzii)
2,4
2,4
Avatarul utilizatorului
Being an Excel specialist with in-depth knowledge of Excel 2016, VBA, and macros, I have the proficiency needed to automate the process of hiding and unhiding rows within a sheet. My portfolio boasts a wide range of complex spreadsheet management including data analysis, financial models, and budget tracking - all tasks that require mastery in manipulating and analyzing data using advanced Excel functions such as VLOOKUP, INDEX/MATCH, and PivotTables like your project. Over time, I have also created numerous automated solutions leveraging VBA programming to maximize efficiency and time savings. My experience aligns perfectly with your needs as I have proven skills in generating dynamic dropdown lists from existing data rather than relying on predefined options. Additionally, my keen attention to detail - honed through repeated troubleshooting of errors and discrepancies - ensures we build an accurate system specific to your need. In essence, choosing me would mean entrusting your project to a professional equipped with both technical skills and experience to deliver not just satisfactory but outstanding results.
$20 USD în 1 zi
5,0 (3 recenzii)
2,5
2,5
Avatarul utilizatorului
With over 5 years of experience in Visual Basic, I have mastered and implemented numerous projects using Excel 2016, including process automation. My proficiency in VBA and macros aligns perfectly with the task at hand. I've created similar Excel functions in the past that dynamically hide or unhide rows based on specific criteria, one of which is dropdown selections generated from existing data. Moreover, my experience extends beyond coding; it encompasses a knack for designing user-friendly interfaces and clean, efficient code structures. I understand the importance of not just getting a project done, but also delivering it in a way that anyone can use without any prior knowledge. Finally, I am strongly committed to professionalism and timely delivery of projects – qualities essential when there may be potential future tasks connected to this project. If given the chance, I am confident I can add value to your excel sheet by automating the hiding and unhiding process while ensuring simplicity and accuracy.
$30 USD în 5 zile
5,0 (2 recenzii)
1,8
1,8

Despre client

Steagul UNITED ARAB EMIRATES
Dubai, United Arab Emirates
5,0
1
Metoda de plată a fost confirmată
Membru din nov. 2, 2022

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.