Entering Formulas for a Master SheetClosed

Question

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

yg_be · Answer

Do you really want to use Excel to do that?  Could you not use Access?

Susan · Answer

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.

vcoolio · Answer

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.

Entering Formulas for a Master Sheet

3 responses

Similar discussions

Subscribe To Our Newsletter!