Hello,

I like to have a module which takes below action.

The mean heading is row 2.

When selecting one of the records in row 2 (for example cell D2) I want that a module automatic (OnActivate) hide all the rows from row 3 till last where in this same column as the active cell there's no data (empty cell).

For example. I select cell D2 and in cell D3, D5, D8, D10 is no data. Then the module should hide those rows.

When selecting the field A1 all hiden rows should be unhide.

When I select for example then cell F2, and in this column the cells F8, F10 are empty, then those empty rows should be hiden.

Somebody can help me out ?

regards,
Johan