Hide and organize cells based on a list box selection?

[Bort]

Can a specific range of cells be hidden and shown based on what’s selected from a list box? If it is possible how would I do that?

If it would require a sheet with all the data and a separate sheet with a list box on it that’s fine. It would be easier and lighter on computer resources and load time of the document if I could do that instead of having multiple sheets for similar data.

All of the sheets don’t list the same cell ranges. I dread having to make an example file for this and the project document isn’t complete enough to be clearer than the words above for what I’d like to get it to do.

In the example file included I’d like Sheet3 to be the only visible sheet. Making a selection from the lisbox on sheet3 populates and displays the data (ranges including any formatting, conditional formatting, formulas, images, text, comments - everything) in the cells below the list box on sheet3 according to the data on sheet2.
Sheet 2 tells the selection box on sheet3 what to display.

The example file is too large for this horrid new design and site. I uploaded it to google drive:

ListBox_Filter_Example.ods

[Zizi64]

@Bort

The example file is too large for this horrid new design and site.

Because you are using a 3.15x2.67 cm resized image what has original size 1 571 404 bytes.
Always optimize your images BEFORE you insert them into your documents.

[Bort]

It’s an example file. That probably wouldn’t make a difference anyway. They’ve only optimized this new thing for tiny text files.

[mikekaganski]

We always had the file size limit here, on the old site as well. It’s an Ask site, not a file storage facility. It’s expected that providing a sample typically fits to some reasonable limit. And of course, that questioner makes some effort to prepare such a reasonable-sized sample.

[Lupp]

(I didn’t check the example. I avoid google “services” wherever I can.)
As far as I understand the question:
Creating different sheets just for different visibility of exactly the same data is definitely a bad idea.
Using a ListBox (or any control object) for variants concerning the visibility would require (not too simple) user code.
The flexibility-feature concerning visibility Calc comes with is >Data>Group and Outline>Group....
It can’t handle, however, different grouping by intersecting but not nested column/row ranges.

Concerning rows you can also utilize the Filter tool. In this case you need to be aware of the fact that some funtions may work IsFiletered-sensitive.