How do I hide specific rows based on values in a different worksheet?

Hey guys,

I'm a little new so bare with me. Say I have two worksheets, "Sheet1" and "Sheet2". Let's also say A1 in Sheet1 could have one of four values: cat, dog, rabbit, mouse. Now, based on which value cell A1 on Sheet1 is, I need different rows hidden in Sheet 2. For argument sake let's say if cat is chosen rows 1-5 are hidden, if dog, 6-10 and so on.

Any help is appreciated, thanks!

Thanks for the reply, Leith.

However, I pasted the macro into the Sheet2 object, but it didn't seem to do anything.

Any idea why? I should also mention that instead of "cat, dog, etc" I'm using a string of words, and my worksheets are named differently. I of course altered the formula accordingly.

Hey Leith,

Unfortunately the workbook has a little bit of private information in it which I cannot share. However, the reason your formula wasn't working was due to the Sub name, once I changed the sub name to Worksheet_Change (ByVal Target As Range) it worked! However, is there any way to unhide the rows if I was to toggle my selection? Say I chose cat, but later changed it to dog, how would I get the original cells to unhide?

Cheers

Hey Leith,

I've solved the problem. I just created buttons on Sheet 1 and programmed

Please Login or Register  to view this content.

And simply hide the entire worksheet.

Thanks for your help!