+ Reply to Thread
Results 1 to 2 of 2

Printsummary pulled from other sheets

  1. #1
    Registered User
    Join Date
    03-29-2012
    Location
    Germany
    MS-Off Ver
    Office 365
    Posts
    42

    Printsummary pulled from other sheets

    Hi everyone,
    I am stuck with a Project and I would Need some advise. I have created a schedule that can be used to track attendance in the Computer. But it is too large to print (on letter size/A4 paper). So I would like to create a Print Summary sheet, which pulls the Information from a specific sheet.

    Example: I enter my schedules in sheet KW1 for my staff. This sheet is set to print ok on A3 Format. But as there are not enough A3 Printers, I Need it in A4 Format. For this, I have created the sheet 'Print'. On this sheet, I want to be able to enter the sheet Name (KW1-52) in cell B1, from which then, the 'Print' page pulls all the data from. It would eg. pull in row 7, the ID No, Name, Carryover items (RU, UR, GT, GS) and then the daily start and end times, exactly as they are on sheet KW1. And if I enter KW2 in B1, it would pull this Information from sheet KW2, etc. There should be no further calculations on the 'Print' sheet, it is purely to Format the data for A4 size printing.

    I don't think an IF function would work as there will be 52 Sheets to pull from…. is there any other Option to achieve this??

    Any help would be greatly appreciated. The file is attached.

    Thanks so much for your time!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-29-2012
    Location
    Germany
    MS-Off Ver
    Office 365
    Posts
    42

    [SOLVED] Printsummary pulled from other sheets

    As I have not yet heard back on this Forum, I have posted it on here too. Solution in the other forum
    Last edited by myexcelstar; 12-12-2019 at 10:02 AM.

+ 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. Summarising where data is being pulled from
    By nadeem_05 in forum Excel General
    Replies: 5
    Last Post: 04-07-2019, 03:15 PM
  2. Need Info Pulled from Drop down
    By twits19 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-01-2018, 09:37 AM
  3. [SOLVED] Getting the middle section pulled out
    By LightHeart7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2013, 04:30 PM
  4. Formatting data pulled from web
    By cps439 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2011, 04:35 PM
  5. [SOLVED] how to get the data pulled from multiple sheets?
    By all4excel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2007, 05:07 PM
  6. [SOLVED] copying charts into new sheets, data is pulled from old sheet
    By kstevens in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-24-2006, 11:10 AM
  7. Need info pulled from worksheet
    By Saut1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-14-2005, 06: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