I have a defined NAME(e.g. GROUP1) of a group of Cells in a table. Within
this group of cells, I had defined another NAME (e.g. GROUP_1) for those
blank cells that I gathered. My problem is how to make dynamic changes on
the referred cells of GROUP_1, say if I place value in one blank cell, the
GROUP_1 will be updated.

GROUP1 : A1:J5
GROUP_1 : A2,J4 <BLANK CELLS>

Editing the GROUP1, I delete the content of B1 and B2...
Hence, I need GROUP_1 to recognize the changes
GROUP_1 must be : A2,J4,B1,B2

I hope this is not another unsolved problem in our forum....

thanks a lot...
rml

See post in worksheet functions
--
Gary's Student


"rml" wrote:

> I have a defined NAME(e.g. GROUP1) of a group of Cells in a table. Within
> this group of cells, I had defined another NAME (e.g. GROUP_1) for those
> blank cells that I gathered. My problem is how to make dynamic changes on
> the referred cells of GROUP_1, say if I place value in one blank cell, the
> GROUP_1 will be updated.
>
> GROUP1 : A1:J5
> GROUP_1 : A2,J4 <BLANK CELLS>
>
> Editing the GROUP1, I delete the content of B1 and B2...
> Hence, I need GROUP_1 to recognize the changes
> GROUP_1 must be : A2,J4,B1,B2
>
> I hope this is not another unsolved problem in our forum....
>
> thanks a lot...
> rml