On Dec 12, 10:58*am, "Bob Phillips" wrote:
Can you give us some sample data that we can try it on?


Ok, Bob, here is some data, since I don't know how I can attach a
spreadsheet in this group within the google groups interface.

1 182 470 0 51079000 51079000-30 001 001
1 182 470 0 10104000 10104000-30 001 001


Explanaton: Columns A to F in this case extend through the "0" values
just after the "470"; meaning there are two columns with no values in
them in this case. Columns A to F are copied down as far as the number
of rows in crows. H and I are blank data fields, but populted with ' '
in them just B and C are. J is populated earlier through a separate
function, so its here just so you can see the variation in types of
data. Some fields are formatted numerically, and others are formatted
with characters. I had a problem with the columns K and L on the
autofill because 001 is a constant and I can't have it increment by 1
each row. That is why column L, the 2nd 001 just got changed to be
like the copy opearation shown in this macro in column K, so it won't
increment by 1 like it was doing.

I could of attached the whole spreadsheet to make it easier to play
with, but I didn't know how to do it in this interface.