LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Can someone give me a simple macro to sort a column?

Hi-
I have a whole bunch of data in several columns and I want to set up the
spreadsheet so when I click the column title it sorts the data (keeping all
the rows together still) ascending and then if I click the column title again
it sorts it descending and so on. I want to do this for every column. I
know very little about macro coding and I would really appreciate it if
someone could give me a sample one and instructions as I feel this must be
pretty simple. I tried searching on google but I can't seem to find
anything. I would really apprecriate any help anyone might be able to offer.
Thanks!
-Dan
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
divide column(x) by column(y) to give column(x/y) in excel? James New Users to Excel 2 April 24th 23 11:46 AM
Use macro to sort column Paula Excel Worksheet Functions 2 August 14th 09 06:59 PM
Hopefully a simple macro to precatenate data in a column Jon in Canby Or. Excel Discussion (Misc queries) 7 April 30th 08 02:33 PM
Macro To Sort By Column Header Names Derek Hart Excel Worksheet Functions 6 December 26th 07 09:41 PM
Filter/sort data to give highest value from each day Cootha Excel Discussion (Misc queries) 10 August 28th 06 08:18 AM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"