Is it possible to do???

[Bradley]

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 can’t be done, I can join those sheets in a workbook.

Thanks in advance
Bradley

 

[Jock]

VLOOKUP is the function for this task.

 

[CLR]

Personally, I think you would be better off in the long run if you just kept
all your info on the one main sheet and just generated the individual
"company" sheet reports at will using the autofilter......by macro if desired.

Vaya con Dios,
Chuck, CABGx3

 

[Bradley]

Hi! CLR,

Thanks for your advice.
I keep them by monthly sheets or workbook.
It'll be workbook01 for Jan, workbook02 for Feb and workbook03 for Mar.
I only know simple link functions.
I'm really poor in macro but I have to learn it now.
Thanks again for response.

Bradley

 

[CLR]

You're welcome............but do give the Autofilter some serious
consideration, and as for macros, try using the Macro Recorder, and go here
for more info.......

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Vaya con Dios,
Chuck, CABGx3