Gareth.Evans wrote:
Hi all,

I need to import data from another workbook based on certain criteria.

EXAMPLE:

Workbook 'invoice' has an invoice number and i want to import from the
other workbook all lines that have that invoice number.

I am completly lost, hope someone can help.

Many Thanks

Patience, friend. See your earlier post, which has a better explanation
of your requirements.