Hi
I need to build a macro that will do the following:
1.For every unique value in columnA generate a new worksheet.
2. Name of the new worksheet should be equal to the unique value.
3. Write "" in known cells in the new worksheet. (certain cells will need to formatted - such as borders etc) but the cell to manipulate will always remain same.
4. Copy values from other cells (or columns) in the same row (as that of the unique value) into known cells on the new worksheet created.
5. Move on to the next unique value and repeat.

Any idea how this can be done in excel 2007?