rav_rav
asked on
Summarize Content within a Table
Hi Experts,
I have a table with the following characteristics:
The column headers represent names of group leads within the company.
The row headers represent different software applications.
A given cell in the table essentially notes the # of licenses they have for a given software application.
How can I create a macro that will create a summarized list as follows:
John Doe's team has the following licenses:
- MS Word: 2
- MS Visio: 4
John Doe's team has the following licenses:
- MS Access: 3
- MS One Note:7
In the above example, the intention is to not list any software application for which the a given team does not have any licenses for.
As a bonus, if it's possible to do this via a formula instead, that would be amazing.
I have a table with the following characteristics:
The column headers represent names of group leads within the company.
The row headers represent different software applications.
A given cell in the table essentially notes the # of licenses they have for a given software application.
How can I create a macro that will create a summarized list as follows:
John Doe's team has the following licenses:
- MS Word: 2
- MS Visio: 4
John Doe's team has the following licenses:
- MS Access: 3
- MS One Note:7
In the above example, the intention is to not list any software application for which the a given team does not have any licenses for.
As a bonus, if it's possible to do this via a formula instead, that would be amazing.
ASKER
Thanks gowflow.
Attached is a workbook with the Sample Table and the Sample Output that I'd like the macro or formula to generate.
Sample-Table---Output---Copy.xlsx
Attached is a workbook with the Sample Table and the Sample Output that I'd like the macro or formula to generate.
Sample-Table---Output---Copy.xlsx
ok noted I had already done it but you want the output to be all software in 1 cell ? or can it be each software on 1 row ?
Take a look at this I can modify it.
Make sure to activate macros and press on the button.
gowlfow
TeamLicenses.xlsm
Take a look at this I can modify it.
Make sure to activate macros and press on the button.
gowlfow
TeamLicenses.xlsm
ASKER
Thanks gowflow.
Looks good. However, did you intentionally just exclude "Excel" software (or second row) in the summary macro you created?
To answer your question, a separate cell for each software does not work in my case. Preference is to have the name in one cell with the summary of the software (all licenses) in the cell below.
Looks good. However, did you intentionally just exclude "Excel" software (or second row) in the summary macro you created?
To answer your question, a separate cell for each software does not work in my case. Preference is to have the name in one cell with the summary of the software (all licenses) in the cell below.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks gowflow; sample workbook was great
gowflow