I have a worksheet with info in columns A2:IF2, For this data I need a macro that will look for the number "20" (for example, I have following headers in the data "TTL-20 SLS_QTY", "TTL-20 SLS_VAL" that needs to be hide) OR "YTD ACH%" in the column header and if it's there to then hide that particular column and move on and check the next. (NOTE: Column headers is in the 2nd row of the sheet)
I am struggling to find VBA to do this for me. I've been researching and trying different things for hours without success. Can anyone help? Thank you.
I have attached the file with headers for your reference.
Thank you in advance.
Bookmarks