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