Find matching number in two columns
Hello Everyone,
My first time in this great forum and I have already got lots of resources from the site.
I want to loop through ID Column and find the matching number in Record No.column, and hightlight the entire row when match is found. The code I am running can only work for one cell at a time, but I want to run one time.
Please Login or Register to view this content.
Last edited by Xalaal2009; 06-12-2009 at 10:50 AM.
Hi there,
I'm not quite sure what you mean by:
Can you please explain your requirements a bit more?The code I am running can only work for one cell at a time, but I want to run one time.
Regards,
Greg M
hi Xalaal2009
try.....
Please Login or Register to view this content.
Thanks, Pike.
This code only selects the entire column "I" but not the corresponding row in column A (ID)
Greg M.,
I meant to say that the macro, as it is right now, is not efficient because I have to run it as many times as the number of rows in column "I".
Each value in Record No. has a matching value in the ID column. So when match is found, I need it the entire row highlighted of the matched row of Column ID
try this line
Please Login or Register to view this content.
Pike,
This does not select Matching rows in Column ID, but rather selects matching rows in Column Record No. (I).
Hey Xalaal2009
replace and try this
The changes simply change the A's for I's and I's for A'sPlease Login or Register to view this content.
It changes the LookInR for LookForR
Pike,
Many thanks - your solution made a difference. Our organziation appreciate that neat solution.
your weclome just happy to help
Hello Pike,
I like to do little improvement of that code you helped out. I want to sort out by background color so I have all the rows with background-color ( colorIndex 4) to be on the top, and then delete the rest of the rows (none- colorIndex 4). Currently, I use a User-defined function that figures out the colorIndex ID & place it in a seperate column. Then I sort out by colorIndex ID DESC.
Here is the code for function:
Public Function colval(CellVar As Range)
colval = CellVar.Interior.ColorIndex
End Function
Abdi J. (Xalaal2009)
Raiser's Edge Database App. Support/DBA
Children's Hospital Foundation
Saint Paul, Minnesota, USA
http://www.araarso.com
Hi Xalaal2009
Can you please start a new thread
It helps other when searching for a similar question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks