I have a spreadsheet workbook with data per raws:
+-----------+------------+-------------+ | shapes | property 1| property 2 | *-----------+------------+-------------+ | S1 + 20 | glop | +-----------+------------+-------------* | S2 + 10 | rrrr | +-----------+------------+-------------* and a template workbook like this one in pseudocode:
+-----------+------------+-------------+ | shape | Name | property 2 | *-----------+------------+-------------+ | + <shapes> | <property 2>| +-----------+------------+-------------* and I want to produce as many workbooks as data in rows like this:
workbook 1:
+-----------+------------+-------------+ | shape | Name | property 2 | *-----------+------------+-------------+ | + S1 | glop | +-----------+------------+-------------* workbook 2:
+-----------+------------+-------------+ | shape | Name | property 2 | *-----------+------------+-------------+ | + S2 | rrrr | +-----------+------------+-------------* How can I do it please under Excel 2010 without POWER QUERY and possibly without VBA? Actually, my need is like a mailing from workbook contact that generates workbooks instead of sending emails.
