Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing Macros
Need some help. I've just started writing macros and this is over my head.
I have data that I need to reformat and place in another worksheet the save in a space delimited(.prn) format. I don't know how many rows I will be copying but I'm dealing with two columns. One is a numeric value the other is a title. I need to reformat the numeric to five digits, and reformat the titles to have ' ' around the values. Example Reformat 5 fname field 00001/00005c, title='fname' 5 lname field 00006/00005c, title='lname' 7 city field 00011/00007c, title='city' Left is raw data right is reformatted data. There can be many more rows this is just an example. Also the first # is derived from a formula, based on the two previous #. The very first # is always 1, 1155, 1355 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing Search Macros | New Users to Excel | |||
Writing Macros | Excel Discussion (Misc queries) | |||
Writing Macros | Excel Worksheet Functions | |||
Books on writing Macros | Excel Discussion (Misc queries) | |||
Writing Macros in Excel | Excel Programming |