I have one worksheet with multiple columns. In one of these columns (C
I have a number of currencies. However, both the number of rows an
number of currencies can change from day to day. I would like to b
able to create additional worksheets for each of the relevan
currencies and cut the data from workseet 1 into each of the individua
currency sheets?

For example:

Column B has 4 rows.

Row 1 has value of USD
Row 2 has value of EUR
Row 3 has value of EUR
Row 4 has value of FRF
etc.....

After running the procedure I should now have three workseets, one fo
USD with one row, one for EUR with two rows and one for FRF with on
row.

Any pointers in the right direction would be appreciated.

Regards,

Adria

--
Message posted from http://www.ExcelForum.com