Re: $$Excel-Macros$$ Find differences in two worksheets.

[Mr excel]

Nice different approach verma...thanks a lot.is there any formula to do
the same.i mean to find out the differences between the two sheets.

-- 
FORUM RULES (986+ 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

RE: $$Excel-Macros$$ Find differences in two worksheets.

[Rajan_Verma]

Try this:

Please remove Replace all error by 0 or other Characters with in Ranges
before Compare 

 

 

Sub ShowDifferen()



Dim Arr1

Dim Arr2

Dim rng1 As Range

Dim rng2 As Range



Dim lngRow As Long

Dim intCol As Integer

Set rng1 = Application.InputBox("Please select First Range", , , , , , ,
8)

Set rng2 = Application.InputBox("Please select Second Range", , , , , ,
, 8)



Arr1 = rng1

Arr2 = rng2



If UBound(Arr1, 1) = UBound(Arr2, 1) And UBound(Arr1, 2) = UBound(Arr2,
2) Then

For lngRow = LBound(Arr1) To UBound(Arr1)

For intCol = LBound(Arr1, 2) To UBound(Arr1, 2)

If Arr1(lngRow, intCol) <> Arr2(lngRow, intCol) Then

rng1.Cells(lngRow, intCol).Interior.Color = 682978

rng2.Cells(lngRow, intCol).Interior.Color = 682978

End If

Next intCol

Next lngRow

Else

MsgBox "Ranges are not same", vbInformation

End If



 

End Sub

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mr excel
Sent: 14 May 2012 7:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find differences in two worksheets.

 

I want to know  the differences between the two sheets.i.e. Main
worksheet(Master SHEET) and the Current Month(Apr'12) Worksheet.

Please give me any formula or code for finding out the differences between
the two sheets.
I m attaching the worksheet as an example..

Thanks

-- 
FORUM RULES (986+ 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 (986+ 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


Copy of excel (2).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Find differences in two worksheets.

[Anil Gawli]

PLs see attached file

On Mon, May 14, 2012 at 7:49 AM, Mr excel  wrote:

> I want to know  the differences between the two sheets.i.e. Main
> worksheet(Master SHEET) and the Current Month(Apr'12) Worksheet.
>
> Please give me any formula or code for finding out the differences between
> the two sheets.
> I m attaching the worksheet as an example..
>
> Thanks
>
> --
> FORUM RULES (986+ 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
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
FORUM RULES (986+ 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


excel.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Find differences in two worksheets.

[Mr excel]

I want to know  the differences between the two sheets.i.e. Main
worksheet(Master SHEET) and the Current Month(Apr'12) Worksheet.

Please give me any formula or code for finding out the differences between
the two sheets.
I m attaching the worksheet as an example..

Thanks

-- 
FORUM RULES (986+ 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


excel.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Find differences in two worksheets.

[NOORAIN ANSARI]

Dear Mr. Excel,


http://www.office-addins.com/plugins-reviews/excel-compare-workbooks-worksheets/

-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

On Mon, Apr 16, 2012 at 7:38 AM, Mr excel  wrote:

> hi group,
>
>   I had a routine question regarding the comparision of worksheets.I had
> searched the internet regarding the differences between two worksheets
> which have similiar columns & headings.I want to find out the
> changes/differences between the two worksheets.
>
> In depth, I had a master worksheet with columns of EmpNo,Emp
> Name,BASIC,HRA,DA & other allowances.I also get worksheet with the similiar
> headings every month from the HR dept to check the differences like new
> joinees or Resigned employees with their salary structure.what i want is to
> know how to find out the differences / changes between the twoI want
> the changes in every column in new worksheets.
>
> I tried using the pivot table.is my approach the easiest or accurate
> one.i would also like to know whether the same can be done using formulas
> or VBA.
>
> Pls Help.
>
> Thanks & Regards.
>
>  --
> FORUM RULES (986+ 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 (986+ 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

Re: $$Excel-Macros$$ Find differences in two worksheets.

[dguillett1]

Provide file(s) and complete explanation and examples.

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: Mr excel 
Sent: Sunday, April 15, 2012 9:08 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Find differences in two worksheets.

hi group,

  I had a routine question regarding the comparision of worksheets.I had 
searched the internet regarding the differences between two worksheets which 
have similiar columns & headings.I want to find out the changes/differences 
between the two worksheets.

In depth, I had a master worksheet with columns of EmpNo,Emp Name,BASIC,HRA,DA 
& other allowances.I also get worksheet with the similiar headings every month 
from the HR dept to check the differences like new joinees or Resigned 
employees with their salary structure.what i want is to know how to find out 
the differences / changes between the twoI want the changes in every column 
in new worksheets.

I tried using the pivot table.is my approach the easiest or accurate one.i 
would also like to know whether the same can be done using formulas or VBA.

Pls Help.

Thanks & Regards.

-- 
FORUM RULES (986+ 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 (986+ 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

$$Excel-Macros$$ Find differences in two worksheets.

[Mr excel]

hi group,

  I had a routine question regarding the comparision of worksheets.I had
searched the internet regarding the differences between two worksheets
which have similiar columns & headings.I want to find out the
changes/differences between the two worksheets.

In depth, I had a master worksheet with columns of EmpNo,Emp
Name,BASIC,HRA,DA & other allowances.I also get worksheet with the similiar
headings every month from the HR dept to check the differences like new
joinees or Resigned employees with their salary structure.what i want is to
know how to find out the differences / changes between the twoI want
the changes in every column in new worksheets.

I tried using the pivot table.is my approach the easiest or accurate one.i
would also like to know whether the same can be done using formulas or VBA.

Pls Help.

Thanks & Regards.

-- 
FORUM RULES (986+ 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