Thread: Search & Edit Macro / Function

Hi all,

I'm attempting to create a spreadsheet that has an interactive / database feel to it. What I mean, is that I'd like to be able to quickly search a worksheet full of Facilities related data (room number, occupant names, square footage, etc.) and have the results displayed. So if I searched a particular "Department", my search results would show all room numbers with that Department. Then, I'd like to either jump to that section of the data, or be able to edit the data within the search results. I know the CTRL+F will essentially do this - but I'd like to provide a more user-friendly way of doing this from one designated cell on a summary tab or something like that.

My client is a facilities director and he is trying to find a better/more efficient way to track and maintain changes to hundreds of rooms, what department uses them, etc.

Any quick Macro's known to the experts that could be of assistance?

Thanks!!!!
Mike

I've attached an example file. Just to reiterate - I'd like to designate one cell to serve as a search. I'd like for the result to either jump me to the row where the data exists - or pull the data to an area near the search cell box. The most important functionality here is being able to Edit the data being searched. Therefore, maybe it makes the most sense to structure this so upon the search it jumps to the row where the data meets the search criteria.

Hopefully I'm not confusing the audience here...

Thank you. This is essentially what I was after! I may try and place that search cell on a different worksheet. Is that possible?