•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sorting Information from Sheet to Sheet
At work I have a list of jobs (in one column) with an assigned person to compete each task (in one column) with a date next to each persons name when the task is due (in one column). This page is sorted by due date. I would like on a separate page have each person listed as a header with their assigned task from the previous page. This way I can easily see how many tasks each person has and asign the next task to the person with the least tasks. It doesnt have to update in real time just whenever I open the workbook.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#financial modeling with spreadsheets
#real-time data collaboration
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#tasks
#due date
#list of jobs
#assigned person
#assigned task
#task assignment
#workbook
#least tasks
#person's name
#separate page
#sorting
#task management
#header
#real time
#overview