Results 1 to 23 of 23

Transfer data based on value in Column using arrays

Threaded View

  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.

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