I have a chart that I need help with. Is there formula that can carry over
data from one specific row to another chart if a salesperson's initial is
imputed. I'm trying to create seperate charts for each sales person without
having to re-imput the data onto another chart or copy and paste.

A B C D
E
1 Date Customer Name Salesperson's Initials Amount
2 10/10/05 Smith JV
$500.00
3 10/11/05 Johnson CF
$250.00

For example: If row #2 with JV is imputted in the master screen, can row
#2's information be automatically displayed onto another chart without
re-imputing or copying?

Please Help
Thank You
JV