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 |
All times are GMT +1. The time now is 03:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com