+ Reply to Thread
Results 1 to 5 of 5

Sorting Columns on second sheet

  1. #1
    Registered User
    Join Date
    12-05-2019
    Location
    no
    MS-Off Ver
    MS Office 2016
    Posts
    2

    Question Sorting Columns on second sheet

    I have two sheets. The command Button is in the first and I am trying to sort the second sheet.

    The problem is that my code always sorts the first sheet not the second.

    Worksheet 1 is called "AllContacts" and Worksheet 2 (in which I want the sorting to happen) is called "contacts".

    Please Login or Register  to view this content.
    This code always sorts the column AE in "AllContacts"

    Hope somebody can help me.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Sorting Columns on second sheet

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Sorting Columns on second sheet

    Please Login or Register  to view this content.

    @ Pepe - Office 2016 is in the Profile which I assume would be Excel 2016, apologies if incorrect

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Sorting Columns on second sheet

    @nigelog
    Now it is. When I posted it wasn't

  5. #5
    Registered User
    Join Date
    12-05-2019
    Location
    no
    MS-Off Ver
    MS Office 2016
    Posts
    2

    Re: Sorting Columns on second sheet

    Thank you so much. It worked

+ 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. Replies: 16
    Last Post: 04-20-2017, 12:18 PM
  2. [SOLVED] Sorting data from rows (multiple sheets) in columns (one sheet)
    By ANA M in forum Excel General
    Replies: 2
    Last Post: 03-16-2015, 08:54 AM
  3. [SOLVED] Sorting columns during sheet deactivation
    By pnewbury in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-02-2013, 06:57 AM
  4. Replies: 2
    Last Post: 07-03-2013, 06:17 PM
  5. [SOLVED] Exporting specific data columns from sheet and sorting by string
    By ardais in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-04-2012, 12:43 AM
  6. sorting two columns and write the sorted values on two columns in a different sheet
    By virsojour in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-22-2010, 04:38 AM
  7. Sorting rows and moving columns in a locked sheet.
    By agentscreech in forum Excel General
    Replies: 5
    Last Post: 08-30-2010, 10:11 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1