View original (French)

Automate a school report card

Solved
yvespeter Posted messages 185 Registration date   Status Member Last intervention   -  
yvespeter Posted messages 185 Registration date   Status Member Last intervention   -
Hello everyone

I'm reaching out for help with the setup of an automatic report card that I've created. The issue is that I don't know how to automatically change names with each print. The blank report card is on the first tab and the data table is on another tab, which I'm attaching below for better illustration.

https://www.cjoint.com/?0KchYt3qpoV

Thank you for your help, it is truly valuable to me.

4 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    You can use the OFFSET() function by using a cell that will not be printed, for example J1.
    Example for the name in D2:
    =OFFSET('TABLEAU EFFECTIF'!A4;$J$1;)

    https://www.cjoint.com/?BKcje2LRoUU
    I added a spinner to easily change students.

    Eric

    --
    You should never respond to an unsolicited message...
    Well, that’s done.
    0
    1. yvespeter Posted messages 185 Registration date   Status Member Last intervention   11
       
      It's great progress already, but there's a small issue: the name changes with the formula =OFFSET('TABLEAU EFFECTIF'!A4,$J$1;) as you demonstrated, except that the student's data does not change.

      Normally, when I choose a name, all the information on the line should automatically appear on the dashboard.

      Regarding the grades, averages, comments, and others, I'm counting on you.
      0
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Re,

      I showed you a formula, now it's your turn to do the others in the same model.
      We're not going to do everything for you either...

      Hello to Mike and Michel ;-)

      Eric
      0
    3. yvespeter Posted messages 185 Registration date   Status Member Last intervention   11
       
      Eric, you are absolutely right, but if I were able to do it, frankly, I wouldn't have come to you, and if I also had your skills and abilities, I would really be like you in this community to help others like you do every time and at all times.

      Thank you, you are great, I say it and will always say it because it's not the first time you have helped me in this community.
      0