creating multiple worksheets from one

J

Jerry

I have a worksheet as follows:
a1: Header: name a2: name of customer a3: Header: VIP a4: info
a5: info a6: info
a7: Header: name a8: name of customer a9: Header: VIP a10: info
a11: info
a12: Header: name a13: name of customer a14: Header: VIP a15: info
a16: info a17: info a18: info
I want to create multiple worksheets to be as follows:
(sheet1) a1: Header: name a2: name of customer a3: Header: VIP a4:
info
a5: info a6: info
(sheet2) a7: Header: name a8: name of customer a9: Header: VIP a10:
info
a11: info in columns a1 ...
(sheet3) a12: Header: name a13: name of customer a14: Header: VIP a15: info
a16: info a17: info a18: info in columns a1...
I can not autofilter because there is different info under the same column
until it finds the next name and the number of rows used is variable, the
header that surrounds the name of the customer is the same for all customers,
can it be possible to create multiple worksheets from this worksheet? Thanks
in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Append all sheet 1
Remove specific cells in a column. 2
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
how to use an formula to transpose a list(left) to be like the right? 2
How to delete ALL cells containing the same data 1
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Merge Append all sheet into 1 1
Which zones are touch given this range 2

Top