Results 1 to 6 of 6

auto sort data in one column and apply sorting to all columns

Threaded View

lmonroe auto sort data in one column... 01-02-2013, 04:51 PM
Charles Re: auto sort data in one... 01-02-2013, 05:30 PM
lmonroe Re: auto sort data in one... 01-02-2013, 05:42 PM
lmonroe Re: auto sort data in one... 01-02-2013, 06:45 PM
Charles Re: auto sort data in one... 01-02-2013, 09:52 PM
Charles Re: auto sort data in one... 01-03-2013, 08:18 PM
  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    5

    auto sort data in one column and apply sorting to all columns

    Hi All,

    I have some very basic programming experience, but it hasn't been enough to help me through this problem. I have attached the sheet I am working on.

    Ideally, as each person makes modifications to a row on this sheet, they will also change Column A to the number assigned to the person responsible for the next step of the process. Each time any entry in Column A is is changed, I would like the whole sheet to sort automatically (least to greatest or vice versa, it does not matter) The idea is that all projects waiting on input from each person will be grouped together automatically so each person can easily see where their time needs to be spent. The information in each row is tied together and must be kept together. The only (partial) solutions I have come up with on my own and by following other threads only auto sort columns A and B; the rest of the sheet does not change, so that isn't helpful.

    My experience level is such that I know how to use/understand basic logical statements, but I do not know what a 'macro' is.

    Thank you for your help!
    Attached Files Attached Files

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