Results 1 to 2 of 2

Thread: Excel Autosorting without Macros

  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Excel Autosorting without Macros

    Hi folks,

    I've tried looking for a solution to my problem on the forums but it seems that all suggestions involve macros and for reasons that I will explain I need a solution that doesn't use macros.

    I require a worksheet that sorts itself accroding to 2 columns - 1. Date 2. Alphabetically. I can obviously do this but I would ideally like it to sort itself everytime a new line of data is entered. It doesn't need to be automatic- if there were one button to press to make the worksheet update that would be fine.

    I can't use macros because this document needs to me shared on Google Docs, which won't allow macro enables worksheets to be uploaded.


    Does anybody have a simple solution to this?

    Many thanks

  2. #2
    Join Date
    Jun 2006
    Posts
    623

    Re: Excel Autosorting without Macros

    I think that you just have to add a unique number to each of the names (that is, to their respective value on which you base the sorting). It might be a simple incremental number like 1, 2, 3,.. Even easier, you could use the ROW() function for that.

Similar Threads

  1. Excel Macros for conditional formatting statement in Excel
    By Kungfu Pandey in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 08:05 PM
  2. Excel 2007 macros have disappeared
    By LakshanA in forum Windows Software
    Replies: 4
    Last Post: 09-11-2010, 08:43 AM
  3. How to Run Excel 2003 Macros in Excel 2007
    By Ekanga in forum Windows Software
    Replies: 5
    Last Post: 19-07-2010, 02:07 PM
  4. How to Run Excel Macros from ASP
    By Chain-SmokeR in forum Software Development
    Replies: 2
    Last Post: 04-07-2009, 11:53 AM
  5. Microsoft Excel VBA (macros list)
    By Samra in forum Windows Software
    Replies: 2
    Last Post: 17-01-2009, 09:34 AM

Tags for this Thread

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
  •  
Page generated in 1,638,699,877.45935 seconds with 17 queries