multiple data with header in one row VBA

  • Hi

    can i please get a little help. I would like to get multiple data with header (wich should be taged »name + 1,2,3,etc…)in one row based on an ID wich is »Series« and then sorted on »Name of component batch« and its matching »component of batch«


    Guess this is only doable in VBA


    I made a yellow spreadsheet of current state (this is the form in wich i get data), and blue spreadsheet desired look (this is how i would like it to look with macro).


    Thank you in advance

    BR

    Files

    • problem1.xlsx

      (23.19 kB, downloaded 82 times, last: )
  • This worked after I removed all the notes in your sample file...

    If I've been helpful, let me know. If I haven't, let me know that too.

  • This worked after I removed all the notes in your sample file...

    hi, the code works great but it is missing the header in first row. Can you please change it so the header would be included.

    Thank you


    Br

  • Hello,

    sorry i couldnt find the code, module 1 is empty

    Hi, just found out why there was no macro in the file. Our IT security enabeld something in antivirus program that autonaticly delets macros from excell files. Itried it again on my own comp and it works great. Thanks again:)

  • Quote

    ...the code works great but it is missing the header in first row...

    Try this

    If I've been helpful, let me know. If I haven't, let me know that too.