hi guys,
Need some help with a macro that can hide certain columns if a certain value is not found in another column
I have the financial Analysis sheet that has column names as below:
Totals A A1 B B1 C C1 D D1
On the BPCS summary sheet, i have the column Detection Source that lists out A, B ,C.
The expectation is that the columns D, D1 in the financial Impact sheet are hidden if the Detection Source column doesn't contain D or hide C,C1 in Financial Impact sheet if there is no C in the Detection Source, so on.
alternatively, I'm open to the idea to hide A A1 B B1 C C1 D D1 by default and Unhide them if A B C or D are found in Detection Source column.
any help in this would be highly appreciated. thanks in advance guys!!
Need some help with a macro that can hide certain columns if a certain value is not found in another column
I have the financial Analysis sheet that has column names as below:
Totals A A1 B B1 C C1 D D1
On the BPCS summary sheet, i have the column Detection Source that lists out A, B ,C.
The expectation is that the columns D, D1 in the financial Impact sheet are hidden if the Detection Source column doesn't contain D or hide C,C1 in Financial Impact sheet if there is no C in the Detection Source, so on.
alternatively, I'm open to the idea to hide A A1 B B1 C C1 D D1 by default and Unhide them if A B C or D are found in Detection Source column.
any help in this would be highly appreciated. thanks in advance guys!!