Excel 2007 Macros based off Data Validation list to populate rows

Can you post a sample workbook?

What do you mean by "data validation list"? Do you have comboboxes, listboxes, etc.? Are they form controls, ActiveX controls?

You need to provide more information before the question can be answered.

I guess I am not sure what it is considered (new lol) When excel, I created a drop down from data validation - selected LIST and inserted "yes" "No" for the options.

I am attaching an example now.

What i am looking for on this example is for box c35 - if it says YES I need row 37 to stay hidden, but if you were to select "no" on c35 it would SHOW row 37. Right now i have it grouped to manually expand if needed.