reordering columns in excel automatically without a macro

December 24, 2012 at 18:10:52
Specs: Windows 7
I have a spreadsheet for the bowl games. Teams for each game are in the Column A. As the result come out I put a W and an L by the Winner and Loser in column B and I do a rank for this in a row based on a running total for each Entrants confidence entry (1 to 35 ). The entrants are listed in row 1 from column C to AD. I know how to do a sort on the row with running total by highlighting all the columns manually selecting the row I want to reorder by. What I want is to do the reorder automatically as I put in the W and the L. Thanks. I can send the sheet if you like.

See More: reordering columns in excel automatically without a macro

Report •


#1
December 25, 2012 at 01:25:42
If you don't want to use a Macro which is the easiest and obvious way to do it you are going to have to resort the writing a VBA script to do it which is more complicated and requires knowledge of VBA.

There is no way Excel will do an automatic re-order without some input from the user to tell it how to re-order. A VBA script running in the background will do what you want but first you are going to have to write the script.

Stuart


Report •

#2
December 25, 2012 at 02:45:38
If you're using Excel 2010 then in the Data tab in the Sort & Filter section use the Filter option to sort the data according to your requirements. As the data changes it will not automatically update, however there's a Reapply button in the Sort & Filter section which may offer you a single click ability to resort the data, depending on how you've set it up.

Report •

#3
December 25, 2012 at 15:22:54

Report •

Related Solutions


Ask Question