Incremental numbering based upon user input

I have created a macro that processes through information for the creation of checks. I would like to have a way for the user to input a check number, and Excel to take that number, drop it into cell A2, then increment it and drop the next number in A3, and so on until all of the checks have been numbered. The process should stop at such a point as there is no more text
in column B.

Here is an example. Let's say I have 35 checks to write. The first check number is 200. I would want a user box to pop up which asks me for the first check number. I would enter 200. Then the process would place the number 200 in cell A2 (A1 is part of the header information for the checks.) In cell A3, the number 201 would be placed. The final check number would
drop into cell A36. No check numbers would appear in cells A37 and greater because cell B37 is empty, signifying that there is no further check data.

Can anyone help with this?

Thanks so much,
Mike

Perhaps this would work

Please Login or Register  to view this content.

Rylo,

Thank you for the reply to my question. The only problem is that check numbers are created even when there is NOT a text value in column B. One interesteing note .. the check number do stop .. and at the right point. But right now the are some extra lines of check detail on the sheet that should not have check numbers by them.

Here is what I WANT to happen.. (The number 2332 represents a check #) (I needed to use periods to move the text to look like there are in rows)

2332 04 Joe Simpson 1232 Glendale Lane $2000
........................................................Regular pay $1000
.............................................................Sick pay $1000


Here is what IS happening

2332 04 Joe Simpson 1232 Glendale Lane $2000
2333..................................................Regular pay $1000
2334.......................................................Sick pay $1000

I hope this helps identify the problem,
Mike

Rylo,

I have attempted to attach the spreadsheet but it is larger than the allowed size in this forum. However, I have attached a simply .bmp file that shows the result of the two code posts to my question. You will notice that:

1) the header is changed from checknbr to the first check number assigned
2) where the incremented check number should only appear when a "04" (text) is found in cells in column B, there are check numbers throughout.

I hope this helps clear the results up.

Thanks,
Mike

Rylo,

You can download the file at this temporaty location:

http://www.baptistworldmission.org/files.htm

Thanks,
Mike

Rylo,

I have uploaded a revised Excel file in the same location. I have added a second page that shows exactly where and how the check numbers should appear.

Thanks,
Mike

There .. try it now. I uploaded the file, then downloaded it to make sure and, yes, it has two tabs (pages) in it now.

Thanks,
Mike

Based on your bmp file as I can not download any file.

Please Login or Register  to view this content.

Rylo,

WOW ... your code works GREAT! Thank you so much. I really appreciate it!

Mike