Hi I am currently managing customer data in an excel 2000 work sheet. What I want is "Automatic update of datas in a particular row (Sheet 1) to another work sheet (Sheet 2) according to Customer ID Number IN A REQUIRED FORMAT. For Example
Date Customer-Name Product-Purchased Qty Amount Customer-ID
8/11/05 ABC & CO INC Canon PRNT 6600L 3 $785.00 #1001
The above information will be in Sheet 1. As I enter the Customer-ID #1001 it should automatically update in Sheet 2 as follus below:-
Date Customer-Name Product-Purchased Qty Amount
Customer-ID: #1001
12/8/05 ABC & CO INC HP Laser Cartridge 100 $585.65
8/11/05 ABC & CO INC Canon PRNT 6600L 3 $785.00
Hope it explains well. Anybody can help me how to get this thing automatically in excel 2000
Date Customer-Name Product-Purchased Qty Amount Customer-ID
8/11/05 ABC & CO INC Canon PRNT 6600L 3 $785.00 #1001
The above information will be in Sheet 1. As I enter the Customer-ID #1001 it should automatically update in Sheet 2 as follus below:-
Date Customer-Name Product-Purchased Qty Amount
Customer-ID: #1001
12/8/05 ABC & CO INC HP Laser Cartridge 100 $585.65
8/11/05 ABC & CO INC Canon PRNT 6600L 3 $785.00
Hope it explains well. Anybody can help me how to get this thing automatically in excel 2000