469,125 Members | 1,825 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

Matching Values please help

Hello

I am new to VBA and I am having trouble with the program I want to develop.

My project involves looking at two data sets in different columns and rows and comparing them.
For example
CHRMT1(I) RMT1(J) Area1(K) CHRMT2(S) RMT2(T) Area2(U)
1 | 0.1 | 100 | 1 | 0.4 | 3
1 | 0.5 | 110 | 1 | 0.6 | 3.2
2 | 0.2 | 115 | 1 | 0.7 | 3.3
3 | 0.3 | 120 | 1 | 0.8 | 3.4
4 | 1.2 | 125 | 2 | 0.2 | 3.5
5 | 1.4 | 130 | 7 | 0.9 | 3.6

So what I would like the program to do is look at CHRMT1 and check if the value exists in CHRMT2. If it does, then look at RMT1 for CHRMT1 and check if a value within + or - 2% of RMT1 exists in RMT2. If that is the case (like for value 2) then Area 1 needs to be inserted beside Area2.

Additionally, if a value in CHRMT 1 is not present in CHRMT2 (ex. 3,4 or 5) then I would like the values to be inserted after 2 and before 7.
I am not sure how I can make the program search for value bigger than CHRMT1 and insert it before.

Any help would be greatly appreciated.
Thanks so much
Liliana
Jul 15 '07 #1
0 779

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

17 posts views Thread by Andrew McLean | last post: by
2 posts views Thread by Gary Greenberg | last post: by
2 posts views Thread by Hennie | last post: by
9 posts views Thread by Jim Lewis | last post: by
7 posts views Thread by figital | last post: by
6 posts views Thread by andyalean1 | last post: by
5 posts views Thread by johnhelen | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.