On Tue, 5 Feb 2013 17:55:33 +0000, TimLeonard wrote:


First off thank you very much for the reply, I knew it was something
simple but I just couldn't find it...



Glad to help. Thanks for the feedback.


In your example, you show the sequence ending at those values, not
starting. Please clarify.

I was referring to how the script functions...It starts at the bottom of
the column and looks for the missing values and then adds it.

OK


The intended function...
Ultimately the intent is to compare a database on two separate
worksheets. One database is manually updated or modified and the other
is exported from a field panel and only contains what is programmed in
the panel. That’s why this script is adding the missing row
values to the field database so that the two worksheets will match, then
a comparison can be made between the worksheets and display the
differences on a third worksheet.

For the ability to verify the number sequence will start at LxxD159 &
LxxM159 respectively, where xx ranges from 1 to 10....
The panel supports the capacity of 159 D's and 159 M's on up to 10
different loops. The manually updated worksheet already has the values
ranging from 1 to 159. Therefore I was looking for a way to verify in
the panel worksheet the quantity of loops and then add the missing
values starting at 159 and moving backwards through the columns so the
worksheet rows will match for the comparison. BTW, the quantity of
loops can coms from a column on the panel worksheet

I hope this is understandable...

I think you might be making things needlessly complex. If you are looking for the differences between the two sheets, there are probably simpler ways to do the comparison, depending on how you want the differences reported.