| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Rows From To CSV File
I have a spreadsheet with the current worksheet that has data in the format listed below. The dates are in row1 and the state abbreviation are listed in Column A. The values for each states are listed on each row. Please help me create a macro that will take the worksheet values and output to a CSV file in the desired output listed below. Thank you very much. Spreadsheet 5/26/07 5/27/07 5/28/07 ... 08/30/07 NM 56.0 68.0 72.0 64.0 TX 23.0 28.0 34.0 16.0 NY 16.0 18.0 22.0 32.0 Desired Output 5/26/07,NM,56.0 5/27/07,NM,68.0 5/28/07,NM,72.0 .... 8/30/07,NM,64.0 5/26/07,TX,23.0 5/27/07,TX,28.0 5/28/07,TX,24.0 .... 8/30/07,TX,16.0 5/26/07,NY,16.0 5/27/07,NY,18.0 5/28/07,NY,22.0 .... 08/30/07,NY,32.0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows to another file | Excel Worksheet Functions | |||
| copy rows to another file | Excel Worksheet Functions | |||
| copy rows to another file | Excel Worksheet Functions | |||
| Copy rows from another file | Excel Discussion (Misc queries) | |||
| Copy rows from one file to another file | Excel Programming | |||
Threaded Mode
