Hi. I'm new to the forum so apologies if I've put this in the wrong place.
I have an excel document that contains around 15-20 sheets, which each store the disk space levels of individual servers. These sheets are filled in on a daily basis, and include data such as the date, time, and the disk space level. What I am looking to do is take the most recent entry from each sheet and use them on a summary sheet, which will then show the most recent entry for each of the servers. From here I have some code ready that will enable me to automatically email the necessary person to inform them if the disk space is low.
What I need to know is how do I pull the most recent entry from each sheet onto one summary sheet? I need the summary sheet to be able to automatically update and recognise the new entries as I put them in each day.
Thanks,
Andrew.
Bookmarks