Hello,
I need a macro for office 2010 which performs the following:
I really appreciate your expertise.
I have data <500 x 500> and inputs <500 x 2>. Inputs contains two values on each row on the data sheet. I would like to use the two values in the inputs sheet to to copy all the values that fall between them on the data sheet then list those values on a third sheet named output.
see example below:
data
0.6332aaaa0.6307aaaa0.68aaaa0.68aaaa0.65aaaa0.61
1aaaa0.9633aaaa0.947aaaa0.91aaaa0.92aaaa0.96
4.44aaaa4.5aaaa4.54aaaa4.926aaaa5.22aaaa5.52
Inputs
0.6307aaaa0.61
1aaaa0.91
4.5aaaa5.22
Output
0.6307aaaa0.68aaaa0.68aaaa0.65aaaa0.61
1aaaa0.9633aaaa0.947aaaa0.91
4.5aaaa4.56aaaa4.926aaaa5.22
Bookmarks