Hi,

I have a range of numbers and want Excel to locate a specific number
then go down one cell to copy the number from there and the three cells
to the right of it to another location. I then need to repeat this
operation about 45 times. All data is on the same worksheet. For
example:


Locate number 101 and then copy number immediately below it (65.89) and
the three numbers to the right of it (112.44, 875.42, 695.84, to Cells
A100-D100.

A B C D

1 100
2 35.28 67.28 96.85 135.42
3 101
4 65.89 112.44 875.42 695.84
5 102
6 750.20 68.57 41.04 74.52

Any simple way to do this? Thanks in advance!