Hiding Rows Automatically on a different sheet based on formula result

[audi1959]

Hi,

This is my first post and I just joined this forum. I am working on a spreadsheet that has a tab (Deliverables) and based on the sum of a formula in another tab (General Information) Cell L14, I need to hide different rows (in Deliverables). I need this to happen automatically whenever the sum changes in L14 on General Information. By the way I am a novice with VBA so please be gentle!

Thanks in anticipation

Audi1959

[oeldere]

Welkom to the forum.

You get better help if you add (post) an excel file, without confidential information.

Please also add the expected result manualy in you file.

[acroley1]

This is definitely possible with some simple VBA and I'm still a novice with VBA myself. But like @oeldere said, it would be easier if we could see an example. Here's some code where I was hiding rows A4:D6 based on the value of A4.

Please Login or Register  to view this content.

I have this code in the "This Workbook" object in Developer because I want it to happen to all my worksheets in the workbook. If you only want this to happen on one sheet, the code should go on that worksheet object....or in a module where you could run it from the Developer toolbar.

Sorry for all my notes in the code.....I write a TON of notes to myself since I'm still so new to writing code!

---

If you found this post to be helpful, or if it at least brought a smile to your face, please say "Thank You" by clicking Add Reputation. Thank you!

[newdoverman]

If you have data on the same rows that would become hidden if the rows were hidden but you don't want that data hidden, you could hide the data by using Conditional Formatting to just "white-out" the rows (to the limits that you want) so that any other data on the worksheet on the same rows will not be hidden.

Conditional Formatting rule....and format the text as WHITE.

Select the data to have rows "hidden" then go to Conditional Formatting, New Rule, Use formula.... and enter this formula

Please Login or Register  to view this content.

The enclosed file shows what I mean. Rows are not actually hidden but masked so as to not be readily read.

[audi1959]

Thanks for your quick response. I have a spreadsheet that I will attach where I inserted your code but it doesn't work. I've obviously done something wrong. In a nutshell, when the solution is Simple Solution (on the Solution Tab), i need to show the Simple Solution table on the Deliverables TAB. Other tables are to be hidden. This needs to continually update automatically as the Solution type changes. How do I attach a file here........

Thanks - Here is the workbook

[acroley1]

Click "go advanced" when you are replying and there are attachment options there.