Recent content by rolo

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!

Thanks Chihiro!

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

Thank you for your answers!

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

Thanks Chihiro, it worked perfect! ;)

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

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

I need a vba macro to do it :( Thanks

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!

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

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

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

Great, thanks!

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? ;)