In the spread sheet (DATA), rows contain site information and calculations in the corresponding columns.
Trying to create an OUTPUT worksheet review of all the features and costs selected.
Column B is where it all starts with a site name.
What I want to do is if Column B, Cell 2 (B2) has content, make Rows 5-10 visible on the OUTPUT worksheet, if cell B3 has content, make rows 11-16 visible on the OUTPUT worksheet.
I am assuming the default would be all "content" rows on OUTPUT would be hidden in the beginning, then unhidden if DATA!B?? is populated
Possible? If so how?
Trying to create an OUTPUT worksheet review of all the features and costs selected.
Column B is where it all starts with a site name.
What I want to do is if Column B, Cell 2 (B2) has content, make Rows 5-10 visible on the OUTPUT worksheet, if cell B3 has content, make rows 11-16 visible on the OUTPUT worksheet.
I am assuming the default would be all "content" rows on OUTPUT would be hidden in the beginning, then unhidden if DATA!B?? is populated
Possible? If so how?