Can someone help for this kind of report?
I have a worksheet range from A1:J3788.
Column 1 contains the date informations.
Column 2 to 9 contains customers name.
How to write each individual customer to a new sheet which contain only
2 columns

i.e. date and name.

e.g. In master record (Sheet1) contains

29/10/2003 Albert Robert Bobby....etc
30/10/2003 Robert Bobby Albert ....etc.

The sheet name will be auto named after the name of the customer.

So in sheet Albert will be
29/10/2003 Albert
30/10/2003 Albert

In sheet Robert will be
29/10/2003 Robert
30/10/2003 Robert

In sheet Bobby will be
29/10/2003 Bobby
30/10/2003 Bobby

The routine will start from the first row of sheet1 until the last
row.

Thanks you.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/