•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to Alphabetise a Holiday Sheet
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]
Want to read more?
Check out the full article on the original site
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