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