Hello. I need to filter a column in a workbook and copy paste it to another sheet in the same workbook. I use the Filter tool, and then Copy/Past Range and everything seems to be working, but at the end, the rows copied to the new sheet are hidden/filtered so I don’t see anything. I’ve tried removing the filters at the end of the workflow, but it’s not working. Any advice would be appreciated.
Paste new sheet
I’m not sure if I understand. I need to remove filters from two pages after the automation is done. The “Configure” tab gives me an option to select a range, but I’m not sure how to create that range in entire workbook and from first sheet to last.