Importing data from other workbooks.

[loopcheck]

I want to create a recieving system at work that will function in the following manner:
I have a Purchase Requisition worksheet and a Recieving worksheet created. In the PReq, I have the following data: Requistion number, PO number, WO number, Item number, Item quantity, Item description, Date purchased, etc...
In the recieving worksheet, I want to be able to type in the Requistion number or the PO number and have all the items listed in the purchase requisition with that specific PO number import in the recieving worksheet. Keeping in mind, every requisition and recieving worksheet will be saved on our server under either the requisition number or recieving number. Clear as mud?? Any suggestions? Tks.

 

[Billyboy]

Hi

Please refer to the following

http://www.mrexcel.com/forum/showthread.php?t=380507&highlight=importing+worksheet

Think this solves your problem

cheeers..

 

[loopcheck]

Thanks bud. Very much appreciated!

Loop