+ Reply to Thread
Results 1 to 1 of 1

Autofill columns to the right then sort

  1. #1
    Forum Contributor
    Join Date
    12-11-2010
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    118

    Autofill columns to the right then sort

    Help needed for Autofilling accross and then sorting the entries.
    I have tried this code to autofill cells to the right of the last column that has an entry in row2
    Whenever a new name and information is entered into our matrix, will copy and paste the name in row 2 of the last column entered, however the formula in rows 1, 3 4 and 5 need to be autofilled to the right. Information on the named person can possibly extend 1000 catagories under them (rows)

    This is a "growing" workbook, where additional information will be in rows and Columns

    Most important, I would like to try to Sort ACCROSS these columns - to alphabetically sort the names - (1000 rows down must follow the names). When I do this, then empty cells always show up before the alphabetical sort does, because I sorted out to column AMA, but I never know which the last column is, so I would also have to use the "last column- code" for the sort.

    my code is below
    and I have attached a small slice of the matrix
    Thank you.
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sort by multiple columns with sort criteria cell dependent
    By BRISBANEBOB in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-24-2014, 02:22 AM
  2. Replies: 2
    Last Post: 01-15-2014, 09:31 AM
  3. Replies: 5
    Last Post: 04-25-2013, 11:50 PM
  4. Autofill and sort problem
    By Laverneus Dinglefoot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 03:58 PM
  5. Sort Button that does not sort Balance Columns
    By hasancem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2012, 10:31 AM

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