Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BG BG is offline
external usenet poster
 
Posts: 31
Default Sorting Rows/Columns Automatically

I have a spreadsheet and I want to automatically sort the rows and columns as
new data is entered into blank cells. What is the best way to do this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Sorting Rows/Columns Automatically


You would have to insert a worksheet_change event into the sheet itself
to watch for changes in the key row, but that might get weird since it
would sort as soon as you entered that cell's data, and you'd find the
row you were editing now in the middle of the data set.

Perhaps a less irritating solution would be to record a macro of you
sorting the data and put it on a button on your sheet, you can press it
to quickly sort the new data when you're DONE entering it.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61755

Reply
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
Sorting Rows/Columns Automatically BG Excel Worksheet Functions 0 February 10th 09 05:08 PM
Sorting Rows/Columns Automatically BG Excel Worksheet Functions 0 February 10th 09 05:07 PM
Sorting Several Columns/Rows Automatically BG Excel Worksheet Functions 0 February 10th 09 05:05 PM
Automatically sorting columns by date Schizoid Man Excel Discussion (Misc queries) 1 October 12th 08 10:26 PM
Sorting automatically by columns HumingBean Excel Discussion (Misc queries) 4 December 1st 06 10:46 AM


All times are GMT +1. The time now is 02:30 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"