Gareth.Evans wrote:
HI all,

I am strugling to produce the bellow functionallity for a reporting
system.

I have a main workbook ('Invoice') which contains invoice numbers, i
needs to look up data in several other workbooks
('January','Febuary','March'), consolidate the data corrosponding to a
certain invoice, then import it into a sheet in the main workbook.

EXAMPLE:

Workbook 'Invoice', sheet 1:

Invoice Number | Lookup Workbook
2 January
3 Febuary
4 March
5 Febuary
6 January


Workbook 'Febuary', sheet 1:

Invoice Number | Amount
3 10
3 30
3 15
5 50
5 30

FINAL Desired Result in Workbook 'Invoice', sheet 2

Invoice Number | Amount
3 55
5 80

Hope that makes sense. This is obvoicesly a simple example, in real i
need to import many other fields for thousands of records.

Realy hope someone can help me.

Kind Regards,




Have a look at Debra Dalgleish's explanation of the technique he

http://www.contextures.com/xlFunctions05.html#RefWkbk