I have a large set of data in one worksheet and I want to extract out
specific rows into another tab based on an identified value for each row.
The master worksheet is all customer orders from all over the USA. The rest
of the tabs are by state. For the Michigan Tab i'd like to use a lookup
statement that would copy the entire row of data for any orders from the
master onto the Michigan tab which have "MI" in the state column.

Thanks,

Stephanie