Tracking changes with respect to the correlation in entities

[Thulasiram]

Hello all,

I have a simple problem space in sheet1 like this:

CASE 1:

A B C D E F G
1 O P Q R S T
2 U x x
3 V x x
4 X x x x x
5 Y x x
6 Z x x x x

ABCDEFG and 123456 are the default cells in excel. OPQRST, UVXYZ are
entities in columns and rows. 'x' represents the relationship between
the entities in rows and columns.

i m trying to do the following but kind of struggling in between.
please help

if the user selects any 'one' cell (OPQRST or UVXYZ), the corresponding
cells that has 'x' should be highlighted..

for example, if the user selects R alone (or selects R and presses a
command button), then U and Y should be highlighted because R is
correlated to U and Y using 'x'.

Similarly if the user selects, P then

a. highlighted cells due to the previous operation should turn normal
(i.e. without any highlighting)
b.UVYZ should be highlighted


CASE 2:

SHEET 1

A B C D E F G
1 O P Q R S T
2 U x x
3 V x x
4 X x x x x
5 Y x x
6 Z x x x x

SHEET 2

A B C D E
1 I J K L
2 O x x
3 P x x x
4 Q x
5 R x x
6 S x x x
7 T x x

same operation should be performed here. BUT if the user presses R in
sheet 1, then
a. U,Y in sheet1 AND
b. J,L in sheet2 should be highlighted..

PLEASE help..

Thanks,
Thulasiram

 

[Thulasiram]

Hello all,

I was working on the problem that I posted to the groups.

Basically what i was trying to do was: when the user selects the
row/column,
1. select the entire row and call as range r1.
2. find 'x' in the range r1.
3. highlight the first element in the column where 'x' is found.

this solves my first case.

i m landing with constant errors when i solve this. so, please help. it
would be so nice of you.

it would be great if you could give me solution to my second case too.

Thanks,
Thulasiram