PDA

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



vengal
09-14-2013, 02:24 AM
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 link from below. project1.xlsm

https://www.dropbox.com/s/4mh12roxqh8skhw/project1.xlsm

rollis13
09-14-2013, 02:51 AM
Cross-post:
Compare two columns to sheet3 (http://www.excelforum.com/excel-programming-vba-macros/954904-compare-two-columns-to-sheet3.html)
Compare two columns to sheet3 based on condition (http://www.vbaexpress.com/forum/showthread.php?47503-Compare-two-columns-to-sheet3-based-on-condition)
Compare two columns to sheet3 based on condition (http://www.mrexcel.com/forum/excel-questions/726485-compare-two-columns-sheet3-based-condition.html)

Admin
09-14-2013, 11:15 AM
Hi vengal,

Welcome to ExcelFox!!

Please read the message to cross posters in my signature.