Forum Discussion
Solved
Hide/Unhide Rows in Excel in multiple sheets
I have a data in more than 40 sheets with same format. In "Column AX", I have total of all. Data format:- "top to bottom is date amd left to right is brands". In Column AX top to bottom is total of al...
- Thanks. I'll check & let you know whether it works for me or not.
Personally, I would modify HansVogelaar 's code to delete the rows, rather than filtering them, and then convert all the tabular data to Excel tables that resize to accommodate the actual content.