converting one worksheet into multiple ones
 

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

converting one worksheet into multiple ones
 

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

converting one worksheet into multiple ones
 

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

converting one worksheet into multiple ones
 

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

converting one worksheet into multiple ones
 

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

converting one worksheet into multiple ones
 

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

converting one worksheet into multiple ones
 

All,

I'm looking for similar type macro. I'm brand new on this.

Scenario: I have set of data with a unique data set in column A,
Also, same coloum A has multiple data set as well. A good example:
Manager 1 has 10 employee( first name, last, Address, Phone …..)
Manager 2-- the same. I would like to create a macro that can create
every manager into their own worksheet or a workbook. I really need
help as I have no Idea where to start.

Any help will be appreciated.
Thanks,
Mikel



On Sep 8, 10:35*am, "Don Guillett" wrote:
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- Hide quoted text -

- Show quoted text -

converting one worksheet into multiple ones
 

Visit Ron de Bruin's site for a macro to filter and copy to a new sheet.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 08:23:30 -0700 (PDT), Mikel
wrote:

All,

I'm looking for similar type macro. I'm brand new on this.

Scenario: I have set of data with a unique data set in column A,
Also, same coloum A has multiple data set as well. A good example:
Manager 1 has 10 employee( first name, last, Address, Phone …..)
Manager 2-- the same. I would like to create a macro that can create
every manager into their own worksheet or a workbook. I really need
help as I have no Idea where to start.

Any help will be appreciated.
Thanks,
Mikel



On Sep 8, 10:35*am, "Don Guillett" wrote:
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- Hide quoted text -

- Show quoted text -