+ Reply to Thread
Results 1 to 2 of 2

Dynamic Sort

  1. #1
    Registered User
    Join Date
    05-08-2007
    Posts
    12

    Dynamic Sort

    Is it possible to have a sheet automatically sorted when it is based on averages taken from other sheets?

    ie. i input data in multiple sheets but i have a sheet called "summary" that has all the data shown in one area. i would like this sorted automatically as i input the data based on one column

    I would like Rows 19 thru 28 sorted, based on column P

    also, what would need to be added to give it a second sort, ie. if column P matches then sort by column N

  2. #2
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686
    i would like this sorted automatically as i input the data based on one column
    Assuming you're inputting the data on the multiple sheets, not on the summary, the updating of the summary only needs to happen when you activate the summary sheet.

    So, record a macro of you sorting the summary sheet. (You can sort on 3 criteria using Data > Sort.)

    Then call the macro you recorded in the Private Sub Worksheet_Activate()

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1