Find Jobs
Hire Freelancers

Dynamic Excel Hiding/Unhiding Button

$10-30 USD

Fechado
Publicado há aproximadamente 2 meses

$10-30 USD

Pago na entrega
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 do Projeto: 37815943

Sobre o projeto

47 propostas
Projeto remoto
Ativo há 15 dias

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
47 freelancers estão ofertando em média $25 USD for esse trabalho
Avatar do Usuário
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 em 1 dia
4,9 (646 avaliações)
8,6
8,6
Avatar do Usuário
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 em 1 dia
5,0 (515 avaliações)
8,1
8,1
Avatar do Usuário
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 em 1 dia
5,0 (138 avaliações)
7,1
7,1
Avatar do Usuário
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 em 1 dia
5,0 (191 avaliações)
7,0
7,0
Avatar do Usuário
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 em 1 dia
5,0 (81 avaliações)
5,0
5,0
Avatar do Usuário
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 em 1 dia
5,0 (46 avaliações)
5,2
5,2
Avatar do Usuário
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 em 1 dia
5,0 (29 avaliações)
4,7
4,7
Avatar do Usuário
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 em 1 dia
5,0 (28 avaliações)
4,8
4,8
Avatar do Usuário
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 em 1 dia
5,0 (29 avaliações)
4,8
4,8
Avatar do Usuário
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 em 1 dia
5,0 (6 avaliações)
4,8
4,8
Avatar do Usuário
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 em 1 dia
4,9 (42 avaliações)
5,0
5,0
Avatar do Usuário
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 em 1 dia
5,0 (17 avaliações)
4,6
4,6
Avatar do Usuário
Like a "piece of cake". All details understood "Hide/Unhide rows based on dynamic drop-down selection based on existing sheet data".
$30 USD em 1 dia
5,0 (17 avaliações)
4,8
4,8
Avatar do Usuário
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 em 7 dias
4,7 (10 avaliações)
4,1
4,1
Avatar do Usuário
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 em 1 dia
4,9 (4 avaliações)
3,7
3,7
Avatar do Usuário
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 em 4 dias
5,0 (4 avaliações)
3,0
3,0
Avatar do Usuário
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 em 2 dias
5,0 (3 avaliações)
2,5
2,5
Avatar do Usuário
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 em 3 dias
5,0 (4 avaliações)
2,4
2,4
Avatar do Usuário
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 em 1 dia
5,0 (3 avaliações)
2,5
2,5
Avatar do Usuário
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 em 5 dias
5,0 (2 avaliações)
1,8
1,8

Sobre o cliente

Bandeira do(a) UNITED ARAB EMIRATES
Dubai, United Arab Emirates
5,0
1
Método de pagamento verificado
Membro desde nov. 2, 2022

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.