converting one worksheet into multiple ones

  • Thread starter Thread starter Jerry
  • Start date Start date
J

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
 
You could do this easily with a macro but it is better to just use
data>filter>autofilter to filter on your desires.
 
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.
 
My point is to NOT create separate sheets but just use the data on ONE sheet
by using the filter.
 
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.
 
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.
 
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
 
Back
Top