Hello All:

Am perplexed about how to handle something, and hoping someone can advise.
Running Excel 2003, and I am not extremely strong on formula building.

Worksheet One: Table of orders to various accounts (Column A is account
code.)

A B C D E F
CGC Ship To Address City Qty Model
1 D1EFM J.Smith 123 Main Dallas 1 Widget A
2 W1E K. Reed 456 Long Houston 2 Widget B
3 D1EFM J. Smith 123 Main Dallas 1 Widget A
4 U3A T. Jones 987 3rd Springfield 3
Widget C
5 D1EFM J. Smith 123 Main Dallas 1
Widget A

Multiple users update this worksheet, but in order to provide a summary
worksheet by customer code, I would like a separate file to auto update data
from this worksheet, only if CGC (Column A) = "D1EFM". I do not wish to sort
my original table. Any advice on how to best accomplish this, would be
greatly appreciated.

TIA,
Sandi