VB code needed to change label when a Value ( Size of part) changes in a cell.

[gmach5]

I have a workbook that looks like this:
Each cell contains a number. The first two numbers are the size 16 x 25 and the corresponding label is R1 S1 (which is where they will be stored in "Row 1" "Slot 1" once these pieces are cut to size.
I'm in need of changing the the "Row" when the size changes"??..all of the 16 x 25 are in "Row1" and corresponding slots S1, S2, S3, etc. but once it gets to the next size I need the label "Row to change to R2" and then the slots to go back to "S1, S2, etc. I hope I have explained myself well enough...

16 25 R1 S1
16 25 R1 S2
16 25 R1 S3
16 25 R1 S4
17 35 R2 S1
17 35 R2 S2
18 35 R3 S1

[Eastw00d]

Hi gmach5, welcome to the forum,

I am assuming that the said numbers are in column A, so the locations will be next to that,
perhaps this is what you are looking for:

Please Login or Register  to view this content.

Cheers
Erwin

[gmach5]

I will try this out and let you know. Thank you very much!

[gmach5]

Erwin, The above code is going to work with a few tweeks. I have attached a spreadsheet for you to view. Sheet 1 has the output of the VB code above. Sheet 2 is what it needs to produce.

First, it is copying the number from Cell A1 into the label. The label should read just R1 S1, R2 S2, etc. It does not need the size. The size of the object will be in two columns as shown in the spreadsheet. I also may need to put this into a specific cell??

Thank you so much for helping me with this. I am learning slowly but surely......

[Eastw00d]

OK, you did not mention, that the numbers would be in two cells (2 columns)
So you just place the cursor in the desired column where you want the results and run the macro.

Just one more question: is it possible that in the range of 16 (for example), besides 20, also 21 or another length exist, and must they then have another Rownumber? Because, now, basically, the rownumber changes when the first number, i.e. 16, changes.

Please Login or Register  to view this content.

Cheers
Erwin

[gmach5]

Hi.
The size of the glass will be in 2 separate cells but only the first cell needs to be checked by the VB code. More like...I hope! Smile.

Thank you!

[Eastw00d]

Glad to help & you are welcome


If the provided solution takes care of the original question, please mark the thread as 'SOLVED' from the Thread Tools menu at top of the page & consider adding reputation(s) to those who have helped by clicking the star under their usernames.

Cheers
Erwin