Increment cell value beginning from user prompted input

**ssmith001** · 03-23-2018, 09:26 AM

I need to prompt a user to input a number (ex. 2228383) and then loop through each cell in column I, incrementing each cell in column I by 1, until reaching the max number of rows in column A (ex, Column A has 60 rows).

Using the example input above,

I2 = 2228383
I3 = 2228384
I4 = 2228385
I5 = 2228386
...
...
...
I60 = 2228443

Any help would be appreciated.

**jindon** · 03-23-2018, 09:45 AM

Try

Please Login or Register  to view this content.

**Arkadi** · 03-23-2018, 09:53 AM

Not knowing all the details, this was my best guess:

Please Login or Register  to view this content.

**ssmith001** · 03-23-2018, 10:20 AM

Jindon,

I was able make your code work with the exception that is is continuing 1 row past the max # of rows in column A. Now I want to skip the incrementing and setting of the cell values for all rows where the Stop Type = PICK (Column D).

Stop Type Seal #
Pick
Drop 2238384
Pick
Drop 2238385
Pick
Drop 2238386
Pick
Drop 2238387
Pick
Pick and Drop 2238388
Pick and Drop 2238389
Pick and Drop 2238390
Drop 2238391
Pick
Pick and Drop 2238392
Pick and Drop 2238393
Drop 2238394

**Arkadi** · 03-23-2018, 10:28 AM

What about Pick and Drop? does that still increment? Maybe you could provide a sample workbook to work with? This new request makes it very different from the original question.

**jindon** · 03-23-2018, 10:32 AM

Then maybe something like this

Please Login or Register  to view this content.

**ssmith001** · 03-23-2018, 10:45 AM

Thank you Jindon. This worked perfectly. I'd like to add one more little tweak, and I want to upload a sample spreadsheet to make it clearer, but I can't figure out how to upload a sample Excel doc.

**jindon** · 03-23-2018, 10:48 AM

You are welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

**ssmith001** · 03-23-2018, 11:06 AM

OK, I figured out how to upload a sample. For column B, I need to merge those cells when Load ID breaks to a new value, and also auto-increment the Door # column, starting at a user prompted input value.

**jindon** · 03-23-2018, 11:20 AM

Try

Please Login or Register  to view this content.

**ssmith001** · 03-23-2018, 11:37 AM

Perfect! Just curious, when I run the code the input box is not centered. From what I've read online, the position is not specified, it should be defaulting to center screen

Increment cell value beginning from user prompted input

LinkBack

Thread Tools

Rate This Thread

Display

Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Re: Increment cell value beginning from user prompted input

Thread Information

Users Browsing this Thread

Similar Threads

How to insure a user is prompted to input a date as format MM/DD/YYYY

[SOLVED] User prompted sheet name stored with quotations. I need them gone to be inputted into sub

[SOLVED] input date column A, increment B, select blank cell in D and input time. in a macro

VBA to prompted user for employee number.

How to be prompted to input filename when saving in an Excel macro

Increment cell value depending on input elsewhere

[SOLVED] not being prompted that user has file open

Bookmarks

Bookmarks

Posting Permissions