Hi everyone,
Hope you can shed me some light on this.
I have at least 13 sheets in 1 workbook, and have to create at least 50 workbook 1 for each employee.
I created this workbook to record hours for employee. I need to keep the format as I need to send a copy of it saved in a pdf format to their email.
The advantage of this workbook is a straight forward design and viewing of the file if printed in paper.
I would like to have a master sheet where I can see a summary of data of each employee and will be able to open a sheet with a link.
I have saved and shared this workbooks in onedrive.
The problem I am having in this process is that I am creating too many workbook rather having everyone and everything in one file with individual folder. Another problem is, if I have hyperlink to employee name to open the workbook, it always ask me that downloading a file from internet is unsafe ( this is folder under onedrive ).
Is there any way I can do to keep all of this in one workbook while keeping the exact format when printing?
I have attached the workbook I created for a better and clear understanding of what I'm trying to do.
If you can lead me somewhere or how I can do this will be greatly appreciated.
Thank you very much in advance.
Bookmarks