Excel Sorting

  • Thread starter Thread starter simon4sam
  • Start date Start date
S

simon4sam

I have looked at cannot find!, Does anyone know how to automaticall
sort a table every time the workbook is opened. Altough its easy t
sort a table, the older people in my company tend not to know this, s
it would make it much easier for them if a table could be sorted fo
them each time they opena workbook.

Kind Regards

Simo
 
if you wrap a sort into a macro it will recalculate when
opening the workbook. go to tools, record macro, then
highlight range, do the appropriate sort, then stop macro
and assign it to a button if you like...

cheers
nick
 
Start by recording a macro and then put the code into the workbook ope
event. VB Editor Ctrl +R, double click on ThisWorkbook.

Private Sub Workbook_Open()

End Su
 
You may not be able to do this, but maybe you could add Data|Filter|autofilter
to your table.

I bet that they'll be able to use the dropdowns. And sometimes a filter is as
useful as sorting.

Make sure you explain to them how to Data|filter|Show All. I've seen a couple
(not quite older users) complain that most of their data was gone when it was
just hidden.

Remind them that the color of the dropdown arrow changes and the row numbers
change color when the table is filtered, too.
 
Back
Top