Auto Sorting in Excel 2010

[wolfrayz]

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>

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>

 

[shg]

You're welcome.

 

[cljy_perri]

Hi! I need some help with auto sorting in Excel 2010 as well... not sure what I should be doing.

I have 4 worksheets: a, b c, d.
Each worksheet has columns 1, 2, 3, 4
column 1 is for free text to time in an item and column 4 indicates a value between 1 to 10.

These 4 worksheets are summarised with same details (columns and rows) into worksheet 5. I need to auto sort column 4 in worksheet 5, then auto sort column 1 in alphabetical order.

how do i do this? let me know if it isnt clear, thanks for anyone's help!

 

[Jaime_Ross]

Hi everyone! Im new here and I appologize if I should have started a new thread.. but I wasn't sure. This relates so I thought I would put it here.

I have a spreadsheet that has multiple worksheets on that.. has a "total". I have summarized all the scores to another tab we can call that the "total" tab/worksheet.

On this Total Worksheet.. I only have 2 columns "Topic" A1 and "Score" B1. (my range including header is A1:B9.

B/c the score could change on the 9 other worksheets.. I want this "Totals Worksheet" to auto sort using VB.

I haven't been been able to figure out how to make this work.

Thanks a bunch!!!