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...
Forum Discussion
Hello,
the data architecture you describe is not desirable. It would be better to have just one sheet for data entry. If you need to show data for a certain person, you could build a report. One report can be set up so that different people can be selected. That would dramatically reduce the number of sheets in your workbook and would simplify things a lot.
I would agree but it's a timesheet so I need everyone separate to keep timesheets confidential. IngeborgHawighorst
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.
