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.
