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!

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

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

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

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

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

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

Hello, I need some simple macro to count the number of shapes in a giving range... Can you help me? Thanks!

Hello gurus! WHAT I HAVE I have a power pivot model with 3 tables: 1. Product (product key field with no duplicates) 2. Stock (product key field with no duplicates) 3. Sales (transactions table, many ocurrences of product key) Then I have my relationships: One to many relationship from...

I use pivot table to show %change, using this: SHOW VALUES AS > % DIFFERENCE FROM > Base Field Month > Base item (previous) Problem: in Jan 2012 or Jan 2013, pivot table does not calculate %difference from previous month! See attached example. Thanks for your valuable help!

Hello, Supposse I have this CSV file: ID,Name,Salary 1,Peter,12300 2,Bob,32000 3,Mary,37800 4,Mick,28900 5,Luke,15900 Then from Excel, I need some VBA code to fill "ID" in cell B1, change "Name" or "Salary" data and then save that record back to the CSV (in this example overwrite 3rd record...

Hello, I am using this great macro to merge 2 csv files into 1 csv file (credits: http://analystcave.com/merge-csv-files-or-txt-files-in-a-folder/) The problem is that the combined file has 20 rows, but row 11 stays empty! Any suggestion on how to fix it? I provide the vba code and 2 csv...

I have tried this but it does not work: Msgbox CreateObject("WScript.Shell").RegRead("HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\International\AcceptLanguage") I need to know exactly which registry key to read so I can get Internet Explorer default language. I can pay for this...

Hello, I´ve been able to trigger a workbook event from within addin using this example: http://www.cpearson.com/excel/AppEvent.aspx But now I need some help on how to trigger a Worksheet Activate event from within addin Thanks!

I need vba code to: 1. Get Internet Explorer language (if it is spanish or english) 2. Get Internet Explorer default download folder I would appreciate any help! Thanks

I had a Power Query with different queries from files and folders Power Query worked fine, until... I have deleted those files (using vba "kill") but then I have recovered them from backup to have same files and folders as before. The problem is that when I try to refresh queries again, there...

Is there any workbook open event so when the user opens the file, it does not appear the "Open as read only" message? Notice that the file is not opened by vba, the file is opened manually by the user Thanks!

I need to detect if the opened file was opened from local drive or from network. Thanks!

Hello VBA gurus! Is there any way to let a macro do these tasks? 1. Enter http://www.degreedays.net 2. Fill weather station ID input box with "LEMD" 3. Press the button "Generate Degree Days" 4. Wait 10 seconds 5. Press the button "Download now" which appears at the top If not VBA is it...

Hello, when I consolidate many sheets using append (1 sheet = 1 table) 1. In the final consolidated table: is there any way to have a new column that shows sheet name? 2. Or new column that shows some cell value? For example: consolidate 4 sheets > North, West, South, East So in final...

Hello, Suposse I have a Power Pivot sheet already loaded with some data... Then I have an Excel sheet table where I do lot of calculations... How can I add the Table data to the last row of Power Pivot sheet? Thanks!