• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. sgmpatnaik

    Somendra Misra +3000 posts

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

    Bro i have some doubt, is there any code to lock the Keyboard and Mouse moments for some time...

    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...
  3. sgmpatnaik

    Dynamic range of rows for SUM function

    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/
  4. sgmpatnaik

    Dynamic range of rows for SUM function

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

    How to get result with if and sumif function

    @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
  6. sgmpatnaik

    possible to keep row hidden when filter cleared/used?

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

    Formula not update

    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...
  8. sgmpatnaik

    Many many returns of the day Luke Sir !

    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.
  9. sgmpatnaik

    Need help in putting a formula

    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
  10. sgmpatnaik

    Userform, submit to generate number in column B

    @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...
  11. sgmpatnaik

    Need help in putting a formula

    @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
  12. sgmpatnaik

    Need help in putting a formula

    @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...
  13. sgmpatnaik

    Userform, submit to generate number in column B

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

    Userform, submit to generate number in column B

    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
  15. sgmpatnaik

    Userform, submit to generate number in column B

    @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...
  16. sgmpatnaik

    SUMIFS based on a list

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

    MIS Report

    @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
  18. sgmpatnaik

    INDEX/MATCH for approximate date

    @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
  19. sgmpatnaik

    populating my data onto calendar

    Glad it helps you
  20. sgmpatnaik

    populating my data onto calendar

    @Somendra Misra It will look good or not if we mention the Day also in the Calendar with little bit add in your formula =IF(B15="","",INDEX("Day " & B15 &" - " &$C$5:$I$9,ROWS(J$15:J15),MATCH(J$14,$C$4:$I$4,0))) Thanks
  21. sgmpatnaik

    Copy paste data with certain criteria

    @garyaps Welcome to Chandoo.org group, glad you are here please upload a sample file with you desire requirement. There is lot of tricks to use the copy and paste method with VBA and Formula also. Thanks
  22. sgmpatnaik

    Printing entire workbook

    @DashboardNovice Place This Code in the Command Button and press Private Sub CommandButton1_Click() Sheet1.PrintPreview True For i = 1 To Worksheets.Count strRes = MsgBox("Do you want to print " & Worksheets.Item(i).Name, vbOKCancel, "Print Preview") If strRes = 1 Then...
  23. sgmpatnaik

    Multiple meetings and actions tracker

    @Richard Welcome to Chandoo.org, glad you are here Some of your requirement is done by formula and some to be use with VBA for export the PDF. It is better to upload a sample file with your desire required to understand before you start a point please check this link...
  24. sgmpatnaik

    Where to find our old Threads and Book Marks from the Old Forum

    Hi SirJB7 After Long time we can C you, Glad you are back. and finally i got the thread which i start this thread http://chandoo.org/forum/threads/run-excel-file-only-on-designated-computer.9508/ actually in our profile page we can't get all the threads which we started or replied
  25. sgmpatnaik

    Help with a Data Entry form

    @DMA Try The Below Code Sub UpdateLogWorksheet() 'http://www.contextures.com/xlForm02.html 'code by Dave Peterson and modified by cdbauer1 'Make sure that your column headers on the PartsData tab go in the order of the Data Validation list and that they are identically named Dim historyWks...
Back
Top