•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to Alphabetise a Holiday Sheet
Our take
Managing a holiday sheet can be a daunting task, especially when it comes to organizing names alphabetically while ensuring that all associated data remains intact. If you’re looking to streamline this process, there’s a solution that allows you to anchor rows to names, ensuring they move together during sorting. This approach not only simplifies the alphabetical arrangement but also makes it easy to add new names without the hassle of manual adjustments.
Hi everyone, hope you can help.
I’ve been tasked with the worker holiday sheet as one of my responsibilities and need to alphabetise the names BUT have the rows move with said name when they get sorted.
Is there a way to anchor a row to a name and have it follow when I alphabetise the column? I also need to be able to add a name and replicate this. Sorting them by hand isn’t ideal, there are a lot of names.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#financial modeling with spreadsheets#Excel compatibility#row zero#Excel alternatives for data analysis#Excel alternatives#alphabetise#holiday sheet#names#sort#worker#rows#anchor#column#column sorting#replicate#add a name#follow#sheet management#responsibilities