Hi OssieMac,
below is an example of the spreadsheet layout I am dealing with. I
want to compare the first column in the chunk of data containing a
full row (A5:14) with the column below this data with header 'row'
B18:28. If it would make it easier, the first column (A5:14) is
actually = to the row number. So, In this example I would highlight
A5:14 (representing the 1000), then invoke macro, I would be prompted
to highlight another range (B18:28 - representing 100), the values
would be compared. In this example all I would be left with is the row
with a '5' in the first column. I hope this is what you are looking
for.
Thanks,
Brett






5 U48705 11.57277673 11.48299326 11.49817988 11.39181932 11.51182406
11.72478724
6 M87338 8.903613038 8.931832415 8.903477047 9.104027145 9.197445184
9.071895683
7 X51757 7.889470277 7.680604745 7.6813734 7.599011979 7.64599037
7.730412447
8 X69699 8.598157828 8.818287912 8.952038751 8.81242113 8.909250938
9.267898962
9 L36861 3.629816252 3.713987347 3.604110976 3.720667264 3.710584461
3.798856123
10 L13852 6.280349023 6.321024974 6.439949032 6.380803877 6.56458805
6.765243354
11 X55005 6.035178802 6.065392297 6.16608982 5.973988714 6.13477326
6.561941301
12 X79510 6.665200269 6.321051756 6.374943774 6.528711441 6.441226071
6.440122473
13 M21121 3.827989034 4.111530913 3.8813984 4.179986423 4.062780619
4.389922903
14 J02843 4.190077627 4.187559742 4.306467935 4.303607206 4.328122558
4.292004354


Row
5
156
200
209
80
500
509
565
990
915
45