Sandy,

Thanks for the quick and helpful reply. I'm not sure if this will
work, perhaps I didn't explain the problem well enough...

The problem with this solution is that it assumes that the range is
always the same. Unfortunately the report changes once in a while and
the numbers move. I wanted to search one large range that easily
accomodate all the data and search by number. If I don't do it this
way the system fails as it cannot tell when 201 has moved into the
position of 107 and puts the wrong data in it.

Below is the entire range where the data would be output to. What I
need is something that will search for "101" (and all the subsequent
numbers) in the whole report and then move the four numbers below it
into the appropriate fields below:




101 $0.00 $0.00 $0.00 $0.00 $- $-
102 $0.00 $0.00 $0.00 $0.00 $- $-
103 $0.00 $0.00 $0.00 $0.00 $- $-
104 $0.00 $0.00 $0.00 $0.00 $- $-
105 $0.00 $0.00 $0.00 $0.00 $- $-
106 $0.00 $0.00 $0.00 $0.00 $- $-
107 $0.00 $0.00 $0.00 $0.00 $- $-
108 $0.00 $0.00 $0.00 $0.00 $- $-

201 $0.00 $0.00 $0.00 $0.00 $- $-
202 $0.00 $0.00 $0.00 $0.00 $- $-
203 $0.00 $0.00 $0.00 $0.00 $- $-
204 $0.00 $0.00 $0.00 $0.00 $- $-
205 $0.00 $0.00 $0.00 $0.00 $- $-
206 $0.00 $0.00 $0.00 $0.00 $- $-

301 $0.00 $0.00 $0.00 $0.00 $- $-
302 $0.00 $0.00 $0.00 $0.00 $- $-
303 $0.00 $0.00 $0.00 $0.00 $- $-
304 $0.00 $0.00 $0.00 $0.00 $- $-
305 $0.00 $0.00 $0.00 $0.00 $- $-
306 $0.00 $0.00 $0.00 $0.00 $- $-
307 $0.00 $0.00 $0.00 $0.00 $- $-

401 $0.00 $0.00 $0.00 $0.00 $- $-
402 $0.00 $0.00 $0.00 $0.00 $- $-
403 $0.00 $0.00 $0.00 $0.00 $- $-
404 $0.00 $0.00 $0.00 $0.00 $- $-
405 $0.00 $0.00 $0.00 $0.00 $- $-
406 $0.00 $0.00 $0.00 $0.00 $- $-

501 $0.00 $0.00 $0.00 $0.00 $- $-
502 $0.00 $0.00 $0.00 $0.00 $- $-
503 $0.00 $0.00 $0.00 $0.00 $- $-
504 $0.00 $0.00 $0.00 $0.00 $- $-
505 $0.00 $0.00 $0.00 $0.00 $- $-
506 $0.00 $0.00 $0.00 $0.00 $- $-

601 $0.00 $0.00 $0.00 $0.00 $- $-
602 $0.00 $0.00 $0.00 $0.00 $- $-
603 $0.00 $0.00 $0.00 $0.00 $- $-
604 $0.00 $0.00 $0.00 $0.00 $- $-
605 $0.00 $0.00 $0.00 $0.00 $- $-

701 $0.00 $0.00 $0.00 $0.00 $- $-
702 $0.00 $0.00 $0.00 $0.00 $- $-
703 $0.00 $0.00 $0.00 $0.00 $- $-
704 $0.00 $0.00 $0.00 $0.00 $- $-
705 $0.00 $0.00 $0.00 $0.00 $- $-
706 $0.00 $0.00 $0.00 $0.00 $- $-