Busscheduler
New Member
- Joined
- Nov 23, 2020
- Messages
- 41
- Office Version
- 2016
- Platform
- Windows
Hi everyone, I am looking for help with a macro that will sort a list of guests that is dependent on what resort they are staying at and then open a new tab and place that information in a certain format. Here is the information that I am working with in Excel:
I apologize if I need to upload the spreadsheets. Please let me know and I will do that instead of jpegs.
The macro would need to sort each group by resort name, since the number of rows would change daily depending on how many guests they have that day, collect only the names for that resort and put them together in the format below.
I have limited skills when it comes to doing Macros, so any help would be greatly appreciated.
I apologize if I need to upload the spreadsheets. Please let me know and I will do that instead of jpegs.
The macro would need to sort each group by resort name, since the number of rows would change daily depending on how many guests they have that day, collect only the names for that resort and put them together in the format below.
I have limited skills when it comes to doing Macros, so any help would be greatly appreciated.