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

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

Don: Is this going to create separate worksheets or do I have to create avery
single worksheet. I don't want to copy and paste for over 300 customers and
create the worksheets manually.

"Don Guillett" wrote:

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

My point is to NOT create separate sheets but just use the data on ONE sheet
by using the filter.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jerry" wrote in message
...
Don: Is this going to create separate worksheets or do I have to create
avery
single worksheet. I don't want to copy and paste for over 300 customers
and
create the worksheets manually.

"Don Guillett" wrote:

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

Don:
The reason as to why I have to create worksheets for each customer is they
get distributed throughout the shop based on their requirements. Filtering
allow them to see other info not disseminate it to them or their position.

"Don Guillett" wrote:

My point is to NOT create separate sheets but just use the data on ONE sheet
by using the filter.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jerry" wrote in message
...
Don: Is this going to create separate worksheets or do I have to create
avery
single worksheet. I don't want to copy and paste for over 300 customers
and
create the worksheets manually.

"Don Guillett" wrote:

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

Not when you copy VISIBLE cells only and then distribute
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jerry" wrote in message
...
Don:
The reason as to why I have to create worksheets for each customer is they
get distributed throughout the shop based on their requirements.
Filtering
allow them to see other info not disseminate it to them or their position.

"Don Guillett" wrote:

My point is to NOT create separate sheets but just use the data on ONE
sheet
by using the filter.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jerry" wrote in message
...
Don: Is this going to create separate worksheets or do I have to create
avery
single worksheet. I don't want to copy and paste for over 300
customers
and
create the worksheets manually.

"Don Guillett" wrote:

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