Entering Formulas for a Master Sheet

[Closed]
Report
Posts
1
Registration date
Tuesday November 15, 2016
Status
Member
Last seen
November 15, 2016
-
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
-
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

3 replies

Posts
17188
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 27, 2021
5
Do you really want to use Excel to do that? Could you not use Access?
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.
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
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.