Creating Multiple Worksheets From A Single Sheet

[Guest]

I need some help to find a way of creating multiple worksheets from a single sheet. I have created a Macro that will insert page breaks after each change of supplier code, I now need to put each set of supplier codes onto seperate sheets in the same workbook...

Please help!!

 

[Ron de Bruin]

Try this

http://www.rondebruin.nl/copy5.htm
Use the last macro on this page for all unique values

--
Regards Ron de Bruin
http://www.rondebruin.nl

I need some help to find a way of creating multiple worksheets from a single sheet. I have created a Macro that will insert page

breaks after each change of supplier code, I now need to put each set of supplier codes onto seperate sheets in the same workbook...

 

[Rollin_Again]

Post your code that seperates the supplier codes. It should be fairl
easy to modify it to put each code on its own sheet. Will any of th
supplier codes repeat within the original datasheet?

Rolli

 

[Rollin_Again]

Can you post the workbook or some sample data? Make sure to includ
some of the repeating data in your sample if you can and I'll try t
help you out.


Rolli