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

X

Xing79

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!
 

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

counif by column2 & column 4 ? 3
Column range to search from a source workbook and then copy/paste 0
Autofilter using range from another sheet as the criteria 0
tabulate output data from different combination of input. 0
Pulling Data From PivotTable 1
calculate a value on a new cell based on the list 1
Compare two datasheets and create a new one with modified and newinformation - Excel 1
Count no. of occurance in 2 dynamic columns within a data period 7

Top