Hello,<o></o>
I am having a slight problem with an auto-sorting macro onan excel sheet. I have a sheet with aheader on row 2, and columns from A to Q, and the information on rows 3 to22. The issue is coming up from columnsB and C. I need the values in column Cto sort greatest to smallest, and then if there are matching values in column Cbut the values in B are different, I need the sheet to sort greatest tosmallest again.<o></o>
Example: In the simplified version of my table below, if the# of stocked Post-Its jumps to 15, I need that moved to the top, but if Reamsof Paper and Post-It’s have the same number of stocked items, but I need 13Reams of Paper, I need that to move above Post-Its. Any help will be greatly appreciated.<o></o>
<tbody>
</tbody>
I am having a slight problem with an auto-sorting macro onan excel sheet. I have a sheet with aheader on row 2, and columns from A to Q, and the information on rows 3 to22. The issue is coming up from columnsB and C. I need the values in column Cto sort greatest to smallest, and then if there are matching values in column Cbut the values in B are different, I need the sheet to sort greatest tosmallest again.<o></o>
Example: In the simplified version of my table below, if the# of stocked Post-Its jumps to 15, I need that moved to the top, but if Reamsof Paper and Post-It’s have the same number of stocked items, but I need 13Reams of Paper, I need that to move above Post-Its. Any help will be greatly appreciated.<o></o>
Names | # of Item Needed | # of Item Stocked |
Tape | 16 | 14 |
Post-Its | 12 | 11 |
Reams of Paper | 12 | 10 |
Coffee Filters | 11 | 9 |
<tbody>
</tbody>