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
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
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.
Last edited by icestationzbra; 03-18-2012 at 05:01 PM.
Reason: error in the solution, fixed...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1