Results 1 to 3 of 3

Combine a workbook or sheets?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-28-2015
    Location
    london
    MS-Off Ver
    Microsoft Office 365
    Posts
    116

    Combine a workbook or sheets?

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Power Query: combine sheets from different workbook
    By erica.ho56458 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2018, 02:28 AM
  2. Combine Sheets into 1 workbook
    By danallamas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2017, 09:48 AM
  3. VBA - Combine sheets in different files into workbook
    By spencerp237 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2017, 01:37 PM
  4. How do I combine 2 sheets of Data on a 3rd sheet in the same workbook
    By Tricky001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2016, 07:12 AM
  5. [SOLVED] Combine multiple sheets into one sheet in the same workbook
    By Jacolene in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-24-2016, 10:44 AM
  6. Is there a simpler way to combine two other workbook sheets together?
    By SanDiegoCasey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2016, 12:29 AM
  7. Combine CSV files into 1 Excel Workbook as sheets
    By JEFF in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2006, 06:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1