Link item quantity from 1 document to cell in other document

Hi,

Please could somebody help me with the following issue, my excel is version 2003.

I have a report document that needs to be populated with information from the item quantity document.

What I'm trying to accomplish is link a specific cell in the report.xls with the quantity of a specific item number from the itemquantity.xls document.

The report.xls document layout will never change, but the information in the itemquantity.xls doc will, Such as the position of the item with its corresponding quantity will not always be in the same position.

Attached are the 2 documents and within the Report.xls document there is an example of the required output on the sheet named AfterVBA.

Any help is much appreciated.

David

Maybe:

Please Login or Register  to view this content.