converting one worksheet into multiple ones

[Jerry]

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 Guillett]

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

 

[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]

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

 

[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]

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.

 

[Mikel]

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

 

[Gord Dibben]

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