Hello,
Example data:

BATCH ORDER# ASSIGNED NUMBERS
From To

1 1 30
1 55 60
2 1 30

Let's say the the columns are full to 100 entries of this data. I want to be
able to either by formula or macro have on another sheet...first to look at
the Batch#..which in this case will find 1 then look at the next to cells
which says to look at the data for number 1 through number 30 and find this
on another sheet and place all the data listed under batch 1 number 1, batch
1 number 2....batch 1 number 30. I hope this makes sense.

Thanks.