• 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. D

    A Module is not a valid type error

    yes, there was......changed the name now and code ran....Thank you so much:)
  2. D

    A Module is not a valid type error

    Hi All, I am getting "A Module is not a valid type" error while trying to run below code. This code works fine when it is in the same file where data is saved. But giving error when being run from Personal.xlsb workbook. Unable to understand it is happening. Function FilePath() As String Dim...
  3. D

    VBA help on saving selected range as picture

    Thank you so much Chihiro/Marc :) If I have any query, will get back.
  4. D

    VBA help on saving selected range as picture

    Dear All, I need help on saving a specific range as a picture. I found a code at https://stackoverflow.com/questions/38367064/operating-ms-paint-using-excel-vba but a line of code not working and no solution related to this found. Sub Saving_Pic_of_a_Range() Dim path As String Dim...
  5. D

    Need Dashboard creation help

    Hi Jawahar, Thank you for sharing this. I want's something like this. I'll try to create something like this. But can you also try something for me. May be I'll get a best one :) The link Chihiro shared was very helpful too. Thanks all, DJ
  6. D

    Need Dashboard creation help

    Hi Thangavel, Need insights specially basis Teams, Function, Location and software type etc. Thanks, DJ
  7. D

    Need Dashboard creation help

    Thanks for replying Pavan but I have already worked on pivots but requirement is to do some interactive visualization using developer tools and the problem is that I am not in a condition to say No :(
  8. D

    Need Dashboard creation help

    Hi, I need an urgent help to create an interactive dashboard which can give multiple insights using the data file I have uploaded. Management needs insights specially basis Teams, Function, Location and software type. With there new queries all the time, I am able to think of only pivots but...
  9. D

    Need to unregister inactive users after 60 days

    Hi, We have issued few licenses to users and they need to utilize them within 60 days. If any user doesn't use it within specified time period, need to unregister that perticular user. I want to apply a conditional formatting or any other kind of indicator which should inform me if time...
  10. D

    Need help with Thermo-meter chart

    Hi, It seems interesting solution but unfortunately, I didn't get success:( Please upload a sample file demonstrating the solution, it will help me a lot. Thank you, DJ
  11. D

    Need help with Thermo-meter chart

    Hi Hui, Sorry for late reply, I didn't have the access to internet. Yes, this can be a solution but not like that what I wanted. If there is any other suggestion/solution, please share. Thank you very much for your support. DJ
  12. D

    Need help with Thermo-meter chart

    Hi Friends, I have created a chart similar to the thermometer chart in the same way as published on chandoo.org (http://chandoo.org/wp/2012/06/11/thermo-meter-chart-with-last-year-marker/) and it is working fine. Only difference is that there is no Last year marker so there are only two...
  13. D

    Adding formula in Pivot table

    In this case, please check your data. Surely there are non-numeric values exist in "Netinv.sls" or "Netinv.qty" columns.
  14. D

    Data validation problem

    Hi Bobhc, Thank you for your response. My problem was not related to Dependent Data validation. Instead in my sheet user can enter any value and choose any value from the dropdown list. The problem was that once user has entered values in column-A and Column-B then he/she can't skip column-c...
  15. D

    Data validation problem

    Hi All, I have a problem with data validation and unable to find its solution. I have an excel sheet which I am unable to upload for your reference but Lets say column-A has names, Column-B has mobile numbers and column-C has a drop down list from where person need to choose city name...
  16. D

    HLookUp

    Hi Prazad82, This solution worked. Thank you for speedy resolution. Sgmpatnaik: Thank you for your reponse but this is what I had used in my report. Thanks again, DJ
  17. D

    HLookUp

    Hi Prazad82, Thank you for the speedy response but I was aware with this solution. I want to use Hlookup because of my report structure as I don't want to add helper rows. Also, wanted to know why HLoopUp is not working with Choose function whereas it is working with Vlookup. Please note...
  18. D

    HLookUp

    Hi All, Range A1:E1 has values 100,200,300,400,500 and Range A2:E2 has values Agent1,Agent2,Agent3,Agent4,Agent5. Now somewhere in the sheet I apply the formula =HLOOKUP("Agent4",CHOOSE({2,1},A1:E1,A2:E2),2,0) but it is giving me #N/A error. I don't know why it is not giving me the right...
  19. D

    Dynamic Chart Range

    Hi Narayan, Thank you so much for your continuous help. However, I tried again with the Named Range method and successfully implemented it in my report with few changes. I will check the latest file you have uploaded for me later. Thank you so much once again. DJ
  20. D

    Dynamic Chart Range

    Hi Narayan/Hui, codes suggested are not working. :( Narayan: I am unable to understand you VBA code and hence unable to modify it according to my need. Sorry I am not a VBA expert just a beginner only. I tried to use Hui's code as it is simple for me to understand but still unable to...
  21. D

    Dynamic Chart Range

    Hi Narayan, That's a great solution given. I never thought Named Range can be a solution for this. Thank you very very much. However, I would be grateful if you can help with VBA code too that I gave in my file. This is coz I really want to understand to change Chart range using VBA may be...
  22. D

    If you only had 10 Excel Functions what would they be?

    my top 10 functions would be Index match Vlookup sumproduct countif iferror If concatenate clean trim
  23. D

    Dynamic Chart Range

    Hi Hui, Sorry, I think link would be http://rapidshare.com/files/2536936423/GraphRangeProblem.xlsm DJ
  24. D

    Dynamic Chart Range

    Hi Hui, I have uploaded a file at https://www.rapidshare.com/#myrs_filemanager/file/4973 I was unable to upload actual file from office laptop yesterday so I have created a sample one and uploaded. There is a macro that I have created and assigned it to the combo box so as soon a user select...
  25. D

    Dynamic Chart Range

    Hi All, I have more than 2 charts in my workbook and there is a chart for which I need to change source data range dynamically. I have done all the calculations using VBA code but the only problem is that I am unable to set this calculated range value to the chart property. Reason for above...
Back
Top