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
Bookmarks