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!