I am using this, do you mind modify the speeling of avialable to correct available !!!
On Thursday, 13 September 2012 21:28:34 UTC+3, 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. > > > > > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
