EXCEL SHEET FOR HOTEL ISSUES

[Joseph Van den Avont]

I'd like to make an excel database for my hotel where there's a main sheets that shows: Room Number, Problem, Person who reported the problem, and problem solved or not. But then I'd also like to have seperate sheets for each room that shows everything on the main sheet corresponding with that room number. I don't know how I would go about setting it up so anything I type in the main page will automatically show up on its corresponding room sheet. Please Help, Thanks.

 

[AVK]

Refer attach file. You can do with index match formula.
Also created hyperlink with main sheet & individual sheet. You can directly jump to respective sheet if you click on room number in main sheet, from individual sheet click to return to main sheet.
Hope this want you.

 

[Joseph Van den Avont]

Thanks,
could someone please explain how this works? thanks