+ Reply to Thread
Results 1 to 4 of 4

Create a new workbook from a template worksheet using information from main workbook.

  1. #1
    Registered User
    Join Date
    02-21-2017
    Location
    Castelford
    MS-Off Ver
    2013
    Posts
    89

    Create a new workbook from a template worksheet using information from main workbook.

    Hi all,
    I'm after a bit of help writing some code to create a new workbook from a template (production sheet) based on cell values (dates) in an different worksheet(WIP)

    What i require is the code to look at a column AO and see if any of the values (dates) in that column are in the current working week, it will then copy the information from WIP to Production Sheet and input the information into the a cell based on the value (date). it will also have to take into account the number of hours allowed (column BI). a working day is based on 16 hours so it will have to deduct 5 hours from 16 which will leave it with 11 hours for the day. if there are not enough hours in the day it will go to the next available day.

    I have created a workbook with an example all all this information already inputted.

    Just hope someone could help me with the code.

    Thanks
    ND.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-21-2017
    Location
    Castelford
    MS-Off Ver
    2013
    Posts
    89

    Re: Create a new workbook from a template worksheet using information from main workbook.

    Bumping up the list for any help if possible?

  3. #3
    Registered User
    Join Date
    02-21-2017
    Location
    Castelford
    MS-Off Ver
    2013
    Posts
    89

    Re: Create a new workbook from a template worksheet using information from main workbook.

    Can anyone help with this before i mark it as solved?

  4. #4
    Registered User
    Join Date
    02-21-2017
    Location
    Castelford
    MS-Off Ver
    2013
    Posts
    89

    Re: Create a new workbook from a template worksheet using information from main workbook.

    Bump to raise in the list?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-10-2014, 05:20 AM
  2. Copy information from other workbook to main workbook help 2007
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2013, 08:09 PM
  3. Replies: 4
    Last Post: 04-02-2013, 02:55 PM
  4. Using Vba create another workbook then update the formulas of main workbook
    By rename in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 06:12 AM
  5. Replies: 3
    Last Post: 07-06-2012, 01:26 PM
  6. Setting formula in template with reference to main workbook
    By monkdelafunk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2008, 10:22 AM
  7. quickly create extra copies of a worksheet template in a workbook
    By simon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2005, 03:05 PM

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