Help With Re-Ordering/Re-Naming Cells

[ncf5031]

Hello all,

I'm looking for some help on a particular issue, as I'm a novice VBA user. If you reference the photo, when I run the "Set up for next stage" macro, all those cells marked "Yes" in columns E and M are cleared and sent to the bottom of the sheet and stored. So in this case, I will be left with column B starting with "5-2" as the first ticket in that silo. What I would like to do is when I run the "Set up next stage" macro, at the end of the macro I would like to change "5-2" to "5-1" and re-number all the subsequent tickets in that silo, up to a max of "5-10".

Any help with this would be appreciated as I haven't been able to find what I'm looking for in the forum.

[Bob Phillips]

A picture tells a thousand words but a sample workbook is a million times better.

[ncf5031]

Bob,

I understand posting the workbook would be great help, but unfortunately information contained within the workbook is proprietary and I definitely don't want to get myself in trouble! Below is the code that I have written for the "Set up for next stage" macro.

Please Login or Register  to view this content.

[Bob Phillips]

That's only half th code, what about SortSandx and sortsandonlocationx?

On a particular point, when you say restart 5-2 at 5-1, in the second set, would that be from 4-1, and if you had two sets now start after n-, would both restart?

[ncf5031]

Bob,

My mistake! I forgot I called those macros within that section of code!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

To answer your second question, if no sand is used from silo 4, then the order in silo 4 will not need to be changed. The order of 5-1, 5-2, etc is the order in which the sand truck physically entered the silo, and subsequently the order in which they will be run.

[ncf5031]

Is posting a copy of the workbook going to help that much with this issue? I have been researching on how to maybe do it but I can't find anything on the internet anywhere that has been helpful.

[ncf5031]

Bumping this up again, hoping for some help soon. I've tried multiple ways of using the sort functions to no avail!

[jindon]

I understand posting the workbook would be great help, but unfortunately information contained within the workbook is proprietary and I definitely don't want to get myself in trouble! Below is the code that I have written for the "Set up for next stage" macro.

You can make a sample workbook with the dummy data.

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[ncf5031]

Thank you for the advice!

I've attached the two workbooks that should be fully functional. If you look at silo 5, one entire ticket was run, and then a partial out of 5-2. On the second workbook, which is just saved and re-named from the first workbook every time, after running the "Set up for next stage" macro, ticket 5-1 is cleared and the order in silo 5 starts out at 5-2. What I'm looking to do is have the "set up next stage" macro change 5-2 to 5-1 and re-name all the subsequent tickets in that silo in numerical order (5-1,5-2, etc.) When this happens however, the weights and BOL# have to move together. So 5-2 now becomes 5-1, but it is still BOL# 70917 with a weight of 47,960 lbs. This has to be done for each silo (1-6) and is currently done manually and is a bit cumbersome.

Whether or not the ticket is marked "Yes" or "Partial" comes from the "Solaris" tab and is dictated by the "x" or "x-y"/"x-z" markings (FYI).