Forum Discussion

aexcel23's avatar
aexcel23
Copper Contributor
Jan 05, 2024

Create a template that updates when a unique list is changed/updated in excel

Hi,   I am creating a custom report that references multiple data sheets in excel. I am trying to work on a project, and found out that the best way to get what I want is to extract the necessary d...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 08, 2024

Hi aexcel23 

 

With Get & Transform aka Power Query. In attached workbook 3 tables:

- TableCampus

- TableDegree

- TableTerm

 

#1 Update the above tables as needed (add, remove... items)

#2 Switch to sheet 'ExpectedTable'

#3 Right-click somewhere in the 'QueryResult' table > Refresh

Resources