Hi,

i have a kind of a data dump on Sheet1 that contains all records.
Column "I" has the latest record status.
Statuses are as follows: Submitted, Incomplete, Pending, Paid.

So what i want to do is to copy Submitted records into "Submitted"
worksheet, Incomplete ones into "Incomplete" sheet and so on.

Thanks