G
Guest
Guest
Hi Excellers:
I have Main.xls which has various customers information.
I have 1001.xls to 1500.xls workbook (about 500 customers workbook, information are save base on customer company code)which summaries information of customers from Main.xls.
Example of Main.xls:
A B C D
1 Co. code Co. name Address Year end
2 1001 A Ltd No.1Road 31/12/02
3 1002 B Ltd No.2Road 31/8/01
4 1003 C Ltd No.3Road 31/10/01
5 1005 D Ltd No.4Road 31/12/02
up to
1500
Example of 1001.xls :
A B
1 Co. code 1001
2 Co. name A Ltd
3 Address No. 1 Road
4 Year end 31/12/02
The data currently are update weekly due to change of customers information. The volume of data is about 5mb.
If anyone can tell me how to keep this link alive this would be greatly helpful.
Thanks in advance.
I have Main.xls which has various customers information.
I have 1001.xls to 1500.xls workbook (about 500 customers workbook, information are save base on customer company code)which summaries information of customers from Main.xls.
Example of Main.xls:
A B C D
1 Co. code Co. name Address Year end
2 1001 A Ltd No.1Road 31/12/02
3 1002 B Ltd No.2Road 31/8/01
4 1003 C Ltd No.3Road 31/10/01
5 1005 D Ltd No.4Road 31/12/02
up to
1500
Example of 1001.xls :
A B
1 Co. code 1001
2 Co. name A Ltd
3 Address No. 1 Road
4 Year end 31/12/02
The data currently are update weekly due to change of customers information. The volume of data is about 5mb.
If anyone can tell me how to keep this link alive this would be greatly helpful.
Thanks in advance.