I am trying to find a way to filter an excel sheet with over ten thousand rows. I tried a ‘For Each’ initially, but it was very time consuming.
I am trying to filter the excel sheet and write a value in a “Status” column for the current rows displayed in the filtered sheet. I need to keep all ten thousand rows, and it should be unfiltered after the end of the sequence.
*I am able to do this in StudioX, but do not know how to code in Studio. Also able to create a VBA macro.
Any help is greatly appreciated.