See if it helps.. Give both range to in input with in a worksheets.. you will get the difference
http://excelpoweruser.blogspot.com/2011/08/if-you-want-to-match-data-between -two.html -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Dec/Fri/2011 02:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Require Help Urgent You need to be MUCH more specific on what you want with cell references and before/after examples. Don Guillett SalesAid Software dguille...@gmail.com -----Original Message----- From: ashjain2...@yahoo.co.in Sent: Thursday, December 29, 2011 10:15 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Require Help Urgent We want to different between last and current month salaries.. And where is different Sent from my Nokia phone -----Original Message----- From: dguillett1 Sent: 28-12-2011 9:30:18 pm Subject: Re: $$Excel-Macros$$ Require Help Urgent You need to be MUCH more specific on what you want with cell references and before/after examples. Don Guillett SalesAid Software dguille...@gmail.com -----Original Message----- From: ashjain2...@yahoo.co.in Sent: Wednesday, December 28, 2011 3:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Require Help Urgent Dear All, Please find sample paysheet for the month of Nov'11 and Dec'11 I want to compare both month paysheet and found that where is excess or less from last month Also i want JOINING_BONUS, REFERRAL_BONUS, NOTICE_PAY, VARIABLE_PAY, LVENCASH, RELOC_ALL and SALARY_ADVANCE is already paid by last month then it showing some error or pop up - -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
