Thread: macro that uses column headings as column sort 'buttons'
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default macro that uses column headings as column sort 'buttons'
I like this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html#Rectangles
Sort With Invisible Rectangles

Rob Benz wrote:

This can be done in a word table via a macro; can it be done in Excel?

Click on any column heading and entire spreadsheet is sorted on that column.

--

Dave Peterson
Reply With QuoteReply With Quote