auto cell populate

[Stevejd58]

I have a question re auto populating sells on different sheets.


I've attached a rough example of what I'm trying to do and I guess some form of VBA/macro will be needed

here is what I'm trying to do

• Cells B2 -13 have data validation list drop downs showing room numbers
• cells C2-13 have user names
• I'd like to auto pop the users into the relevant rooms on the room layout sheet
• e.g. link the name in C2 to the corresponding number in B2
  • paste the date from B2 in B2 on the room layout sheet

this is where the challenge begins, although the names in C2 - 13 won't move the room numbers in B2 - 13 will, so when I change the persons room number, I'd like the name to move to the new room in the room layout page.

e.g. Bert is in rm 3, cell D2 in the room layout sheet, if I change his room number on the front sheet to rm 9, his name will move to H4 on the room layout

Is this possible?