Re: $$Excel-Macros$$ Find differences between four columns.

2012-05-09 Thread Mr excel
Verma bhayya,, The code is working fine but only one sided.i mean if there are no Receipts in List 2 which are in List 1 then the code finds the difference only between these two.how to change the code so that it shows all the missing receipts with amounts either way...Receipts with amounts not

RE: $$Excel-Macros$$ Find differences between four columns.

2012-05-09 Thread Rajan_Verma
Of Mr excel Sent: 09 May 2012 5:24 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Find differences between four columns. Verma bhayya,, The code is working fine but only one sided.i mean if there are no Receipts in List 2 which are in List 1 then the code finds the difference

RE: $$Excel-Macros$$ Find differences between four columns.

2012-05-03 Thread Rajan_Verma
@googlegroups.com Subject: Re: $$Excel-Macros$$ Find differences between four columns. Sorry Verma,,i had messed up everything here.Got confused with the requirement. What i want actually is to find out the differences between the FIRST table with Receipt No Amt and SECOND table with Receipt No Amt

$$Excel-Macros$$ Find differences between four columns.

2012-05-02 Thread Mr excel
hi all, i m in need of help regarding finding the differences between four columns i.e. RECEIPT No AMT. in sheet1 and RECEIPT No AMT in sheet2.i would like to know the Formula which will highlight the differences between the two columns in both sheets. Receipt No Total Paid Receipt No Total

RE: $$Excel-Macros$$ Find differences between four columns.

2012-05-02 Thread Rajan_Verma
@googlegroups.com] On Behalf Of Mr excel Sent: 03 May 2012 00:09 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Find differences between four columns. hi all, i m in need of help regarding finding the differences between four columns i.e. RECEIPT No AMT. in sheet1 and RECEIPT No AMT in sheet2

RE: $$Excel-Macros$$ Find differences between four columns.

2012-05-02 Thread Rajan_Verma
2012 00:09 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Find differences between four columns. hi all, i m in need of help regarding finding the differences between four columns i.e. RECEIPT No AMT. in sheet1 and RECEIPT No AMT in sheet2.i would like to know the Formula which

Re: $$Excel-Macros$$ Find differences between four columns.

2012-05-02 Thread Mr excel
thanks for the speedy reply sir..how about using VBA for finding the differences between the columns and pasting them(only the DIFFERENT ones-Receipt no amount which are not matched to a new sheet one down the other... On Thu, May 3, 2012 at 12:08 AM, Mr excel excelkeec...@gmail.com wrote: hi

Re: $$Excel-Macros$$ Find differences between four columns.

2012-05-02 Thread Mr excel
A small correction for my requirement please i need to highlight those receipt nos which had different amounts..Verma bhayya...formula ko change karona please taaki,Receipt nos with different amounts highlight hue to color kardena thanks a lot for the help On Thu, May 3, 2012 at

RE: $$Excel-Macros$$ Find differences between four columns.

2012-05-02 Thread Rajan_Verma
: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mr excel Sent: 03 May 2012 00:27 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Find differences between four columns. A small correction for my requirement please i need to highlight those

Re: $$Excel-Macros$$ Find differences between four columns.

2012-05-02 Thread Mr excel
* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mr excel *Sent:* 03 May 2012 00:27 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Find differences between four columns

Re: $$Excel-Macros$$ Find differences between four columns.

2012-05-02 Thread Mr excel
Sorry Verma,,i had messed up everything here.Got confused with the requirement. What i want actually is to find out the differences between the FIRST table with Receipt No Amt and SECOND table with Receipt No Amt. Example: The receipt no 1151881 in Master data is 4500 It should match the