Hi all,
I have about 100 clients' excel report files,and I need to hide specific columns in multiple excel files if any cell in the columns match "AAA" or "BBB" or "CCC".
I am looking to see if there's a way to quickly hide the columns if the above conditions are met, to all 100 excel files without open multiple excel files.
Any help is appreciated. Thank you very much.
Bruce
I have about 100 clients' excel report files,and I need to hide specific columns in multiple excel files if any cell in the columns match "AAA" or "BBB" or "CCC".
I am looking to see if there's a way to quickly hide the columns if the above conditions are met, to all 100 excel files without open multiple excel files.
Any help is appreciated. Thank you very much.
Bruce