Entering Formulas for a Master Sheet

Closed
SWEdwards Posts 1 Registration date Tuesday November 15, 2016 Status Member Last seen November 15, 2016 - Nov 15, 2016 at 07:28 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Nov 21, 2016 at 11:33 PM
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?

Thank you,
Susan Edwards
Related:

3 responses

yg_be Posts 22719 Registration date Sunday June 8, 2008 Status Contributor Last seen April 23, 2024 5
Nov 17, 2016 at 02:26 PM
Do you really want to use Excel to do that? Could you not use Access?
0
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.
0
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Nov 21, 2016 at 11:33 PM
Hello Susan,

I'm sure that we could make it work for you in Excel but it would be a good idea to upload a sample of your work book showing the set out and how you would like it all to work.

Upload a sample to a free file sharing site such as DropBox, ge.tt or SpeedyShare and then post the link to your file back here. Please use dummy data.

We should then be able to help you out.

Cheerio,
vcoolio.
0