+ Reply to Thread
Results 1 to 6 of 6

Table oder by arrays

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Table oder by arrays

    Hello everybody
    I have a table which I need to convert it to specific order
    I'm struggling with arrays but I'm just a beginner that I need to learn more and more
    Here's an attachment with expected results
    Note that : I need the solution with using arrays
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Table oder by arrays

    Hello YasserKhalil,

    Here is the working version of your macro. I have also added notes to explain the operation.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Table oder by arrays

    See next code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    - Battle without fear gives no glory - Just try

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Table oder by arrays

    Mr. Leith Ross
    Thank you very very much for both the code and the hints .. They are veru useful for me to learn
    Thanks alot for this great and helpful code

    Mr. PCI
    Sorry I didn't see your post ..
    Your code is nearby the other code .. but I liked it too..
    Thanks a lot for offering help
    Regards
    Last edited by YasserKhalil; 06-07-2015 at 06:44 PM.

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

    Re: Table oder by arrays

    Hi Yasser,

    Here's how I usually do these arrays:

    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

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Table oder by arrays

    Thanks a lot Mr. xladpet for this great code

+ 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. Lösung über Formel oder VBA
    By eugen.hasilbach in forum Excel General
    Replies: 9
    Last Post: 02-17-2015, 09:18 AM
  2. [SOLVED] Excel VBA Kopierern durch .Workbooks. .. oder .Windows. .. OOP
    By Doc.AElstein in forum Non English Excel
    Replies: 1
    Last Post: 10-03-2014, 06:26 AM
  3. Excel VBA Kopierern durch .Workbooks. .. oder .Windows. .. OOP
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2014, 07:41 PM
  4. Replies: 0
    Last Post: 01-29-2013, 06:01 AM
  5. Table arrays?
    By Paul T in forum Excel General
    Replies: 2
    Last Post: 07-01-2005, 01:05 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