I am creating an invoice. The data is to be pulled from a worksheet called
"DATA".
There is one row for each item. There may be several items per invoice. Each
are keyed with the "InvoiceNum" columnBA
On my invoice, I have named fields that represent each item on a row. But I
am not sure how to get the other items that are tied to the same invoice
number. There are only 2 cells that are needed and these are item and rate
(columns AU and AV)

Any ideas on how to do this?

I am using the example I D/L from http://j-walk.com/ss/excel/tips/tip92.htm
as my base.

Thanks
Bruce