Forum Discussion
kileecovert
Jul 16, 2019Copper Contributor
Help! Is this possible??
Hello- I would like to set up multiple sheets within an excel workbook where people can go to their tab and input data and then have that data transfer to a "totals" sheet also within the workbook. I...
kileecovert
Jul 16, 2019Copper Contributor
I would agree but it's a timesheet so I need everyone separate to keep timesheets confidential. IngeborgHawighorst
Jul 16, 2019
kileecovert They can't see each others' sheets? That must be one heck of a workbook.
You can let everybody use their own workbook for their time sheet entry. Let the files be stored in one folder. Then you can use Power Query to collect the data from all the files in that folder and do your report and aggregations.