Search results

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

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!

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

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

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

Ribbon new icons > YouTube video here

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

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!

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!