General discussion

  • Creator
    Topic
  • #2190129

    Sort A-Z in diff.columns in Excel 2003

    Locked

    by fadbel ·

    I have a listing of my library of SF books I keep in Excel. For ease of printing, I divide the items into two columns per page, alphabetically down the first column then up to the second column and down to page 2 where I repeat the sort.
    Is there any way I can link the bottom of column 1 on page 1 to column 2 on page 1 and then to column 1 on page 2 and so on? I would like to add new entries to the end of the document and then sort so the new entries are placed in proper sequence.
    All this is so that each page retains the proper A-Z relationship with the following column.

All Comments

  • Author
    Replies
    • #3066114

      Reply To: Sort A-Z in diff.columns in Excel 2003

      by misscrf ·

      In reply to Sort A-Z in diff.columns in Excel 2003

      no it is not possible. You can select a spreadsheet, and then sort ascending (a-z) 1 row, decending(z-a) another row and so on. Just click the square between A and 1. This highlights the whole sheet. Then go to Data/Sort.

      You will see what I mean. You can sort ascending on Row A then row b, but not the way you want to. Especially with the sort breaking on the page. If this is what you reallly need, I would look at importing the data to Access and creating a report from there. A lot more that you can do from there.

      • #3066023

        Reply To: Sort A-Z in diff.columns in Excel 2003

        by fadbel ·

        In reply to Reply To: Sort A-Z in diff.columns in Excel 2003

        Poster rated this answer.
        Thanks for the input. I am aware of the available sort methods. What I’m looking for is the possibility that someone may know of a way to possibly use Visual Basic within Excel to direct the specific linking I’m suggesting.

    • #3068878

      Reply To: Sort A-Z in diff.columns in Excel 2003

      by bschaettle ·

      In reply to Sort A-Z in diff.columns in Excel 2003

      Print 2 Pages Per Sheet
      Since you menioned “pages” I assume you’re doing this for printing reasons. If so, just let your printer handle this issue. See if the printer has an advanced option for printing multiple pages on each sheet of paper; if so, you can just select “Print 2 Pages Per Sheet” to get the effect you want.

      • #3060153

        Reply To: Sort A-Z in diff.columns in Excel 2003

        by fadbel ·

        In reply to Reply To: Sort A-Z in diff.columns in Excel 2003

        Poster rated this answer.
        Sorry but the way I want the list to come out is in newspaper format. i.e. Start at column one to bottom of page and then go to the top of column two and continue. Excel does not support that type nor does the printer print multiple pages in that format.

    • #3060152

      Reply To: Sort A-Z in diff.columns in Excel 2003

      by fadbel ·

      In reply to Sort A-Z in diff.columns in Excel 2003

      This question was closed by the author

Viewing 2 reply threads