Excel Questions: Populating a "master list" from weekly imported data

Copper Contributor



I am hoping that someone much smarter than I can help me with this problem.  


Each week I have a new data set emailed to me that contains information about leave of absences.  I import this data into excel and then alter it to get the information I need.  Much of this task requires duplicating the work I did last week and I feel that this is stupid!  How do I take the data set and make a "master list" which will update with only the new data that I import each week. 

1 Reply


A possible solution could be Power Query. In the attached file you can add data to the blue dynamic table or you can replace the existing data with the data of each new week. Then you can select any cell of the green table and right-click with the mouse and select refresh to update the green result table.

employee leave.JPG