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