Nice and usefull Material will check and revert you with feedback. Regards Prince
On Thursday, January 17, 2013 10:10:13 AM UTC+5:30, aju wrote: > > Please see the *Reconciliation Tool *attached herewith,Which is an * > EXCEL-ADDIN* created by me.Which very useful for Handling large excel > database. This utility has got three options > > 1] *Reconciliation* > This option help you to *Reconcile two Excel worksheets/Workbooks > based on 1 /2/ 3 Common Field(s)*.Based on the common field(s),the * > Difference/Sum/Product/Quotient* of *Numerical fields of first sheet & > second sheet can be calculated *[*The sum of Numerical fields in each > sheet based on the common fields calculated first,then the selected > operation (+,-,*,/) applied on numerical fields*] .In the sample file > named *SALES DATA* the examples are demonstrated. > > 2] *Vlookup* > This option is a *Menu driven utility for making Vlookup > between two list of data ,E*ven without knowing the syntax for Vlookup > .The advantage of this utility is that if blank spaces are there in look-up > fields program will be automatically eliminate it.if numbers are stored as > text numbers that also will taken care of during Vlookup. If Vlookup is not > successful *N/A* error message will not be displayed in cells.since > the program copies formula automatically down the cells,You need not have > copy Vlookup formula down the cells > > 3] *Compare* > This option is useful to *Compare two excel sheets cell > by cell, *in output sheet the cell address/first sheet's value/Second > sheet's value are displayed side by side & the cells with difference > are colored in original sheets for easily identifying > > A file called SALES DATA attached herewith demonstrating all the examples > *HOW TO INSTALL THE UTILITY * > * Please save the add-in RECONCILIATION.XLAM to any folder you like.**Then > double click on the icon,Then the utility is installe*d.Once installed a > new tab called ADD-IN appears at the end of the Excel ribbon as shown in > picture below.*Double click on the icon to execute the utility*. > > > > 1] *Advantages of RECONCILIATION UTILITY* > When the program is executed it shows a menu that displays all > the worksheets in all open workbooks,so you need not have bring the > worksheets two the same workbook.*The program automatically recognize the > rectangular data even if the first row doesn't contain filed headers / Or > if tables titles/heading are appearing above the data (as shown in NOV 12 > sales w.sheet in SALES DATA)*.You have the option to select the output to > a new Worksheet/Workbook > > * So please try & Give your valuable feed back* > > Aju V Chacko > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
