# Search results

1. ### 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. ### Show DAX both in rows and columns

Thanks Chihiro!
3. ### 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...

5. ### 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...
6. ### Replicate this COUNTIFS with DAX

Thanks Chihiro, it worked perfect! ;)
7. ### 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
8. ### 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...
9. ### Simple matrix transformation

I need a vba macro to do it :( Thanks
10. ### 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!
11. ### [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...
12. ### [Paid] Show picture on floating userform

Although it's not exactly what I asked for, I really appreciate your example. Thanks
13. ### [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...
14. ### Open PDF

Great, thanks!
15. ### 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? ;)
16. ### 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...

Thanks!
18. ### 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...
19. ### Select Table Column dinamically

Problem solved... But I can´t delete this post!
20. ### 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...
21. ### How Can I activate new Ribbon Icons?

Ribbon new icons > YouTube video here
22. ### 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
23. ### 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!
24. ### 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...

Thanks Luke!