Selecting a Cell in column "A", and finding where / If the cell exists in column D

Hi,

So I've been cracking on with my excel coding and feel like its all starting to make sense. A lot of what I do is checking data against other data, and one of the things I'm looking to do is to select the first cell in column A. I then want to look in column D, and work down to find when there is a match. Then this match occurs, it could highlight for instance or cut the cell and paste alongside the equivalent cell in Column A. This obviously then needs to be repeated for every value in row A. If the cell selected already matched, this is of course ok.

I'm just looking for guidance really, this is what I have so far

Please Login or Register  to view this content.

How does this look? there is something wrong as it doesn't loop quite the way I would like it to, but I cant seem to get my head around it.

Thanks again

Alex

FWIW:

Please Login or Register  to view this content.

Thanks for all the help guys.

So I have a modified version, split into two macros (I like to be able to do things in parts)

The first highlights the cell in yellow in column D, if this cell is in column A. That all works fine.
The second macro, i'm trying to get to go through column D, and find those cells not highlighted yellow, delete them and move the remaining cells upwards:

Please Login or Register  to view this content.

I know it is something to do with the way im working the loop in the 2nd macro - So i'm wondering if someone could explain why it isn't doing what I want it to do - and how to improve it.

Thanks again guys!

Originally Posted by AMWalton89

Thanks for all the help guys.

So I have a modified version, split into two macros (I like to be able to do things in parts)

The first highlights the cell in yellow in column D, if this cell is in column A. That all works fine.
The second macro, i'm trying to get to go through column D, and find those cells not highlighted yellow, delete them and move the remaining cells upwards:

Please Login or Register  to view this content.

I know it is something to do with the way im working the loop in the 2nd macro - So i'm wondering if someone could explain why it isn't doing what I want it to do - and how to improve it.

Thanks again guys!

I usually do this kind of matching in two sub parts because I always get errors if I combine the "then" aspect within the same loop. Would be nice to see the highlighting and subsequent deleting in one dirty loop. I mean DIRTY!

You can combine them if you want.

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Pretty much the same as judgeh59.

Please Login or Register  to view this content.

I think both of the above codes need .Colorindex vrs .Color, but I haven't tested.

Thanks to Both of you. So my final code looks like this :

Please Login or Register  to view this content.

Can I ask a quick question. Can you explain what "To 2 Step -1" at the end of row is doing, as in the breakdown?

Thanks again guys!

Increments by backwards rows

From the last row:

Please Login or Register  to view this content.

To row 2.

Please Login or Register  to view this content.

One backwards step at a time

Please Login or Register  to view this content.

Thanks for your time, its much appreciated!!

You're both welcome. Glad to help out.