Script to Split up Worksheet into Multiple Sheets based on a Columnof Data
 

Hi, need help on the following...

If I have a worksheet with the data as follows:

Fruit Color Price (Header Row)
Apple Red $1
Apple Green $2
Banana Yellow $3

How do I write a script to:
- Based on ColA, create a new worksheet named "Apple", "Banana"... etc
- Within the new worksheets, keep the same formatting as the master
worksheet (headers etc.), and copy only the relevant rows there? e.g.
in "Apple" worksheet, it shows

Fruit Color Price (Header Row)
Apple Red $1
Apple Green $2

Thanks!

Script to Split up Worksheet into Multiple Sheets based on a Column of Data
 

G'day

Go to:

www.rondebruin.nl

Ron has quite a few examples of this.

HTH
Mark.