I am importing a text file like the following:

LIN**BP*PN1**PO...
FST*1
FST*1
FST*1
LIN**BP*PN2**PO...
FST*1
FST*1
FST*1
FST*1
LIN**BP*PN3**PO...
FST*1
FST*1
LIN**BP*PN4**PO...
FST*1
FST*1
FST*1
FST*1
FST*1

All data is in column A. Each line that begins with the value LIN**BP*
contains a part number. I have a list of specific part numbers that I
want to use as a filter. I have written a macro to filter the lines
that contain the part number in my filter. The number of lines between
each LIN**BP* varies as shown above.

What I really need is for the macro to also filter/show/highlight/copy
the data underneath as well. For example, using the data above, I want
to filter/find/highlight/copy the list to show only the information
for part number PN1 & PN3. The filtered list would look like this:
LIN**BP*PN1**PO...
FST*1
FST*1
FST*1
LIN**BP*PN3**PO...
FST*1
FST*1

Since the number of lines between each part number line vary, I don't
know how to get started.

Any ideas?

Thanks,

Roger M

XL 2000