Hi, I am new here and, as a bonus, I'm also a relative novice--I hope you'll forgive me if I've missed this answer in previous posts. I did search through them, but I'm couldn't find exactly what I'm looking for (or else I didn't understand the terminology).
I have a basic equipment maintenance file with a worksheet for each piece of equipment. The summary worksheet allows for a quick view of the most recent maintenance action on all equipment. The equipment worksheets are ordered by date with the most recent at the top. When new maintenance is done, the user inserts a new line above the most recent and fills in the information (this is the extent of this user's skills, so I have to work around that).
How can I get the summary page to pull the most recent information? Everything I've tried follows the actual data when that new line is inserted instead of sticking to the specific cell.
I need to pull two pieces of information (date and maintenance performed) from each worksheet.
As I type this, I realize I may be going after the question wrong--instead of being glued to a particular cell, I need to attach to a 'most recent date' comparison? Either way, I'll need help. :-)
Thank you effusively for any clues or solutions! Please let me know if I need to provide more information.
Bookmarks