Forum Discussion
Michael Kline
Mar 27, 2018Copper Contributor
Looking for suggestions on how to re-work this file:
I currently use excel to track available sick and vacation time balances for employees. The basic information has been kept on a summary sheet in the workbook. I then have 52 weekly "reports" (work...
Mark Modricker
Mar 28, 2018Copper Contributor
Hi Michael,
Have you looked into using Get & Transform to run a query against each sheet?
This could aggregate into a PowerPivot, allowing you to see the results more easily.