Good Work..& Thanks for sharing :) Cheers..
Rgds//Vabs On Thursday, September 13, 2012 11:59:10 PM UTC+5:30, aju wrote: > > Dear Friends, > Please the attached Excel add-in Reconciliation > Tool made by me.This Add-in can be used to reconcile two numerical fields > Based on a common field. The data which has to be reconciled can be belong > to *two different workbook or worksheet*. From the Combo Box choose > First worksheet name, Common field which is available on both sheets,Then > select numerical field on first sheet which has to reconciled . Similarly > choose the details for second sheet also, Choose output sheet-(If you want > a new workbook choose-“New Book” from the options of Output sheet). Now > select the Operation to be done on numerical filed *[+,-,*, /, Comparison] > *(Subtraction means the subtracting the *second* numerical field from * > first*) and so on. If you want reconcile Debit & Credit choose operation > as addition. A simple example is shown below.Please try and give ur > valuable feedback,Because this is my first venture.Any doubt please reply.A > simple example to demonstrate it's working is given below. > *First Sheet* *Second Sheet* > > *Output Sheet* > [image: Inline image 2] [image: Inline image 4] > [image: > Inline image 3] > > *How to Install* :Please save (Reconciliation Tool.Xlam) into any folder > u like. This ass-in can be installed in excel *either by Double clicking > on the icon OR by choosing (OFFICE BUTTON->Excel options->Add-Ins->Go-> > Browse) and then choosing the Add-in* .Once installed an icon will be > appearing in Add-in Menu. > > ** > > > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
