View original (French)

Automatic creation of tabs based on the template.

Solved
Khrys001 Posted messages 6 Status Member -  
 Antho -
Hello,

I created an Excel file with a "summary" sheet and another "template." My goal is to create files (one sheet per row) based on these two sheets by integrating the different data taken from a row into a report identical to the template.
I succeeded in creating the different sheets renamed with the content of the first column, but I cannot transfer the data to the desired locations.

If someone could help me, it would save me from spending another sleepless night.

Thank you,
Khrys

2 answers

  1.
    Boisgontierjacques Posted messages 177 Status Member 64
     
    Good evening,

    http://boisgontierjacques.free.fr/fichiers/Onglets/CreeOngletsServiceModele.xls

    http://boisgontierjacques.free.fr/pages_site/GestionOnglets.htm#Cr%C3%A9ation2

    Boisgontier
    3
    1. Khrys001
       
      Wow, that's fast. Thank you, it's exactly what I was looking for.
      Now I just have to apply it to my spreadsheet.

      A big thank you and have a good evening.
      0
    2. Khrys001
       
      It has been applied to my workbook and it works wonderfully, thanks again,

      Khrys
      0
    3. Antho
       
      Hello

      How do you copy the data into each sheet like in your example?
      0