T
TamaraSoCal
Hello -
I have been given an Excel workbook with 12 sheets that will be updated
multiple times a day by multiple users (each with their own sheet). At least
once a month the data needs to be compiled into a consolidated sheet or
report. Each user will only be allowed to access their specific sheet or
workbook (password protected?) and each sheet is the same as far as format
and formulas. I apologize for my cluelessness but would it be better to
create separate workbooks for each person to avoid the save orverwrite issues
or should I create a "main" sheet for everyone to input information into
each day and save with their own file name? Later, I can merge these for a
consolidated report? Or maybe there is a better option such as each of them
using their own workbook and then importing these to Access for a report?
Any help or suggestions would be much appreciated.
I have been given an Excel workbook with 12 sheets that will be updated
multiple times a day by multiple users (each with their own sheet). At least
once a month the data needs to be compiled into a consolidated sheet or
report. Each user will only be allowed to access their specific sheet or
workbook (password protected?) and each sheet is the same as far as format
and formulas. I apologize for my cluelessness but would it be better to
create separate workbooks for each person to avoid the save orverwrite issues
or should I create a "main" sheet for everyone to input information into
each day and save with their own file name? Later, I can merge these for a
consolidated report? Or maybe there is a better option such as each of them
using their own workbook and then importing these to Access for a report?
Any help or suggestions would be much appreciated.