+ Reply to Thread
Results 1 to 3 of 3

Sorting by certain column for all open sheets except 2

  1. #1
    Registered User
    Join Date
    05-30-2016
    Location
    The Netherlands
    MS-Off Ver
    2013
    Posts
    26

    Sorting by certain column for all open sheets except 2

    Hello,

    I'm trying to find a solution to A-Z sort all my rows in all my open sheets based on column "C" .
    Now i want to do this for all open sheets except for the last 2 sheets which are named "Sheet2" and "Sheet1".
    To get this in one macro would help me a lot.
    If anyone could help me out it would be greatly appreciated, as i`m not good with VBA.
    Last edited by Gunther09; 06-06-2016 at 06:11 PM.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Sorting by certain column for all open sheets except 2

    Are the worksheet names going to change?
    If not then I would suggest trying to record a macro doing exactly what you want and seeing how close that will get you.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    05-30-2016
    Location
    The Netherlands
    MS-Off Ver
    2013
    Posts
    26

    Re: Sorting by certain column for all open sheets except 2

    Yes, the sheet names will change with every workbook i receive from our supplier. But the order they're in stays the same.

+ 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] Sorting first column not working, sorting column 2 and 3 does (same code)
    By jokris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2016, 03:08 AM
  2. Replies: 1
    Last Post: 01-25-2014, 02:10 PM
  3. [SOLVED] Sorting data from a master sheet to multiple sheets depending on values in a given column
    By kodos10 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-30-2013, 05:46 AM
  4. [SOLVED] Sorting a range to invert it upside down without sorting by any specific column
    By luv2glyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 12:43 PM
  5. Excel 2007 : Sorting Same column under different Sheets
    By jantonio in forum Excel General
    Replies: 0
    Last Post: 01-21-2010, 01:19 PM
  6. Replies: 0
    Last Post: 03-06-2006, 01:07 PM
  7. Linking sheets when sorting row and column data
    By Sean 3DD in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-05-2005, 09:06 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