VLOOKUP is the function for this task.
--
Traa Dy Liooar

Jock


"Bradley" wrote:

Hi€¦

I have a workbook1 to put all mixed data in it.
Eg:
| company name | Ref No. | Job No. | Amount |
| XX | 001 | DX-001 | 56,789.00 |
| YY | 002 | DX-001 | 45,980.50 |
| ZZ | 003 | DX-002 | 23,098.90 |
| YY | 004 | DX-002 | 11,287.00 |

I have another workbook2 and there are 3 sheets by company names.
Eg: XX company in sheet1, YY company in sheet2 and ZZ company in sheet3
each sheet has the same table...
| Ref No. | Job No. | Amount | Remarks |

What I want to do is to link all data to each designated company name sheet.
When I input data in workbook1, I want to show data automatically in each
designated sheet, workbook2 and sorted by Ref No.

Is it possible to do it?
If two workbooks cant be done, I can join those sheets in a workbook.

Thanks in advance
Bradley