Switch data macro

[NurseRich]

I have a work book with 4 sheets (Census, 100 Unit, 200 Unit, and 300 Unit).
The Census sheet contains room numbers and resident names.
The resident names populate on to the appropriate unit according to the room number.
The units sheets are all the same format.
I am trying to make a macro which prompts the user to select a room number on the census sheet in column A using their mouse. Then select a second resident in the same way.
The macro then switches the names on census, but also seeks the room numbers on the other sheets and switches all the data in columns B,C,D,E,F,G,H and I (except for the room number in column B).

Often times, our residents need to have their rooms switched. I am trying to create an easy method to do this. I have tried the AI stuff, and it's not working.
Any assistance would be helpful.

Thank you so much,

Nurse Rich

Attached are screen shots to better understand what things look like.
Using Windows 10 Pro
Microsoft Excel version 2404 Microsoft 365

 

[bobaol]

Hello NurseRich, will you please provide more details. Please go step by step. For example, in your image, the 1st step is to click cell A7 in Census. Is step2 click B7, then step3 click A38, 4th step click B38? Wait a minute, I think I got it, you're wanting to move patient100 from room 104-A to another room. what room is patient100 104-A going? The part about the second resident is not clear. How does the second resident relate to patient100? Patient100 can move to any other room, and the second patient can move to any other room. correct? Cheers!