Doug Mutzig
Board Regular
- Joined
- Jan 1, 2019
- Messages
- 57
- Office Version
- 365
- Platform
- Windows
Good morning all! I received a request for help that has me stumped and I am hoping someone can offer some guidance on what to do.
The end user has created a worksheet that has several data entry cells (see picture). The first entry for each section is the room number which comes from a drop down selection list. Since patients can be placed in any room at any time they would like to be able to sort all of the sections by room number. I believe they want only rooms with a patient to be sorted and empty rooms moved to the bottom. There are no tables for these sections, but the ranges are static. Is there a way to review all of the input data by range and then sort the ranges by room number and name (something entered vs. blank)?
I am thinking that a change to an input form that enters the data into a table and then somehow displays that table contents in the format shown would be a better way to do, I just do not know how to get the data from that table to the format shown. I know it could be as easy as linked cells; however, I am wondering if there is a better way?
The end user has created a worksheet that has several data entry cells (see picture). The first entry for each section is the room number which comes from a drop down selection list. Since patients can be placed in any room at any time they would like to be able to sort all of the sections by room number. I believe they want only rooms with a patient to be sorted and empty rooms moved to the bottom. There are no tables for these sections, but the ranges are static. Is there a way to review all of the input data by range and then sort the ranges by room number and name (something entered vs. blank)?
I am thinking that a change to an input form that enters the data into a table and then somehow displays that table contents in the format shown would be a better way to do, I just do not know how to get the data from that table to the format shown. I know it could be as easy as linked cells; however, I am wondering if there is a better way?