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