Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 21st 05, 02:16 PM
Graham Mason
 
Posts: n/a
Default Sorting data automatically

I have a Workbook with a number of worksheets linked to a master sheet at
the front. If any data changes in any of the worksheets, I would like to
sort automatically on the master sheet, i.e. if a date changes I would like
to sort the dates in their new order. Can this be done?
Using Excel 2003



  #2   Report Post  
Old May 21st 05, 02:47 PM
Bob Phillips
 
Posts: n/a
Default

Record a macro to sort the data on the master sheet, and then add this event
code.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Call yourMacro
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

Just make sure that your macro activates the master sheet, then returns to
the activesheet. Something like

Dim returnPlace As Range

Set returnPlace = ActiveCell
Worksheets("Master").Activate
'do the sort
returnPlace.Parent.Activate
returnPlace.Activate


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Graham Mason" wrote in message
...
I have a Workbook with a number of worksheets linked to a master sheet at
the front. If any data changes in any of the worksheets, I would like to
sort automatically on the master sheet, i.e. if a date changes I would

like
to sort the dates in their new order. Can this be done?
Using Excel 2003




  #3   Report Post  
Old May 21st 05, 09:45 PM
RagDyeR
 
Posts: n/a
Default

If you have the option to use a "helper" column to display your sorted
dates, this could be accomplished *automatically*.

For example. if A1 to A50 on your master sheet were linked to columns of
dates on the other sheets, you could enter this in B1:

=SMALL($A$1:$A$50,ROW())

And drag down to copy.
Make sure that Column B was formatted to display dates.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Graham Mason" wrote in message
...
I have a Workbook with a number of worksheets linked to a master sheet at
the front. If any data changes in any of the worksheets, I would like to
sort automatically on the master sheet, i.e. if a date changes I would like
to sort the dates in their new order. Can this be done?
Using Excel 2003





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 data by last to digits Brian Excel Worksheet Functions 2 February 23rd 05 05:44 PM
Need help Sorting data monkeytrader Excel Worksheet Functions 2 February 21st 05 04:34 AM
Updating calculations automatically when i enter in new data chica_guapa Excel Discussion (Misc queries) 1 February 8th 05 10:17 PM
Help in Sorting Data Please! Dawn Boot-Bunston Excel Worksheet Functions 2 November 24th 04 07:43 PM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 11:47 AM


All times are GMT +1. The time now is 10:26 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017