+ Reply to Thread
Results 1 to 2 of 2

how to copy rows from one table to the other basing on same values on specified columns

  1. #1
    Registered User
    Join Date
    03-17-2012
    Location
    Manila, Phlippines
    MS-Off Ver
    Excel 2007
    Posts
    7

    how to copy rows from one table to the other basing on same values on specified columns

    i really appreciate the previous help it really was a life saver thanks to JBeaucaire

    though i need another help with this one: basically i have two tables each having a common column what i need is a formula, addin, or macro that would allow me to copy all the values in a row if and only if the values on the common columns match-up, and if the values did not match up it would simply be blank.

    i already did a a search on this one and it is somehow relevant and it has almost same problem as mine here's the link: http://www.digdb.com/excel_add_ins/j..._tables_lists/


    and here's this is the workbook im working right now

    mock db.xlsm

    as would see sheet1 contains my data wherein the column "date" only has dates falling on the weekdays but on sheet1 the column "date" has the complete days of the month including saturdays and sundays and the result i need is that the values on sheet1 will be copied to the table on sheet2 leaving the saturday's and sunday's on sheet2 as blank

    many many thanks in advance

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: how to copy rows from one table to the other basing on same values on specified column

    if you are looking for a formulaic way of doing this, and if i have understood your requirement correctly, see if the attached helps.
    Attached Files Attached Files
    Last edited by icestationzbra; 03-18-2012 at 05:01 PM. Reason: error in the solution, fixed...

+ 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