How do I get data from 2 Excel worksheets?

[Deb100]

I am getting the majority of my data from one worksheet, however, I need 1 field from another worksheet.

My data is grouped by Client ({tbl.Client}&", "&{tbl.Initials}) then by Stock {tbl.Stock}.

The data looks like this in the report:

Bloggs,J

Date______Stock_____________Holding____Price
30/05/06__ABC Ltd___________1,250.00___12.68
05/10/06__current holding____-1,250.00___???

05/05/06__DEF & Co__________2,675.00___8.97
05/10/06__current holding____-2,675.00___???


I need to show the current price for the stock (???). This is held in a worksheet 'Today's Price', which looks something like this:

Stock Curr_Price
ABC Ltd 1.85
DEF & Co 10.355

How do I link the stock in the main worksheet and today's price worksheet, and show the Curr_Price from today's price worksheet?

 

[synapsevampire]

Add the price worksheet in and link by the stock using a Left Outer.

-k