Very new here everyone and usually can find an answer to my questions via google but I'm having trouble with this one. I am attaching a spreadsheet that I need assistance with. What I need seems basic enough but is probably complicated :P

Copy of boards.xlsx

You are all looking at a breakdown of all of the units on our rental program that we currently use to assign housekeepers. The final sheet "Boards" is what we print out and give to housekeepers so they know what units they are required to clean for the day. What I would like to be able to do is when I assign HSKP 1 to a "JASMINE" unit, to have the unit number that is in that same row to pop up on the HSKP 1 board.

For example, if I put "HSKP 1" in the E Column on the "Jasmine" sheet it will copy the B column that is in that same row onto the "HSKP 1" board.

So on the board it will search that whole range from E2 down to E300 or whatever and put all the numbers it finds that has HSKP 1 in those rows. I really wish I could explain this better.

If I assign HSKP 1 to the 211 row, 215 row, 511 row, 611, row it will then put 211, 215, 511, and 611 on that board.

I will answer anyone's question if they need further explanation.