Advanced Filtering with multiple criteria

Hi,

I have created a spreadsheet with helicopter parts serial numbers, descriptions quantities etc. And i want to split up the one large spread sheet into multiple sheets. I wanted to have one master summary with everything on it, and then a sheet with just serial numbers from 0-1000 and then 1000-2000 and so on. I then wanted it to whenever i make a change the summary, it updates the relevant sheet with the new information.

So i decided to use an advanced filter on the summary sheet. I then for 0 -1000 serial numbers used ="<2000" for the critirea. Which then created the filter in the specified sheet as i wanted. I then created a macro so that it would update eveyrthing in the summary to correspond to whats in the sheets, but as soon as i got to the 2000-3000 section, it wouldn't let me make a critirea which is "<3000 and >2000" to create the filter which takes the information from between those two numbers. I can't work out how to do it and i was wondering if it's actually possible.

Thanks for the help,

Aaron

Are you using the advanced filter or the custom feature of the auto filter?

If you are using the advanced filter, then remember that you have to put the column heading on both the criteria columns to do what you want.

If you can post the sheet, or a portion of it I would be happy to take a look at it for you.

I have attached the spreadsheet in question. I'll just re-word what i want to do.

I have a sheet which is a complete list of different items ordered in ascending order according to the part number. I then want to filter the list by certain criteria. In my case, i want to split them so that the product numbers ranging from 0 -1000 go into one sheet, and then product numbers from 1000-2000 go in anouther and so on. I worked out a way to do it but i can't get it to work for 2000-3000 because i have to apply to criteria to one column.

So, what i have done for 0-1000 is made an advanced filter of the summary sheet, put the criteria as ="<1000" and then have it flitered into the seperate sheet. Which works as shown in the worksheet. I could then apply a macro so that any new data i input into the summary folder, is then also filtered out and updated in the 0-1000 sheets. Which is fine, but when i come to do 1000-2000, when i put in ="<2000" and =">1000", it doesn't do it because i am applying to simultaneous criteria to one column. So essentially, if i have explained badly, i want to know what the criteria is to filter out the range of data from 1000-2000.

If there maybe anoutherway of doing it please apply it to the spread sheet and attach it in the reply because i have a master copy so it won't matter if you change it.

Thanks for your help.

Thats the one! Thanks very much, i've sorted it now. Thanks alot.