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