I am working in excel 2003. I have a list of data that I need to filter in
column A, B, C, then I want it to automatically copy the results of D, E, F,
G to D1, E1, F1, G1.

Example:
Manufacture
A1 B1 C1 D1
0 0 0 0


Manufacture Type Size A1 B1 C1 D1
Automax ISOF04 B050 0.585 0.585 0.2187 1.25
Automax ISOF05 B063 0.696 0.696 0.2813 1.50
Automax ISOF07 B085/B100 0.974 0.974 0.3437 2.25
Automax ISOF10 B115/B125 1.42 1.42 0.4063 3.25
Automax ISOF12 B150 1.74 1.74 0.5312 4.00
Automax ISOF14 B175/B200 1.949 1.949 0.6563 4.375

Result I need:

Manufacture
A1 B1 C1 D1
0.974 0.974 0.3437 2.25


Manufacture Type Size A1 B1 C1 D1
Automax ISOF07 B085/B100 0.974 0.974 0.3437 2.25

Can any one help????