•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
list that wraps around and keeps position
on one sheet i have a list of names (for this example let's visualize the alphabet as the names)
on another sheet, if i type in A on the first line
a list from A to Z will populate from top to bottom
if i type in L on the first line
a list from L to Z will populate & after Z will come A - K then the list will stop
post script: i have names of employees that have a particular order.
every other day a diff person will be first, and the order must be kept and wrapped around back to the top person.
not sure how to do this... appreciation for all replies
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#list
#order
#populate
#employees
#names
#wrapped around
#A to Z
#alphabet
#first person
#dynamic list
#wraps around
#top person
#input
#sheet
#diff person