Hello All,

I’m looking to link and create a new Excel workbook whenever I create a new row.

For example;

Whenever I create a new row I want excel to make a new workbook that is saved on the internal server.
The name of this workbook will need to contain the information in cells D & E.

A hyperlink on cell C will need to open this workbook.

Reason for this seperate workbook is so that information on a project can be stored in this workbook & the original overview file can be kept clean with only the essential information.

I can understand that this question might be unclear. If you need any more info, please feel free to ask! 

Already thanks for the help

Kind regards,

Bram

​Hello All,I’m looking to link and create a new Excel workbook whenever I create a new row. For example; Whenever I create a new row I want excel to make a new workbook that is saved on the internal server.The name of this workbook will need to contain the information in cells D & E.A hyperlink on cell C will need to open this workbook. Reason for this seperate workbook is so that information on a project can be stored in this workbook & the original overview file can be kept clean with only the essential information. I can understand that this question might be unclear. If you need any more info, please feel free to ask!  Already thanks for the help Kind regards,Bram   Read More

​