I'm developing a workbook which needs to return
information of variable size from a source sheet to a
response sheet after the user inputs a parameter.

The data on SheetA is laid out with a partnumber and then
supporting information about that partnumber in following
rows. There are always 2 blank rows between partnumber
entries.

On a test macro, I was able to select all of the
information about a partnumber by using
ActiveCell.CurrentRegion.Select That result works fine
for me.

In general terms my approach is to create a
worksheet_change event macro tied to SheetB which will
clear an area, then go and find the appropriate info on
SheetA, copy it, and then paste it on SheetB in the
cleared area.

What I don't know is how to programmatically find the
right info on SheetA. I know how to select it once I find
it. But how do I find it in the first place?

Or to put it another way, how do you program the
equivalent of vlookups and match functions?

Thanks for your help
Drabbacs

P.S. I'm also willing to consider other approaches. This
was just my first design.