I have all records in one sheet with multiple records for each region. I
want to create a tab for each region containing all that region's records.
The number of records will be different for each region.
I've tried several variations of vlookups and change the selected column as
I copy across. This works but when I copy down, I get multiple copies of the
first record for that region. Like this:
=IF(ISERROR(VLOOKUP('All records'!$A$5,'All records'!$B$1:$H$30,1,FALSE)),"
",VLOOKUP('All records'!$A$5,'All records'!$B$1:$H$30,1,FALSE))
I used the iserror because I thought I could just copy the down and when the
lookup did't find any more matches it would print blanks, That didn't work
either. FYI: Column A od all records contains the region names and I was
incrementing the "1" as I copied across.

Anyway, none of this worked past the first record so any ideas would be
appreciated.
WAL