Search results

Ok, i have attached the sample file and i have set one row as updated in the Reconcile Sheet

Aha Thank You, at present the sum / Calculations are correct, Thank You, Can You do a favor for me, actually i am thinking to add the extra option and one another code that is at present we are doing the reconciliation with Tax Part Only now i would like to add one more extra line that is if...

@ Gateway2026 can you please help me to find out the mistake where i am doing, that is when i run the code with your given function then i am facing problem to sum the value of partial invoices which are located in the sheet of Purchase Register . my Reconciliation code is compare the Data...

Ah Great Work the both suggestions, Thank You Friends for your support, i did my job with your support, if any help need then i will knock the door again Thank You

Here i am running a code for Data Reconciliation with sheets that's why i want a function code for GetInvoice Number hope you understand Thank You

Hi, sorry for my delay replay. i completely gone through your sample file and i checked there you have taken a helper column E there we have to mention the ignore methods to get the invoice number, after that if we run the code which you given the button do it then it extract the invoice...

Hi, Good Morning Every One actually i am a tax Consultant and i have to cross check the books of records with GST , I have prepared one excel file to Reconcile the data from GST to Clients Data here i am facing an problem, that is i would like to extract the numbers of GST invoice to numbers...

Hi Some Congrats on your 3k posts you are doing a rocket type job, please keep it up

Bro i have some doubt, is there any code to lock the Keyboard and Mouse moments for some time. Say i left my system for some time then no body can use my Entire system and when i will back to work then i can unlock the code and ready to work. I can't install any software in my system Thanks...

May be, now it's ok Another Method, Check the below link @Pratap Another Method, Check the below link http://wheatblog.com/2011/11/applying-excel-subtotals-with-vba/

@Mike I Think the file is not uploaded correctly, when try to download then getting a error msg please check

@balkrishna Which links you have submitted they are requesting to take permission from you The forum members or Ninja's never take any permission to Help if you want to solve your problem please upload the correct file from Drop Box and speedshare etc and Thanks

@Ben Why not you use the Worksheet_Change event when you change any thing then the row to be hide

HI I have Small Problem that is i am using the below formula ="Purchase register from "&TEXT(Q1, " dd-mm-yyyy ")&"to"&TEXT(Q2, " dd-mm-yyyy ") when i change the cell value in Q1 or Q2 then the formula is not update when i minimize or change from Tab1 to Tab2 then the formula is changed why...

You are my friend. You are always there for me, supporting me, encouraging me , listening to me and all those other things that friends do. Happy Birthday Friend.

Check This link may be it give some idea http://www.excel-university.com/vlookup-on-two-or-more-criteria-columns/ http://blogs.office.com/2012/04/26/using-multiple-criteria-in-excel-lookup-formulas/ if not then please elaborate some more to us Thanks

@Ben Sorry i didn't check the UserForm Totally just i add a extra line in there that's all and what type of error you are getting in the form and where you will get a Circular Reference Warning, i didn't get any circular reference warning in my pc I think there is a formula in B1 Kindly remove...

@Some I didn't remove 0 in my formula please check this =IFERROR(INDEX($E$2:$E$22,MATCH(G3&H3&I3&J3,$A$2:$A$22&$B$2:$B$22&$C$2:$C$22&$D$2:$D$22,0)),"") Thanks

@Sudhama Welcome to chandoo.org please check this if it is help full =IFERROR(VLOOKUP($G$3&$H$3&$I$3&$J$3,$A$1:$E$22,5,TRUE),"") Or Array Formula using with Ctrl+Shift+Enter =IFERROR(INDEX($E$2:$E$22,MATCH(G3&H3&I3&J3,$A$2:$A$22&$B$2:$B$22&$C$2:$C$22&$D$2:$D$22,0)),"") other wise please...

@Ben Please Check This File is it ok, if not please let me know Thanks

Please check the Below Link http://stackoverflow.com/questions/22251180/excel-vba-userform-need-to-create-new-id-every-time-form-is-called-and-save-it Thanks

@Ben Millen Welcome to Chandoo.org Paste the below formula in the Column D1 or where ever =SUM(IF(FREQUENCY(B:B,B:B)>0,)) The Above formula count only unique No. not the duplicate Now Place this code in UserForm Private Sub UserForm_Initialize() TextBox1.Value = Worksheets("Daily...

@tarynmahon Change this $A$1 to $A1 copy and drag down other wise please upload a sample file Thanks

@pankaj Please mention the Exact result which will be come in there in manual figure with that it is ease to give the correct formula Thanks

@Marco.Zingariello Please change the Range type in your master book as K:K to K2:K1000 etc hope it will give some thing other wise inform us Thanks