+ Reply to Thread
Results 1 to 3 of 3

Macro for arranging in descending order.

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Macro for arranging in descending order.

    Hello All,

    I am new to this forum (a little over than a week). Frankly speaking, i haven't seen an MS Excel VBA forum so active with all experienced individuals. I would require your assistance in writing a macro and would appreciate any help on it.

    I have these three enclosed files which i update every week.Each of the three sheets include:

    Row 1: Red highlighted area is for a new transaction and date at which it occurred.
    Row 2: Description of the transaction (will always remain fixed)
    Row 3: Details of the transaction (could go up to a maximum number of 10-15)

    The challenge that i face is of arranging them in descending order (latest date transaction should appear first following the others) in a separate spreadsheet.

    Please help..Thank you...
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor blane245's Avatar
    Join Date
    Melbourne, FL
    MS-Off Ver
    Excel 2010

    Re: Macro for arranging in descending order.

    Welcome to the forum! How expereinced are you with Excel VBA? I've got an idea for how to do this, but I need to know where you are coming from.
    Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010

    Re: Macro for arranging in descending order.

    Hello Taureankv,

    Welcome tot he Forum!

    I have added the following macro to the attached workbook. This will sort all the accounts in the open workbooks and copy the account information tables to the main workbook on "Sheet1".

    The macro assumes the following conditions:
    1) The layout of the actual files to be the same as the original.
    2) All worksheets that contain account information are assumed to be named "Sheet1".
    3) All account information data is separated by 1 blank line.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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