I have a document that I am slowly populating with data that is proving to be a bit of a chore when locating information previously entered that needs to be updated and I was wondering if there is a formula or function that may help me?
Question:
When I enter the “Inspection I.D.” into cell A2 (highlighted), is it possible for the matching row/rows to be automatically raised up to the top of the page to be quickly located and updated with the correct information?
There are actually 4 matching rows to the example provided here on rows 322-325.
Info:
The “Data” tab you see here has less than 10% of the information that will eventually be entered into it. I am quickly seeing that scrolling down to locate a row or rows that need to be updated is becoming a bit of a time suck.
Updates often include any/all of these rows (plus some that I have removed).
Help!!!
Joe
Bookmarks