Hello
Is it possible to only show certain word/numbers using vba? For example in this case I just want to show cost center 123 and 124. The others cost center I want to disappear or hide
The attached file has a macro which activates when right clicking in column A rows 3-11 and toggles between shrinking and expanding rows 3-11 where the value in column A isn't 123 or 124.
Isn't a macro overkill ? Use Excel's in-built Autofilter to select the cost centers you wish to display ; once they are displayed , select the entire data range and copy to a separate worksheet ; only the filtered rows will be copied.
