+ Reply to Thread
Results 1 to 8 of 8

What formula do I need to use to create a template for multiple page sheet?

  1. 11-29-2019, 01:00 PM #1
    CXMACLEOD
    CXMACLEOD is offline
    Registered User
    Join Date
    07-12-2016
    Location
    Mount Olive, Alabama
    MS-Off Ver
    2013
    Posts
    47

    What formula do I need to use to create a template for multiple page sheet?

    I have a template page that needs to read a line of data from another sheet, plug the data into appropriate cells and print a page and then move on to the next line of data and do the same thing.

    In the past, I never had to do this with more than 2 or 3 sheets and I would just copy the template below the first template, and have a multi-page sheet where I would manually plug in the data myself, but now I need a sheet that reads a lot of data and prints a lot of sheets.

    Is there a way to do this?
    Reply With QuoteRegister To Reply
  2. 11-29-2019, 01:08 PM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: What formula do I need to use to create a template for multiple page sheet?

    It sounds like a Mail Merge type of operation - there are many examples if you search the site for those two words.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 11-29-2019, 08:54 PM #3
    CXMACLEOD
    CXMACLEOD is offline
    Registered User
    Join Date
    07-12-2016
    Location
    Mount Olive, Alabama
    MS-Off Ver
    2013
    Posts
    47

    Re: What formula do I need to use to create a template for multiple page sheet?

    No, that's not what I'm trying to do.
    Last edited by AliGW; 11-30-2019 at 02:07 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 11-30-2019, 02:09 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: What formula do I need to use to create a template for multiple page sheet?

    You'll need VBA for this - shall I move the thread for you?

    Please provide a sample workbook - look at the yellow banner up top.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 11-30-2019, 06:54 AM #5
    CXMACLEOD
    CXMACLEOD is offline
    Registered User
    Join Date
    07-12-2016
    Location
    Mount Olive, Alabama
    MS-Off Ver
    2013
    Posts
    47

    Re: What formula do I need to use to create a template for multiple page sheet?

    Okay, I attached.

    In a nutshell, I have a sign-in sheet for recording hours. There will be 3 people per sheet. The sheet will read 3 lines of data from another worksheet and print 1 page and then read the next 3 lines of data and print another page. The lines 6,7,28, and 15,26,37 are the only lines that have data that will change.
    Attached Files Attached Files
    Last edited by AliGW; 11-30-2019 at 08:05 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  6. 11-30-2019, 09:16 AM #6
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: What formula do I need to use to create a template for multiple page sheet?

    Two essentials.
    Redesign form without ANY merged cells (they are the curse of the devil for VBA data manipulation).
    Tabulate the incoming data in a more logical format.
    After this it may be possible to achieve your requirements.
    torachan.
    Reply With QuoteRegister To Reply
  7. 11-30-2019, 04:05 PM #7
    CXMACLEOD
    CXMACLEOD is offline
    Registered User
    Join Date
    07-12-2016
    Location
    Mount Olive, Alabama
    MS-Off Ver
    2013
    Posts
    47

    Re: What formula do I need to use to create a template for multiple page sheet?

    I prefer not to redesign. I thought this would not be overly difficult.
    Last edited by AliGW; 11-30-2019 at 04:16 PM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  8. 11-30-2019, 04:28 PM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: What formula do I need to use to create a template for multiple page sheet?

    Thread moved to the VBA section.

    The advice is sound: the merged cells need to go.

    Excel is not designed for page layout: it's a tool for data analysis. If it were me, I'd be designing the output form in Word and mail merging to it, as was suggested above. It's a case of the right tool for the job.

    If you are adamant that it must be done in Excel, and want the VBA experts to help you, then you will need to be prepared to compromise.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to Create New Renamed Page from Template
    By b0ttle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2014, 04:02 PM
  2. Move data to new sheet and create copy of template sheet
    By jdm13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2014, 01:53 PM
  3. [SOLVED] Create new sheet from template, auto fill from index sheet and hyperlink
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2013, 04:57 AM
  4. Macro to create multiple sheets from template and fill with datas from one sheet
    By naga in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2013, 06:20 AM
  5. Summarize Sheets onto one Sheet / Create New Sheet from Template with Button
    By albizzundy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2013, 01:33 PM
  6. Macro to create formula for Main Page from data on other page
    By Drew Davis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2011, 06:35 AM
  7. In Excel, how do you create a multi page Invoice Template?
    By ALLEYK in forum Excel General
    Replies: 1
    Last Post: 05-17-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1