PDA

View Full Version : Compare two columns to sheet3 based on condition



vengal
09-13-2013, 02:18 PM
In the workbook there are 2 sheets
1)Postawardlog and 2) budget posted in EIS
Our task:
ACCOUNT in sheet1 and Projectid in sheet2, TOTAL in sheet1 and Amount in sheet2 are columns which needs to be compared. We need to display o/p in sheet3 for only which are not matching. Please see the project1 word document attached for details. Please post me the macro code or email me at vengal19@gmail.com
Please download the attachment project1.xlsm

rollis13
09-13-2013, 02:53 PM
Cross-post:
http://www.mrexcel.com/forum/excel-questions/726485-compare-two-columns-sheet3-based-condition.html
http://www.excelfox.com/forum/f2/compare-two-columns-to-sheet3-based-on-condition-1449/
http://www.excelforum.com/excel-programming-vba-macros/954904-compare-two-columns-to-sheet3.html