Updating search results

Amin - Jul 21, 2009 at 09:24 AM
 Trowa - Jul 23, 2009 at 07:10 AM

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.



1 response

Hi Amin,

You can press Ctrl+F on the masterlist sheet and type in John Doe and hit enter, now you can change anything you like.

Best regards,