Auto Hide & Unhide Rows Upon Sheet Selection

[Sleeper]

I've searched and searched for code on this, but can't find exactly what I'm looking for. I've found a few different codes that work great at hiding the rows, but don't update when data is refreshed. I need to accomplish this without buttons, so when data is changed, the rows are automatically updated once the tab is selected.

Here are the particulars:
- Report tab pulls data from other tabs in the workbook.
- Rows pulling "0" in Column A should be hidden.
- Rows pulling "<>0" in Column A should be unhidden.
- The macro should automatically run when the Report tab is selected.
- No Manual running
- No constant running when data is changed on the source tabs to keep from slowing the file.

If you need a dummy workbook, let me know. Otherwise, it seems pretty straight forward, I'm just a newbie at coding. TIA.

[royUK]

Is the data on the sheet in a proper table format with a header row?

[Sleeper]

Is the data on the sheet in a proper table format with a header row?

Are you referring to the report sheet or the data source sheets?

The report sheet does have headers for each column. The source sheets do as well, but the data is not continuous on them.

If I can get passed this issue, my next issue will be reformatting the print on the report tab to look acceptable when the report shrinks and grows.

Thanks again.

[shofiqfatema]

Dear All
I can hide and unhide some rows from a excel sheet only one time (One rang) but I Need to multiple rang in one worksheet. Please help me.

Thsnaks

[arlu1201]

Shofiqfatema,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.