Hey guys. I am working on a project for my Controller and have run
into quite a road block. Here is the issue... I have a chunk of data
from column A-N that is several thousand lines long. In column C is
the department number which changes every few hundred lines. For
example, from lines 1-150 is the department number 2240, in rows
150-220 is department number 2241 and so forth until the end of the
data set(each set of department numbers does not have the same number
of lines). There are 30 such department numbers. I need to be able to
take the first chunk of data, from column A-N, down to the end of
department 2240 and paste it into a separate tab. Then I need to pull
the second chunk of data with department 2241 and place it in a second
tab and so firth until all of the data has been split into 30 different
tabs. I have tried a formula to pull the lines corresponding to each
department but the file is so large after 5 tabs that it is unusable.
Thus, I need a macro. Here is an example of what I need using only
five columns. Each space represents a new cell...

A Kim 2240 $580.00 2/3
B Leah 2240 $263.00 2/8
C Angelita 2240 %1967.00 2/3
D Mason 2240 $423.95 1/30
E Kate 2241 $36.45 1/17
F Sumera 2241 $214.35 4/25
G Annette 2241 $673.87 2/18

I need to be able to pull the first four rows into the frist tab and
the next three rows into the second tab and so forth(if there was more
data). I know this is a complex project but does anyone have any
ideas?

Thanks!!
Nora Church