| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel sheet contects are to be formatted into some specific format
Hello all,
I have excel sheet as below ---------------------------------------------------------------------------------------------- Col1 Col2 Col3 Col4 Col5 Project Team Application Project ID Department Divisio ----------------------------------------------------------------------------------------------- ..NET Stds .NET Stds Remove Stds S3 Arch S3 ..NET Stds .NET Stds Remove Stds S3 Arch S3 ..NET Stds .NET Stds Remove Stds S3 Arch S3 ACES Dev ESA Sys ESA Enhance ACES Servicing ACES Dev ESA Sys ESA Enhance ACES Servicing ACES Dev ESA Sys ESA Enhance ACES Servicin ------------------------------------------------------------------------------------------------ Proj Team , Application, ProjectID are sorted on one other. There are some 3000 rows in this sheet I need this content in this format $VALUE .DISP_ORDER 0 .COL1 .NET Stds .COL2 .NET Stds .COL3 Remove Stds .COL4 S3 Arch .COL5 S3 $VALUE .DISP_ORDER 1 .COL1 .NET Stds .COL2 .NET Stds .COL3 Remove Stds .COL4 S3 Arch .COL5 S3 $VALUE .DISP_ORDER 2 .COL1 .NET Stds .COL2 .NET Stds .COL3 Remove Stds .COL4 S3 Arch .COL5 S3 and so on.................... I want this output into a text document How can i create a macro to do this? Can anyone please help me with this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Inserted pictures formatted in PNG format. | Excel Discussion (Misc queries) | |||
| copy a formatted cell to another sheet as text without format | Excel Discussion (Misc queries) | |||
| Dates in Excel - yyyymmdd, not formatted, how do I format this? | Excel Discussion (Misc queries) | |||
| Excel shouldn't bitch about a "date format" when formatted as txt | Excel Discussion (Misc queries) | |||
| Entering Data in 1 Worksheet to appear in a specific format in Sheet 2 | Excel Programming | |||
Hybrid Mode
