User Profile
SannekeVisser
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Get latest status on an overview sheet
Hey guys! I hope someone can help me out. I'm creating a table where I want excel to retrieve the latest information from another table. I have an overview worksheet where I want excel to show the latest updates out of the entry worksheet. This is the entry worksheet: This is the overview worksheet: So I'm now trying to create a formula for the C, D and E row. They have to retrieve the latest entry about a certain room of the table on the Entry tab. So it has to filter for room and for the latest entry date and then copy the information. I'm pretty stuck here. Can someone help out how I can reach that sort of automation? I'm looking forward to any help 🙂
