Hi,


I am trying to compare two sets of data, and altering the data in one
sheet when I get a "hit".
The process I want to do is as following:


1. In Sheet1 I want to detect all the rows in a specified range where
column K is different from empty and store the values in column a, b and c for every row where column K is different from empty

2. I have the following table of data that I need to multiply with the
data in point 1
bb=XX dd=1
bb=YY dd=0.5
bb=ZZ dd=10

3. I need to create a new dataset where for every row I have discovered
in point 1 I create a new row using the table from point 2.
Meaning it will be on this form:
a b bb e( e=c*dd)

The example in point 2 would look something like this:

a1 b1 XX e (c*1)
a1 b1 YY e (c*0.5)
a1 b1 ZZ e (c*10)
a2 b2 XX e (c*1)
.........

4. Now I need to take the resulting dataset from 3 and compare it with
sheet 2.
If sheet2(column a) = A and Sheet2(column g) = bb then let
sheet2(column z) = e

I realize I can probably do this using for, and next loops I do suspect
that this may be an unnecessary complicated and not to
mention slow running way of doing this, any of you have any
suggestions?

Regards,

John