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
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
