sure


I add an example file to show what i need:

When i choose a value from the dropdown menu in cell AB1 (the values listed are the ones in yellow in column A) i'd like to show only the corresponding cells (higlighted with different colours)

if I select asterisk I'd like to show all the cells

Attached Files

esempio.xlsx (13.3 KB, 11 views)

How about using slicers?

First, you would have to convert column A to copy down dates to fill all rows.

Then you add column Headers (you can hide this row)

Convert range to Table

Then Insert Slicer based on Date in column A.

Now you just click the date you want and presto.

To get all dates you click the little "funnel with X through it" icon

Attached Files

Copy of esempio.xlsx (16.4 KB, 11 views)

thank you NBVC!
I didn't think to that solution!