I want to track who has borrowed materials from a library. I have each resource on a separate sheet with information about the date borrowed, contact information for the borrower, and date returned. I would like to have the master sheet show the most recent entries for each resource sheet.
What formula would you use, and what is the process for entering the formula?
I have very little experience, and have used Excel at a very basic level. I have not used Access. Ben Liebman was able to show me a better approach with Excel which will work well for our purposes. Thank you.