+ Reply to Thread
Results 1 to 23 of 23

Transfer data based on value in Column using arrays

  1. #1
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Transfer data based on value in Column using arrays

    Greetings to all
    I have two sheets ...... Data sheet and Results sheet
    My attachment is just a sample
    the original has large amounts of data

    in sheets "Data".range" A8:J " & Last row
    In sheets "Data". column J recap collecting the values

    Please, I want to transfer data based on the values of the column J
    To Sheet the results as follows
    If the value of the column cells J less than or equal to 14,000
    words Replaces value of is not worth

    I need to use arrays as I know it is faster in dealing with large amounts of data
    I need to keep formatting in the results I mean the results would be formatted as the main table in Data sheet if possible
    Thank you very much to help
    Regards
    Last edited by salmasaied; 09-06-2016 at 10:06 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Transfer data based on value in Column using arrays

    Try this:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    My dear sir, ikboy
    Thank you very much for this wonderful solution
    But there are many formulas in the data sheet original file do not want to transferred with the specified range
    Please Is it possible to modify the code
    Please see the attached
    Thank you very much for the help
    Last edited by salmasaied; 09-11-2016 at 12:06 AM.

  4. #4
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    Please help

  5. #5
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    Any help in this topic please

  6. #6
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    Please help

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Transfer data based on value in Column using arrays

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    My dear sir, jindon
    Thank you very much for this wonderful solution
    Thank you very much for the help
    Best and kind regards
    Last edited by salmasaied; 09-11-2016 at 11:03 PM.

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Transfer data based on value in Column using arrays

    Change to
    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    My dear sir, jindon
    Thank you very much again
    Best wishes to you a happy life

  11. #11
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Transfer data based on value in Column using arrays

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  12. #12
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    My dear sir, jindon
    Certainly a wonderful answer
    And also certainly answer Mr.ikboy answer wonderful
    But the need to be Modify according to latest Attachment
    Thanks for all the gentlemen to help me
    Last edited by salmasaied; 09-12-2016 at 12:55 AM.

  13. #13
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    My dear sir, jindon
    Apologized to return again
    Add in the attached-defined function
    But there is a difference in terms of show results in column K
    With the implementation Workbooks.Add code you will notice me dear friend
    Do not appear the values in column K despite copy the formula
    Is there a way to change the the emergence of the values in column k
    Is it possible to add something that would automatically save the workbook
    Thank you very much for the help
    Last edited by salmasaied; 09-12-2016 at 08:21 PM.

  14. #14
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Transfer data based on value in Column using arrays

    Please Login or Register  to view this content.

  15. #15
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    Thank you very much Mr. Jindon .. you are great and genius
    I think we need to learn a lot of those Japanese codes
    Together we will raise the slogan Made in Japan
    I like your solutions a lot although it is difficult for me but it is distinguished
    Thank you very much for the help

  16. #16
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Transfer data based on value in Column using arrays

    You are welcome and thanks for the reps.

  17. #17
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    My dear sir, jindon
    Very, very happy to meet you in this topic
    You are a great man worthy of trust and respect
    Greetings

  18. #18
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    Greetings to all
    Sorry for the inconvenience to return again
    After the completion of all tests on my program it shows that there is a problem
    please
    I do not want to add a new worksheet or add a new workbook
    But I want to transfer data from the data sheet to sheet Results
    Because of a problem in coordinating print the worksheet
    Accept my appreciation and respect
    Last edited by salmasaied; 10-06-2016 at 10:01 PM.

  19. #19
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Transfer data based on value in Column using arrays

    Please Login or Register  to view this content.

  20. #20
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    My dear sir, jindon
    Although you login hiding except that you like the moon which shines the way for us
    Accept my appreciation and respect
    Last edited by salmasaied; 10-07-2016 at 12:44 AM.

  21. #21
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    My dear sir, jindon
    Is it possible to modify the code using arrays
    Accept my appreciation and respect
    Last edited by salmasaied; 10-07-2016 at 12:44 AM.

  22. #22
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Transfer data based on value in Column using arrays

    I don't want to even look at the code made by others.
    using arrays
    Probably you don't understand but my code DOES used array.

  23. #23
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    257

    Re: Transfer data based on value in Column using arrays

    My dear sir, jindon
    welcome
    thank you very much
    Last edited by salmasaied; 10-09-2016 at 08:42 AM.

+ 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. multiple look up arrays to sum column based on various criteria
    By deanusa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2016, 04:11 AM
  2. Replies: 11
    Last Post: 02-16-2016, 11:06 PM
  3. Please help transfer of data based on value of a Column
    By Oenacman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2014, 04:25 AM
  4. Using Arrays to populate a column based on a look up type table
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-11-2012, 12:09 PM
  5. Replies: 10
    Last Post: 12-25-2009, 08:10 AM
  6. Best Way to Transfer 'Dynamic' 2D Arrays?
    By lyndess in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2009, 02:35 PM
  7. Trying to Transfer Row(s) between worksheets based on Criteria in 1 Column
    By hockeyman in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-22-2008, 02: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