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. At the moment it works if there is only one of that room number, but I'm wanting it to show every issue with that corresponding room number and not just the first one it finds. Please Help, Thanks.

 

[AliGW]

Just add a filter to your main sheet on the room number column - no real need to have a separate sheet for each room when the layout is identical.

 

[Joseph Van den Avont]

I know but I still would prefer to have seprate sheets if possible

 

[bosco_yip]

Try......

1] Select Sheet 1, A2 formula copy across and down :

=IFERROR(INDEX(Main!B$1:B$100,AGGREGATE(15,6,ROW($A$1:$A$100)/(Main!$A$1:$A$100=0+MID(CELL("filename",A$1),FIND("]",CELL("filename",A$1))+1,32)),ROWS($1:1))),"")

2] Select Sheet 1 A1:C6, copy and paste to Sheet 2, 3 and 4

3] See attached file

Regards
Bosco

 

[Belleke]

I know but I still would prefer to have seprate sheets if possible

Why?????????????????????????
You want your file,sheet to slow down so you can have a cup of coffee while waiting.
Try this.

 

[Joseph Van den Avont]

THANKS