R
Rambo
Hi,
I have been given a rather difficult task and I was hoping someone
might be able to give me a start I have two workbooks.
Workbook 1
Group Start End Rank
L 67105567 67115567 1.807
L 201319966 201329966 0.631
M 33266853 33276853 2.078
Workbook 2
Group Start End
L 27433757 27507677
L 205694218 205729852
M 27237837 27289381
I am trying to figure out how to write code to compare each row in
Workbook 2 with the rows in Workbook 1. If the Group column matches
and the range of Workbook 2 fall within the range defined in Workbook
1 I would like to copy the value in the column rank to workbook 2.
Example (simplified)
Workbook 1
Group Start End Rank
L 2 99 5
L 3 5 6
Workbook 2
Group Start End
L 3 4
L 2 37
Workbook 2 (New)
Group Start End Rank
L 3 4 6
L 2 37 5
I know this is probably very complicated but again if anyone could
give me a shove in the right direction as to how to begin the coding I
would be very thankful
Rambo
I have been given a rather difficult task and I was hoping someone
might be able to give me a start I have two workbooks.
Workbook 1
Group Start End Rank
L 67105567 67115567 1.807
L 201319966 201329966 0.631
M 33266853 33276853 2.078
Workbook 2
Group Start End
L 27433757 27507677
L 205694218 205729852
M 27237837 27289381
I am trying to figure out how to write code to compare each row in
Workbook 2 with the rows in Workbook 1. If the Group column matches
and the range of Workbook 2 fall within the range defined in Workbook
1 I would like to copy the value in the column rank to workbook 2.
Example (simplified)
Workbook 1
Group Start End Rank
L 2 99 5
L 3 5 6
Workbook 2
Group Start End
L 3 4
L 2 37
Workbook 2 (New)
Group Start End Rank
L 3 4 6
L 2 37 5
I know this is probably very complicated but again if anyone could
give me a shove in the right direction as to how to begin the coding I
would be very thankful
Rambo