Forum Discussion
Excel Questions: Populating a "master list" from weekly imported data
Hello! 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...
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.