Sorting without spaces

[tagman]

Hi,
I have a set of data that I'd like to divide up onto individual worksheets using one criterion to select it. When I use this formula
=if(sheet1!a6="Criterion",b6,"")

I get a lot of spaces that I don't want. Is there a way to do it without the spaces?

Thanks

 

[tagman]

They are saved but when change the master data the filters just seem to pick out the rows that originally had the city name in them.

I'm not back in work 'til Friday night so I can't look at again for a while.