Results 1 to 10 of 10

How to Automatically Copy New Data into the next sheet and have it automatically sorted??

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2010
    Posts
    20

    How to Automatically Copy New Data into the next sheet and have it automatically sorted??

    Hello ExcelForum

    This is my first post.

    I would like to have the NEW ENTRIES of Sheet 1 automatically transferred to Sheet 2. When in Sheet 2 I would like the data to be sorted Alphabetically by the 1st column (source column; a-z).

    The data is the same in both sheets; sheet 1 is input by date; sheet 2 is sorted alphabetically.

    I use excel 2010 and have never used macros before. But I have used Visual Basic before (about 3.5 years ago).

    My example workbook is attached.

    Thanks for all your help in advance!
    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