+ Reply to Thread
Results 1 to 8 of 8

help with filling a table with data from another table on a true condition

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    help with filling a table with data from another table on a true condition

    Hi,

    I am fairly new to Excel so I'm not sure if this a Function problem or a Macro problem.

    I have a spreadsheet with many columns and rows of data. I need to transfer rows of data from the first sheet to a second if a variable is true. One column('N') in the first table has true/false values. I need to filter through the entire column('N') for 'true' values and then copy each row of data with a 'true' value in column('N') into the second table.

    Can this be done with a Function or do I need to use a Macro for this?
    Please provide examples with your replies.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: help with filling a table with data from another table on a true condition

    Hi and welcome to the forum

    It all depends on what you want, and how you want to do it? You could probably do this with a vlookup() or index/match, but without seeing what you are working with, its hard to say

    i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: help with filling a table with data from another table on a true condition

    FDibbins: Thank you for the reply.

    I have attached part of the workbook I am working with.
    I need to test the entire 'other' column, in the main sheet, for "TRUE" values, then fill the other table with all the data from every row in the 'other' column that is "TRUE".

    The main table will change size every day so I need to account for that as well.
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: help with filling a table with data from another table on a true condition

    OK heres a suggestion for you. Have you tried using filters?

  5. #5
    Registered User
    Join Date
    02-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: help with filling a table with data from another table on a true condition

    I have not worked with filters before just have done some research on them. I'm not real sure how to use them to accomplish what I need since I need this to run automatically.
    Some code or a link to a tutorial on how to use a filter automatically would be very helpful.
    Thanks

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: help with filling a table with data from another table on a true condition

    to use filters, on the home tab on the ribbon, at the end, select sort and filter/filter. it will give you a drop-down that you can select/unselect items in

  7. #7
    Registered User
    Join Date
    02-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: help with filling a table with data from another table on a true condition

    Thanks,
    I copied the main table's content to the other table then filtered it by text. Works exactly how I needed!

  8. #8
    Registered User
    Join Date
    02-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: help with filling a table with data from another table on a true condition

    Thanks,
    I copied the main table's content to the other table then filtered it by text. Works exactly how I needed!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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