LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Loop thru cells and find match

Hello,
I have a small task I need to work on, but have not done vba in a while and
was wondering if someone could help on this.

I have 2 sets of data that I need to compare to each other.
First set: Second set:
A B D E
A1 123.56 A1 123.56
A2 124.58 B4 111.11
A3 129.32 B4 132.45
B4 132.45

So, I need to check the vals of cell D(x) against A(x) and see if there is a
match. If so, then I also need to verify if cell E(x) matches the equivalent
B(x) cell (in same row) where the match for D(x) is. If so, then I need to
have range D(x):E(x) pasted into new cols G(x):H(x), if not, then it would be
blank in that row.

My end result should be:
First set: Second set: Result set:
A B D E G H
A1 123.56 A1 123.56 A1 123.56
A2 124.58 B4 111.11 BLANK
A3 129.32 B4 132.45 B4 132.45
B4 132.45 BLANK

How can I achieve this via code?

Thank you in advance for your help and attention.
Consuelo :-)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and match cells Martin Excel Discussion (Misc queries) 1 August 1st 07 10:02 AM
loop to find cells with specified value webby2006[_9_] Excel Programming 3 August 7th 06 04:51 PM
Make a loop to Find a value then move a row of cells Bill F Excel Programming 1 June 8th 06 08:24 AM
Loop through a range of cells to find unique entries zoot Excel Programming 2 April 29th 06 02:08 PM
Problem with cells.Find within a loop jowatkins Excel Programming 4 December 9th 03 01:39 PM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"