Hi,

I have Two Sheets.

In Sheet1 i have three Columns:

Customer Name
Job No
AO No

In Sheet2 I have 8 Columns

Req No
Item Code
Item Name
Units
Job No
Qty
Customer Name
AO No

Sheet2 have data till 6 column.

Now what I want in Sheet2 is that if the Job No of Sheet2 Matches with
the Job No if Sheet1 then it should return the Customer Name & AO No
from Sheet1 to Sheet2.

How can this be possible.

I am in very much desperate for this solutuion as i have loads and
loads of data. Currently i have to do the entire thing Manually.

I want it to do with the help of Macro what ever way which is smalles.

Pls help me in this regard.

Thanks in Advance.

Akash Maheshwari