Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy filter Information
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???? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy information | Excel Discussion (Misc queries) | |||
Copy information from the bottom | Excel Discussion (Misc queries) | |||
When i try to filter information, excel returns a blank page? | Excel Worksheet Functions | |||
How do I copy the information from one workbook to another? | Excel Discussion (Misc queries) | |||
filter and keep same information. | Excel Worksheet Functions |