I have seen the data entry example of where you enter data into range, and click a submit button and the data is sent to the end of the proper sheet.

My question, is can a recall be done. If I enter the data to be searched, can that related row be shown and edited, all still from the first sheet. I know it sounds more like an Access thing, but Id really like to get this poppin through Excel....