Finding group cells

[kasmita]

Good day members
I am facing one of the problem for which I think probably
a code can solve. The manual process is tedious. Wanted some simplified
solution

I have my values in column from B2 onwards and more
than 5000+ in sheet1.
In sheet2 I want record of the blank cells but in group and
within the range.
In sheet2 from A2 onwards is the result required.
In A1 is the group of blank cells required and in B1 I have
mentioned the range where it will search this blank cells.

Incase in A1 if I change the group value then it will show the
result as shown in column E.

To get the picture clear I am attaching a sample file.

Thanks
keep smiling

[zbor]

Here, with two columns.

First is helper.
Didn't try to make it in single column. I think it should be done but it would be quite long formula so if you don't want to see it just hide column A on sheet 2.

Change green cell with value you like.

[PCI]

In a module put

Please Login or Register  to view this content.

in Sheet2 's code put

Please Login or Register  to view this content.

[kasmita]

Thanks for the reply.
I tried both the reply.
But PCI was more comfortable.
However even the zbor reply can also be used in one of the forms
and will keep it to use it.

Thanks again
kasmita

[kasmita]

I am sorry but if I click on Add Rept nothing is happening.
Not getting that small screen.