Filtering 1

[max1565]

I have a flat table of data in excel 2000. The range is made up of 35 columns and and may go up tp 65000 rows. I need to be able to filter the range by three separate columns. Say column A (filter for values > 0), column d (filter for 1), and column w (filter for 2003). The resulting data must meet all of the criteria indicated. Then some of the data in certain columns will be copied to another location. Say that the resulting data in column e will be copied to the next empty row on worksheet("database&quot column c.

Does anyone have any suggestions?

I hope I explained this.

Thanks

 

[SkipVought]

max1565,

Why not use AutoFilter?

You can set the filter values programatically. Macro record the process, observe the code and modify accordingly.

Post back if you have any specific problems

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[PHV]

You can play with the AdvancedFilter or AutoFilter methods of the Range object.

Hope This Help
PH.

 

[max1565]

Thanks guys. I think I can use the autofilter method, but one of my filter criteria is the value found at worksheets("work&quot.range("b12&quot. I do not know how to do that part.

Thanks

 

[SkipVought]

    Cells(1,1).AutoFilter Field:=1, Criteria1:=worksheets("work").range("b12")

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com