You could do this easily with a macro but it is better to just use
datafilterautofilter to filter on your desires.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jerry" wrote in message
...
I have a worksheet with several hundred rows that I would like to convert
into several worksheets. Each set of rows have A-R columns, the problem
is
that not every customer have the same number of rows. The information
that
each one have in common is:
row: (header info) Name, grade and other basic header information
row: name of customer followed by info
row: Header info) CDP and other info
next set of rows: beginning info until it finds the same previous tree
rows
for the next customer
so I want to put all of this info in a new worksheet including the header
which is found in rows 1 through 14. page settings to landscape, adjust
to
59, margins and header and footer to 0. Can this be possible? Thank you
in
advance.
r/
Jerry