I need an Excel Expert VBA code Hide Rows based on Cell value
$10-30 USD
Paid on delivery
I need help adding multiple same type of macros to the same Sheet. I am using one to hide rows 5 to 11 if cell b3 has "No", "N/A" or is blank and doesn´t hide them if it has "Yes". Now I want to add the same type of macro but for another range and based on another cell value, but I don´t know how to add more than two macros to the same sheet. For example if B13 has "No", "N/A" or is blank it will hide cells 15 to 19 and if it has "Yes" it will not hide them. if B25 has "No" "N/A" or is blank it will hide rows 23 to 29 and if it has "Yes" it will not hide them. I need to know how to add as many as I need since the original file has many cells that need to be hidden based on many cell values.
Project ID: #36859838
About the project
43 freelancers are bidding on average $29 for this job
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More
Hi there, I am excel macro developer, having 6 years of experience. This is how I will proceed I will conduct a thorough analysis of your existing Excel sheet to understand the structure and identify the areas where m More
Hi, You don't need multiple macros. It can be done with single macro but need to set multiple conditions according to range. I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst More
--------------I CAN DO IT RIGHT AWAY--------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, More
Greetings For the Day! I have 12 years of experience in the Automation, Development & Visualization and I am providing services related to my skills with great quality. Created many projects ranging from auto Email, More
Greetings, I am an Advanced Level Excel Formula, VBA & Macros expert and an Accountant. I am very confident to start your project and complete it with all efficiency you are looking for. I understand the requirements a More
Hello, I can help you create as many macros as you need to hide rows. I am a VBA Developer with extensive experience in task automation, and I can quickly and easily deliver the results you need. Please feel free to c More
Hello, I have Data entry and Excel/Google Sheets skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming. If you work with me you will get good value for your money and a More
Hi, I have fixed it and it working now. Contact me to get it, please. Best regards, Remis
Hi, I can help you to set right macro and hide cells. I have expertise in it. So please message me for further discussion. -Habib
Hello there, I am ready to work on your project. Kindly contact me for more details. Regards, Fatimah
Hello, I have read your task description and can help you writing VBA that can hide multiple range of rows based on certain conditions! My approach will be to either use IF/else condition or switch case function to c More
I understand that you need help adding multiple same type of macros to the same sheet. With my expertise in Data Processing, Excel and VBA codes, I can help you with this task easily. My skills include data processing More
Dear sir/ma'am With nearly 14 years of coding experience, I have written scripts to automate repetitive manual tasks in Excel and to consolidate multiple Excel files into one with utmost accuracy and speed. I have crea More
I am genuinely enthusiastic and keenly interested in undertaking this project. I am confident that my qualifications and abilities align perfectly with the requirements of this role. I am available to commence work at More
Hi, I’d love to work with you! I’ve been working as an accountant for over 5 years, and I have a lot of experience working with different types of clients. I’ve dealt with small businesses, large corporations, and ever More
Hi there! I understand you need help with macros for multiple set of conditions. I have plenty of experience with all MS Office apps, especially with Excel. My proficiency with VBA has helped create several processes More