Conditional show/hide cells

[wilson187]

Hi,

I am looking to produce a sheet that follows the logic of:

1. select a value from a drop down list
2. auto populate/lookup a table based on the value selected from 1.
- so if value from 1. was "Yes" the sheet would present(hide/unhide) a table from cells A1:D12. and if the value was "No" the sheet would would present(hide/unhide) a different table of data from F1:K6.

I am perhaps googling the wrong things when I am searching for it but cannot specifically find a solution to this.

Any help would be greatly appreciated.

Thanks