Entering Formulas for a Master Sheet [Closed]

Report
Posts
1
Registration date
Tuesday November 15, 2016
Status
Member
Last seen
November 15, 2016
-
Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 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
13943
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
January 18, 2021
4
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
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
214
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!