locating specific cells marking location

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top