+ Reply to Thread
Results 1 to 5 of 5

Copying the entire row from TABLE A that meets certain criteria to another Table

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    208

    Copying the entire row from TABLE A that meets certain criteria to another Table

    Hi guys. I will really appreciate if anyone can help me out to make my excel formula work. I have attached the sample excel file that I have been working on so far below so you get to have the idea of what I have been trying to achive with it.

    I have come up with a formula which seems to be working fine but it has number of problems I could not fix on my own.

    Basically, what I want to do is to copy the entier row that contains numbers that are below what's in cell CAL "Current Monthly Fee":

    Any help will be highly appreciated.

    Cheers,
    Attached Files Attached Files
    Last edited by JBeaucaire; 12-14-2012 at 10:01 AM. Reason: Everyone's question is urgent....not part of the topic.

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Copying the entire row from TABLE A that meets certain criteria to another Table

    Put the following formula in r17 and drag down/across:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Please click the * icon below if I have helped.

  3. #3
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    208

    Re: Copying the entire row from TABLE A that meets certain criteria to another Table

    Hi Melvinrobb:

    Thank you so much for your help. The formula you've given me works perfectly fine on my excel spreadsheet.
    However, I still have few minor problems which I have no clue how to fix it - see the attached excel sample file below for your review.

    I hope you can help me to get this solved.

    Once again, thank you so much for your help.

    Cheers,
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Copying the entire row from TABLE A that meets certain criteria to another Table

    I added the grey cells in an attempt to eliminate Problem #1. I hope this helps.
    If you want to use the Index and Match functions, I am not sure how to avoid the issue you are having.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    208

    Re: Copying the entire row from TABLE A that meets certain criteria to another Table

    Thanks Melvinrobb. I think that will do. You saved my day Mate. Merry Christmas

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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