Hi.
I am absolutely new to the micros and trying to figure the best way to do the following:
I have a filter in column A which is showing values 0, 1 & 2.
-The formula will give me a 0 if the corresponding cell in column B is 0 and 1 if other then 0
-2 is manually entered for the rows which are constantly visible.
Micros need to filter by 1 and 2 only and replace all the 0 rows by inserting blank rows.
How to tell the micros to insert between the last filtered row with 1 and before A75 blank rows with the same formatting, but no values equaling the amount of rows which will be hidden with the value 0.
Thank you in advance.
Iva
I am absolutely new to the micros and trying to figure the best way to do the following:
I have a filter in column A which is showing values 0, 1 & 2.
-The formula will give me a 0 if the corresponding cell in column B is 0 and 1 if other then 0
-2 is manually entered for the rows which are constantly visible.
Micros need to filter by 1 and 2 only and replace all the 0 rows by inserting blank rows.
How to tell the micros to insert between the last filtered row with 1 and before A75 blank rows with the same formatting, but no values equaling the amount of rows which will be hidden with the value 0.
Thank you in advance.
Iva