Consulting

Results 1 to 2 of 2

Thread: Auto Update/Sort

  1. #1
    VBAX Mentor Hoopsah's Avatar
    Joined
    Nov 2007
    Posts
    301
    Location

    Auto Update/Sort

    Hi,

    I have a database created within Excel, this database will get added to each day.

    It has to be sorted on about 3 different fields.

    Is there any macro I could use that will get this database updated without having to run the sort command?
    I am playing all the right notes, but not necessarily in the right order.
    Eric Morecambe

  2. #2
    VBAX Tutor
    Joined
    Oct 2007
    Posts
    210
    Location
    use the sort method

    example

    worksheets("Name of Sheet").range("A1:C1000").sort

    (see the help file in VBA for the sort parameters)

    or if you want to generalize the end of the list:

    worksheets("Name of Sheet").range(cells(1,1), cells(last_row, 3)).sort

Posting Permissions

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