I need an Excel Expert VBA code Hide Rows based on Cell value

Closed Posted 10 months ago Paid on delivery
Closed 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.

Excel Visual Basic Data Processing Visual Basic for Apps Data Entry

Project ID: #36859838

About the project

43 proposals Remote project Active 9 mos ago

43 freelancers are bidding on average $29 for this job

schoudhary1553

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

$50 USD in 1 day
(588 Reviews)
8.5
imteyazkhan85

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

$28 USD in 1 day
(78 Reviews)
6.4
SShtv

Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and m More

$30 USD in 1 day
(129 Reviews)
6.6
vsprybhanu

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

$30 USD in 1 day
(150 Reviews)
6.2
rahulg5466

--------------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

$25 USD in 1 day
(45 Reviews)
5.2
prabakarm23

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

$20 USD in 1 day
(59 Reviews)
4.9
freelancerabdu34

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

$30 USD in 1 day
(40 Reviews)
4.7
nblsoft

Hi, I am interested in your project and offer my services. I am familiar with this type of macros and can help you out. I have a couple of questions, if you send me a message then we can discuss further. Looking for More

$20 USD in 1 day
(10 Reviews)
4.9
EmiliaSimon

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

$25 USD in 2 days
(25 Reviews)
4.8
AnuradhaVM

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

$20 USD in 1 day
(41 Reviews)
4.8
remisanonymous

Hi, I have fixed it and it working now. Contact me to get it, please. Best regards, Remis

$10 USD in 1 day
(17 Reviews)
4.2
habib1433

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

$20 USD in 2 days
(14 Reviews)
4.0
nournadam

Hello there, I am ready to work on your project. Kindly contact me for more details. Regards, Fatimah

$20 USD in 7 days
(5 Reviews)
3.1
mohdawais944

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

$10 USD in 1 day
(1 Review)
2.9
kavitadhingra

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

$15 USD in 2 days
(1 Review)
1.7
AshwinSurathkal

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

$20 USD in 1 day
(3 Reviews)
1.6
jeetparekhnmims

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

$75 USD in 2 days
(2 Reviews)
1.4
anamimtiaz01

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

$20 USD in 2 days
(1 Review)
1.3
areeb97

I understand that you need help adding multiple same type of macros to the same sheet. I have extensive experience in macros, pivot tables, charts and formulas which will come in handy when working on this project. I More

$20 USD in 2 days
(1 Review)
0.8
pravalika1995

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

$20 USD in 2 days
(2 Reviews)
0.4