1 min readfrom 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

submitted by /u/AgreeableKey8093
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article