MsValCalla
New Member
- Joined
- Jan 30, 2023
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
So I am trying to create a button where you can sort by name, except when I do it the way I know how to do it, it only does that column alone. I want all the data from the surrounding columns to stay with the name it was originally with. So my columns from left to right are B5-J5 labeled as Date, Name. Type of Event, Event Details, Duration, Exception, Infraction, Occurrences, and Level of Plan. So if person A is on line C6, with a planned absence, for a total of 6 days, I want that data to stay with them when I click the button to sort it ascending. If clicking it takes Person A's name to C15 now, then that data it at in the other columns before needs to go with it. Does that make sense? I am planning on making 2 buttons. One for the name, one for the date and same task. Any Advice?