Printsummary Sheet pulling information from other sheets based on value in one cell

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Dear all,


    I am stuck with a Project and I was hoping to find someone who can help me with this. I have posted the Details here already. I can do it with nested IF functions, but that would be a huge amount of formulas. Any help would be greatly appreciated.

  • Hello,


    Unfortunately, the link inserted in your message does not work ...:(


    Any chance you could attach your file with your next message ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Hi Carim

    I posted a link to here in the other Forum because I don't want to be in breach of the Forum rules. My original message was:


    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!

  • Hi Carim


    you are a star!! I knew that there was an easier solution than IF Statements. I tested it quickly, it seems to work like a charm!!! Thank you so much!!!!!!!

  • Hi Carim


    you are a star!! I knew that there was an easier solution than IF Statements. I tested it quickly, it seems to work like a charm!!! Thank you so much!!!!!!!


    Pleased to hear you could fix your problem ;)


    Thanks a lot for your kind words ..AND for the Like  :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!