Hi @Excel Wizard ,
Thank you for the quick and sharp function to solve my issue. However, when am extending the data range from 9 to the dataset i have the results appear as 0, would you know why?
Regards,
A!
Hi team,
I have been trying to solve the below but for some reason, I cannot find a way...any help would be of great help. Attached is a sample workbook for reference. The workbook has the following, the first table has products with a combination of products, these are combinations that are...
Hi,
I have used PowerQuery to unpivot columns and grouped the row; loaded it as a data model to insert as a pivot in a new worksheet.
Just click on Data tab "Refresh all" to extract information.
P.S. Power Query feature is built in office 2016 dont have to download it but you can download...
Sub Mail_Single_SendRequest()
'Working in 2000-2010
Dim wb1 As Workbook
Dim wb2 As Workbook
Dim TempFilePath As String
Dim TempFileName As String
Dim FileExtStr As String
Dim OutApp As Object
Dim OutMail As Object
Dim r As Integer, x As Double
For r = 2 To 2...
Hi Pavan,
Just have it enabled from File > options > add-ins > com Addins > Check on PowerPivot that should have it enabled for you.
Kind regards,
Anand
Hi Jas,
I would use something like this. Update email address and details accordingly
Sub Mail_Single_SendRequest()
'Working in 2000-2010
Dim wb1 As Workbook
Dim wb2 As Workbook
Dim TempFilePath As String
Dim TempFileName As String
Dim FileExtStr As String
Dim OutApp...
Once the data model is established and relationships are created amongst data model, you can use the function RELATED in Power Pivot which pretty much works like Index and Match / Vlookup. You can also lookupvalue to lookup information.
Kind regards,
A!
Hi Pavan,
Attached sheet does list out information as required. Please note, in order to create relationship amongst data set you always have to data which are many to one kind of relationship. When I saw many I mean the data set which are transactional and one which is unique then you can...
Hi Vsk,
From the explanation above, I don't think you need a macro to do this trick for you. All you need is power query to append all the source values (considering all the headers of the source are same like in the example). once done create a pivot to list values or you can go one step ahead...
Hi Ratish,
You can have it refreshed with a schedule refresh using Power BI. However, you might need a user license for the same.
However, you can write a small macro to refresh query for you at a specific time and include a task in the windows task scheduler so that the file can open, refresh...
Hi David and Bosco,
I found a easier solution with PowerQuery by creating a duplicate copy of certain fields and later unpivoting other columns to arrive at a solution. Thank you once again for looking up for me on the same.
Kind regards,
A!
Hi Ratish,
If you're using Office 2013 then download the add-in Powerquery from url as mentioned below:
https://www.microsoft.com/en-gb/download/details.aspx?id=39379
Choose version 32/64bit depending on your office suite. if you do not have administration access to install the add-in ask...