pyrosax
08-22-2014, 11:20 AM
Hello all you fine Excel/VBA professionals lol (WORKBOOKS AND EXAMPLES ARE ATTACHED)
I need your assistance, because I have no clue what I am doing. :bug:
I have two workbooks. ERP and qry_to_xls_Laborcharges_new.
Each one has some columns that are the same, and some that are different.
The ones with the same data (Although different names) are the ones we care about
I would like to have a VBA code that grabs the data from both workbooks and looks at it like an INNER JOIN and OUTER JOIN.
The example workbook will provide the only 4 cases that will occur.
EXAMPLES 1 & 2 Need not to be reported, but I put it there to ensure there is no confusion.
EXAMPLES 3 & 4 Need to be reported. #3 would resemble an OUTER JOIN. #4 would resemble an INNER JOIN Where Hours is not Equal
The complication comes when both EMPLOYEE NAME columns are not the same. I.E. Dingle, Elmer is in "qry_to_xls..." and ELMER J DINGLE appears in ERP.
I think I clarified it well. If you need any more clarification, please let me know lol
I need your assistance, because I have no clue what I am doing. :bug:
I have two workbooks. ERP and qry_to_xls_Laborcharges_new.
Each one has some columns that are the same, and some that are different.
The ones with the same data (Although different names) are the ones we care about
I would like to have a VBA code that grabs the data from both workbooks and looks at it like an INNER JOIN and OUTER JOIN.
The example workbook will provide the only 4 cases that will occur.
EXAMPLES 1 & 2 Need not to be reported, but I put it there to ensure there is no confusion.
EXAMPLES 3 & 4 Need to be reported. #3 would resemble an OUTER JOIN. #4 would resemble an INNER JOIN Where Hours is not Equal
The complication comes when both EMPLOYEE NAME columns are not the same. I.E. Dingle, Elmer is in "qry_to_xls..." and ELMER J DINGLE appears in ERP.
I think I clarified it well. If you need any more clarification, please let me know lol