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

    Save 2 sheets to new DOCX file

    Hello, I have a workbook with many sheets. I need to save only 2 sheets (named 'Summary' and 'Report') to a new .DOCX file I will appreciate your help. Thanks!
  2. rolo

    Show DAX both in rows and columns

    I have this report built with regular Excel fórmulas: I need to replicate this report with Pivot Table. I was able to do it, but I have this problem: I have DAX measures for Margin (gross, net and %) which you can see in rows. I was able to show them on pivot table rows without problem...
  3. rolo

    DAX vs QUERY...which is faster?

    Thank you for your answers!
  4. rolo

    DAX vs QUERY...which is faster?

    Hello, There are many situations where I can arrive to my goal doing 1 of these 2 things: 1. I can add some custom column in Power Query 2. I can buil some DAX in Power Pivot For example: I have a table with Sales in US dollars I have another table with USD / EUR exchange rates I need to...
  5. rolo

    Replicate this COUNTIFS with DAX

    Thanks Chihiro, it worked perfect! ;)
  6. rolo

    Replicate this COUNTIFS with DAX

    Hello, I have Excel COUNTIFS formulas, but I was not able to reproduce them using DAX functions I would appreciate your valuable help! You can download example here: easyupload.io
  7. rolo

    Simple matrix transformation

    Hello, I was able to code this macro myself! :p Function Convert(matrix As Range, destiny As Range) Dim Counter As Long: Counter = 0 Range(destiny, destiny.End(xlDown)).Clear Dim cell As Range For Each cell In matrix If cell <> Empty Then destiny.Offset(Counter, 0) = cell...
  8. rolo

    Simple matrix transformation

    I need a vba macro to do it :( Thanks
  9. rolo

    Simple matrix transformation

    Hello, I have a matrix like this (N rows x N columns) What I need is a macro to convert that matrix to 1 column x N rows matrix (without repetitions and ascending order). Like this: See attached example Thanks in advance for your valuable help!
  10. rolo

    [Paid] Show picture on floating userform

    Hello Chirayu, Thanks for your code, is much simpler! :DD Let me do some comments: 1. It only works with "jpg" images Do you know why "png" images do not work? They show a "can´t load image" error... 2. I have to add this missing line in your macro to let userform show on selection...
  11. rolo

    [Paid] Show picture on floating userform

    Although it's not exactly what I asked for, I really appreciate your example. Thanks
  12. rolo

    [Paid] Show picture on floating userform

    Hello, I need to know if you can code this macro: 1. I will have an Excel like this NAME FACE PICTURE Peter C:\Images\Peter.jpg Mery C:\Images\Mary.jpg 2. My request: when I clic on a cell inside the table, I need a userform that shows the Face Picture inside. For example: If I clic...
  13. rolo

    Open PDF

    Great, thanks!
  14. rolo

    Open PDF

    Hi Kenneth, works perfect, thanks! Just a question: Why you declare fn$ variable but on the rest of the code you only use fn without $ sign? ;)
  15. rolo

    Open PDF

    Hello, I used this code to open a PDF file: MyPDF="C:\abc.pdf" ActiveWorkbook.FollowHyperlink MyPDF It worked fine, except that it showed an annoying warning message before opening the PDF (even I had application.displayalerts=false) Today I have found this great code that opens a PDF file...
  16. rolo

    Shorter Table Sort Code

    Thanks!
  17. rolo

    Shorter Table Sort Code

    Hello, I use Excel 2016 Suppose I need to sort my table by column 1 - ascending If I record a sort action, the recorded code is too long. I need to know if this shorter sort code is safe: Range("MyTableName").Sort _ Key1:=Range("MyTableName").Cells(1), Order1:=xlAscending, Header:=xlYes...
  18. rolo

    Select Table Column dinamically

    Problem solved... But I can´t delete this post!
  19. rolo

    Select Table Column dinamically

    Hello, When table name & table column are known, I use this code to select the table column: Range("Countries") But what if I have to get my table name & my table column from cells, like: [CODE]TBName=range("A1") TBColumn=range("A2") How can I select my table column using those variables...
  20. rolo

    How Can I activate new Ribbon Icons?

    Ribbon new icons > YouTube video here
  21. rolo

    How Can I activate new Ribbon Icons?

    Hello, I have Excel 365 Pro Plus My friend has the same version as me. He can see the new ribbon icons fine, but I can´t see them. Is there any way to turn on/off the new ribbon icons? Thanks! Top Image: new ribbon icons Boton Image: old ribbon icons YouTube video here
  22. rolo

    Can´t close a displayed email

    Hi Chihiro, I have tried your solution, but it closes Outlook application. I just need to close displayed email, not outlook... Is it possible? Thanks!
  23. rolo

    Can´t close a displayed email

    THE PROBLEM I just need to do .display, .save and .close email (not send) .display is important to let gmail recipients show embeded images But it seems it is not possible to close an email if it has a previous .display code How can I do a .display > .save > .close??? .Display 'This is...
  24. rolo

    Count shapes in range

    Thanks Luke!
Back
Top