•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
More resource efficient way to pull data into slips by person name that works with 200+ people?
We use 2016 excel with the upgrade from our o365 package.
We create productivity slips for our people that show how they are doing in each of our 8 queues. The slips are printed and passed out.
We currently have the bulk data in it's own worksheet and made a worksheet for each queue to remove the filter function from the Xlookup we do in the slips B2:E10 range. The slips are copied with the names being adjusted for each person.
Is there a better way to build this?
slips have the following layout:
A1= Name
B1 is filler space
B2:B10 = Queue Names
C2:C10 = Total Productivity
D2:D10 = Time Spent Working
E2:E10 = Expected Time Spent Working
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#Excel compatibility
#real-time collaboration
#Excel alternatives
#big data management in spreadsheets
#conversational data analysis
#rows.com
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#resource efficient
#productivity slips
#data