Marie,

You need a table listing the branches, and giving the district for each in a
column to the right. Then a VLOOKUP would give you the district.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Marie" wrote in message
...
I have a huge amount of data that is downloaded daily. I have the data in
a worksheet and need to extract a district from the data. The problem is the
data only has a branch number, so I have to sort the information by branch
number and manually match that branch number with the district then delete
the rows that I do not need. I have 18 districts that I have to match to
over 100 branches. There is also other criteria that macros pick up from
the data based on the district number. If I just had a seperate macro I
could run first and eliminate the branches I don't need it would save me so
much time. The branches are not in numerical sequence either, for instance
one district might have 55, 56, 122, 123, 124, 125 and 137 as their branches
but I have to match it to another sheets data that only has the district
number 122 and so on. I was trying to set up arrays that like the example
below before all the other criteria. I can't get it to work.

If Range(Array(,55,56,122,123,124,125, 137) 'district 122
cell.offset (0,1).value
else Selection.EntireRow.Delete