Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quick and simple way to sort data (2000)

    Image reduced in size by HansV

    I am trying to find the easiest and quickest way to do the following , as l have to do it on a regular basis.

    1.sort the top spreadhsheet so that it only show the rows where Acnowkledged field is equal blank.

    2. Show the relevant columns names. (see bottom spreadsheet example)

    3 To insert the approproate name in the "Who Raised Lot" field . These names are from a word document.
    I have to keep copying and pasting them , is there any way this information can be read automatically from a Word document as l have to keep copying and pasting it all the
    time.

    The current way l do this is to:

    1. Use a filter

    2. Remove unneeded columns.

    3. Type in relevant names in "Who Raised Lot" field.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quick and simple way to sort data (2000)

    You'll have to provide (much) more information - we don't know how the names are stored in the Word document and how they can be related to the data in the spreadsheet.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick and simple way to sort data (2000)

    see attachment for how names are stored in Word

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quick and simple way to sort data (2000)

    And how can we determine which name belongs where in the spreadsheet? Remember, you wanted to automate this. Computers are stupid, so you'll have to provide very clear, complete and unambiguous instructions.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick and simple way to sort data (2000)

    It is quite difficult to determine this. The only way l can think of is that if you look at the document number then go to the bottom of the page of that document you can then find the approproiate name of the person at the bottom.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quick and simple way to sort data (2000)

    That is not enough to automate it.

  7. #7
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick and simple way to sort data (2000)

    It looks as though l will have to use the current method l am using

    i.e use autofilter , remove relevant columns then add names.
    Is there a way to automatically use autofilter and remove relavent columns, if not l will have to use the current method l am using.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quick and simple way to sort data (2000)

    Try recording a macro. You can assign the macro to a toolbar button and/or keyboard shortcut.

  9. #9
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick and simple way to sort data (2000)

    The problem with doing a macro is that when l run the macro l will need to make changes to the spreadsheet and l don't want to make changes to the spreadsheet.
    Is it therefore possible to make a copy of the spreadsheet and run this macro on a copied spreadsheet and then run the macro on the original spreadsheet by calling the one copied spreadsheet (if you see what l mean).

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quick and simple way to sort data (2000)

    Yes, but make sure that you test the macro on a copy of the workbook too.

Posting Permissions

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