Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Report Question?
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on report writing. | Excel Discussion (Misc queries) | |||
Report Manager question | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
Help of Expense Report Question | Excel Discussion (Misc queries) |