+ Reply to Thread
Results 1 to 12 of 12

Auto sort alphabetically 5 Separatet tables according to name collum

  1. #1
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Auto sort alphabetically 5 Separatet tables according to name collum

    Hello,

    I dont understand about VBA or Macros, but if there is a way of doing what i pretend i dont think itīs possible by formulas...

    What i need is to auto sort the data of 5 tables in a second sheet (same document) according to the collum of name. The structure of each 5 tables is the same (code, name, price, obs). The sort must be done alphabetically according to the names in all 5 tables, it will be normal to have empty rows.

    For easier understanding i made an example document, but only with 2 tables, and where i sorted the tables in the 2 sheet mannualy, just so i can "explain" my self. I want to be able to paste data in the 1 sheet, and automatically in the 2 sheet the data will sort...

    Is this possible?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    Hi Fleyd,

    With this you'll still need to insert your "empty rows" manually

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    Hi,

    Thanks for the help, but your macro will organize the tables individually, not in total of all tables - table by table. Dont get me wrong, i apreciate the help, but itīs possible to sort tables individually using the sort function A-Z in the Excel Menus...

    i need to sort the tables according to the names in all of them... Each table will reflect products from diferent suppliers, and not all suppliers have the exact same products, my intention is to make a big table with all products from all suppliers, but where the same/similar products from different suppliers appear in the same row. This way will be possible to compare prices and also have a big portfolio of products, with the cheaper prices...

    I have been told that is not possible, that excel cannot do this...

    Anyone have a solution for this?

    Thanks

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    Hi fleyd,
    one question
    It is normal that there are duplicate names in your tables (for example, "erat. Vivamus")?

  5. #5
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    Yes, because products from diferent suppliers can have the same name (but diferent codes).

    The idea is to compare prices of same products from diferent suppliers, and in the end have a list (table) of all the products with the cheaper prices... Since not all suppliers have all the same products, some rows be "empty"

  6. #6
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    try this
    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    12-16-2014
    Location
    Amsterdam, Nederland
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    HI,

    See attached:

    The macro fetches the names from each table.
    And copies to the Sorted table on the Sorted sheet.
    Duplicate names are removed.
    The names are sorted .
    Formula's fetch the attributes from each table.Alphabetically sort tables v1 (BB).xlsm
    Bas

    Any reputation is appreciated.

  8. #8
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    @nilem
    Itīs perfect!!! Many many Many Thanks. I dont want to push your patiente, but would it be possible to adapt your code to the attached file? I tried, but i dont understand nothing about Macros...and of course it didnt worked... I would apreciate if you could adapt the code to this new file.



    @bartelba
    Also thanks to your help, but your solution wasnt what i expected. But i sinceritly apreciate your help.
    Attached Files Attached Files

  9. #9
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    Here is your file with a modified code
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    Thanks nilem !

  11. #11
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    Hi Fleyd,

    Thanks for the rep - glad you got it solved - I guess I didn't know what you were asking

  12. #12
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Re: Auto sort alphabetically 5 Separatet tables according to name collum

    No problem, thanks again.

+ 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] Resizing First Collum in a Multi Collum Listbox
    By VBTroubles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2014, 05:58 AM
  2. Alphabetically auto sort columns
    By higguns in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2013, 12:16 PM
  3. Auto sort alphabetically using basic macro
    By Tyler1226 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-20-2012, 04:18 PM
  4. Auto Sort Alphabetically
    By gadjit in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-01-2012, 06:30 PM
  5. How to stop auto-sort when making pivot tables
    By alouie457 in forum Excel General
    Replies: 5
    Last Post: 05-02-2010, 12:48 PM
  6. Auto Sort Alphabetically
    By jollygoodfellow in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-18-2008, 10:37 AM
  7. How can I advanced sort into a Collum
    By Dan S in forum Excel General
    Replies: 3
    Last Post: 02-20-2006, 06:00 PM

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