•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