I have a table (contain a list of problem in production line) in a workbook.
I want that, whenever I add a line in the table to register a problem, then a new workbook will be generated automatically.
First workbook, only a list which contain a lot of data.
Then, the second workbook,is the individual file for each problem. Which will use data from the list but in different format & arrangement. Then I can edit the second workbook, example to add photos.