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

    Project duration chart with timeline

    Hello, Could you please give me support to create a bar chart regarding project milestones visualisation? My problems are: 1. the start and end dates of project milestones are stored as weekweek.yearyearyearyear 2. the duration of project milestone with start and end week have to be presented...
  2. V

    increment value in same colmun using loop

    another Sub sample() Worksheets("Sheet1").Range("A3:A10").Formula = "=A2*1.06" End Sub
  3. V

    find first non-blank text cell based on multiple criteria (w/o array)

    Hi GraH - Guido, I checked your formula but doesn't work on my side.
  4. V

    find first non-blank text cell based on multiple criteria (w/o array)

    Hello, I would need your support to find the first non-blank text cell based on multiple criteria but without array formula. The original file has more 10.000 rows and the calculation time of my array formula takes long time. Please, see the details and expected result in the sample file. Do...
  5. V

    Font size modification (excel range to powerpoint)

    Yes, I can change it manually from PowerPoint (but I would like to avoid the manual steps if possible).
  6. V

    Font size modification (excel range to powerpoint)

    Anyhow, thank you for your time and effort! Does anybody have any idea?
  7. V

    Font size modification (excel range to powerpoint)

    No change. The font size of the Table on ppt slide is the same than before.
  8. V

    Font size modification (excel range to powerpoint)

    I tried in various way but I cannot change the font size of myShapeRange object. Please, see the attached file.
  9. V

    Font size modification (excel range to powerpoint)

    I have Run-time error 438 at this line. Object doesn't support this property or method.
  10. V

    Font size modification (excel range to powerpoint)

    Hello, I would like to ask some advice regarding font size modification (in Excel 2013 or above), because I do not find the correct way and I am lost. The below mentioned code copy the Excel range then paste it in powerpoint but unfortunately I cannot change the font size (6 to 8) of...
  11. V

    Bar chart problem

    Ok, I try to figure out.
  12. V

    Bar chart problem

    Hello @Hui, I would like to continue this thread and ask your advice again. How would be possibe to create the same chart if the dates of Project Issues are not in ascending order? Please, see the attached file.
  13. V

    Bar chart problem

    Now I see, thank you the help!
  14. V

    Bar chart problem

    No, I manually added the shapes what I would like to see on the chart. Please, see that.
  15. V

    Bar chart problem

    Hello Hui, Thank you, your sample file is very close to my target. One thing is missing: I would like to see the "Start" and "Closing" date of each project on the chart in order to understand easier the duration (a simple black line around the bar would be enough).
  16. V

    Bar chart problem

    Hello, I would need your support regarding bar chart creation. The details and expected results are in the attached file. Thank you in advance any feedback!
  17. V

    VBA to insert formula in column

    Hi, This code in the ThisWorkbook put the required formulas on sheet LAB (column N, AC, AR and BG) when you open the file and enable the content. Not update more columns. Option Explicit Private Sub Workbook_Open() Worksheets("LAB").Range("N3:N102").FormulaR1C1 = _...
  18. V

    Fuzzy Name Match Lookup

    Hi, This will help you. https://www.mrexcel.com/forum/excel-questions/195635-fuzzy-matching-new-version-plus-explanation.html
  19. V

    VBA to insert formula in column

    Hi, Check out it this.
  20. V

    FILTER the data

    Hi Techtrend, Do you need something like this?
  21. V

    Pop Up Reminder, based off of Dates

    Hi, Check out this approach. Option Explicit Private Sub Workbook_Open() Dim LastRow As Long Dim a As Long Dim Message As String Dim Today As Integer With Worksheets("Sheet1") LastRow = .Range("B" & .Rows.Count).End(xlUp).Row For a = 2 To LastRow If...
  22. V

    Count form merged cells

    Hi, Is this help?
  23. V

    How to grab underlined text in a cell

    Hi, Check out this sample file.
  24. V

    Consolidating several worksheets into one pivot table

    And what about the Data Model technique? If the data on sheet Oct16, Nov16, Dec16 are in Tables then you can integrate these tables into 1 pivot table. Or VBA.
Top