User Profile
teachersmith
Copper Contributor
Joined Feb 09, 2023
User Widgets
Recent Discussions
moving data to list based on adjacent cells
Hello, sorry if this has been answered already--I feel like I used to know this but I've forgotten. I am a teacher, and I'm trying to help my school streamline our dismissal process. We have a bus manifest that is changing it seems like every other week which means there are students who will not know what bus they are on until dismissal time when our principal calls the bus number and then all the students names who belong to that bus. As you can imagine, this is a lot of effort for the end of the day! I am trying to organize the data into separate tables so that I can simply highlight which bus is being called instead of them being announced. Since the bus that students are riding changes so often, I need a way to quickly convert the data into these tables. I'm given a raw list with names and bus numbers but I need them organized neatly like in the sample sheet, without having to tediously copy-paste every time the list changes. What I am hoping to be able to do is have the first three columns on the sheet there for data input from the bus manifest, and then that data be pulled into a neat clean table to the right. Hopefully the sample sheet makes this more clear! It is totally editable, so go wild. (If it is possible to move the tables to the second sheet in the workbook labeled DISMISSAL that would be preferable, but understandable if not) sample sheet removedSolved2.1KViews0likes7Comments- 1.9KViews0likes4Comments
Recent Blog Articles
No content to show