O
Oke Doke
Please Help needed
I sort of figured out how to color the background of the cells but I
am totally lost as to how to put this all together to get the results
I must have to get my sheets done.
I will only Need to do the active sheet in the workbooks im working
on.
Ill be very grateful to anyone helps me with this.
Thanks in advance
Greta
..
I have Eight Columns of numbers A thru H) They Are All Whole Numbers.
I also have two columns of numbers in Columns J and K .
J always has numbers 1 thru 140 Starting in J2 thru J141.
K has a list of Various Numbers There Will always be only 140 numbers
in K2 thru K141 Along side Col J J identifies where The Number is
in In Col K2 thru K141
If any number in K2 thru K141 matches any number in (A1:H105) then I
want a background color green In A1:H105 Cell That Matches
Then where ever the number came from in K2 thru K141 That Matched
A1:H105
I need the corresponding number in J2 thru J141 To Be Placed In The
Same Row as the match row in A1:H105
If match was in Col A
Place in Same Row In Col L
IF the match was in Col B
Place in same row Col M
If the match was in Col C
Place in same row Col N
If the match was in Col D
Place in same row in Col O
If the match was in Col E
Place In same row in Col P
If the match was in Col F
Place in same Row Col Q
If the match was in Col G
Place in the same Row Col R
If the match was in Col H
Place in Same Row Col S
I certainly hope all this makes some kind of sense
I sort of figured out how to color the background of the cells but I
am totally lost as to how to put this all together to get the results
I must have to get my sheets done.
I will only Need to do the active sheet in the workbooks im working
on.
Ill be very grateful to anyone helps me with this.
Thanks in advance
Greta
..
I have Eight Columns of numbers A thru H) They Are All Whole Numbers.
I also have two columns of numbers in Columns J and K .
J always has numbers 1 thru 140 Starting in J2 thru J141.
K has a list of Various Numbers There Will always be only 140 numbers
in K2 thru K141 Along side Col J J identifies where The Number is
in In Col K2 thru K141
If any number in K2 thru K141 matches any number in (A1:H105) then I
want a background color green In A1:H105 Cell That Matches
Then where ever the number came from in K2 thru K141 That Matched
A1:H105
I need the corresponding number in J2 thru J141 To Be Placed In The
Same Row as the match row in A1:H105
If match was in Col A
Place in Same Row In Col L
IF the match was in Col B
Place in same row Col M
If the match was in Col C
Place in same row Col N
If the match was in Col D
Place in same row in Col O
If the match was in Col E
Place In same row in Col P
If the match was in Col F
Place in same Row Col Q
If the match was in Col G
Place in the same Row Col R
If the match was in Col H
Place in Same Row Col S
I certainly hope all this makes some kind of sense