I suppose I should begin by warning you that I'm not good with visual basics through excel. Alright, now that's out of the way, here's the problem. I have two excel sheets, a masterlist sheet and a search sheet. I made a search macro in the search sheet and it works just fine. My question is if there is a way to update the search results and save it in the masterlist sheet. For example, if I was looking for John Doe, I want to be able to change any detail when the results come up. Is this possible with excel? Could you show me how to start.
