How to merge Excel data with an Excel template to output Excel workbooks?
0
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.
microsoft-excel microsoft-excel-2010
asked Feb 21 at 15:30
lalebardelalebarde
4231416
add a comment |
0
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.
microsoft-excel microsoft-excel-2010
asked Feb 21 at 15:30
lalebardelalebarde
4231416
1
Mailing is a special programmed function. VBA is the way to program a similar function. Here is one of many source codes for the task of How To Create Multiple Worksheets From A List Of Cell Values. You may need to google "excel 2010" or make the needed 2010 adjustments.
– Ted D.
Feb 21 at 16:39
That helps but I am not a VBA programmer. I can do it with enough examples covering my needs thought. Do you have other links to open a template and write in a new file for each sheet, and another one to read some cells in the sheet where the VBA is and write some cells in the output sheet ?
– lalebarde
Feb 21 at 16:51
You're using the word spreadsheet. Do you mean Worksheet within a workbook? Ideally the code would live in its own workbook file. You can open the code workbook file and run the macro. The macro would require 3 other file names: template file, data source file and new output file name. The new output file would have a worksheet (with the format defined in the template file) for every data row in the data source file. Is this the scenario?
– Ted D.
Feb 21 at 17:46
If there is only one template that may change over time and you never use anything other than the current template, then the code could live in the template file. The template format could be updated by modifying constants at the beginning of the macro or could exist on a sheet of the template file as you described. In the new workbook, will the worksheet names be specified by the template (shape name instead of the default "Sheet 1")? If using the shape name (or a worksheet name column described by the template) then these worksheet names need to follow the worksheet naming rules.
– Ted D.
Feb 21 at 17:58
You are right, I have corrected : workbook instead of speadsheet. The code will be with the data as I want to be able to change the template. There will be one file per raw data in the output.
– lalebarde
Feb 24 at 16:12
add a comment |
0
0
0
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.
microsoft-excel microsoft-excel-2010
asked Feb 21 at 15:30
lalebardelalebarde
4231416
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.
microsoft-excel microsoft-excel-2010
microsoft-excel microsoft-excel-2010
asked Feb 21 at 15:30
lalebardelalebarde
4231416
asked Feb 21 at 15:30
lalebardelalebarde
4231416
edited Feb 24 at 16:14
lalebarde
asked Feb 21 at 15:30
lalebardelalebarde
4231416
asked Feb 21 at 15:30
lalebardelalebarde
4231416
asked Feb 21 at 15:30
lalebardelalebarde
4231416
4231416
1
Mailing is a special programmed function. VBA is the way to program a similar function. Here is one of many source codes for the task of How To Create Multiple Worksheets From A List Of Cell Values. You may need to google "excel 2010" or make the needed 2010 adjustments.
– Ted D.
Feb 21 at 16:39
That helps but I am not a VBA programmer. I can do it with enough examples covering my needs thought. Do you have other links to open a template and write in a new file for each sheet, and another one to read some cells in the sheet where the VBA is and write some cells in the output sheet ?
– lalebarde
Feb 21 at 16:51
You're using the word spreadsheet. Do you mean Worksheet within a workbook? Ideally the code would live in its own workbook file. You can open the code workbook file and run the macro. The macro would require 3 other file names: template file, data source file and new output file name. The new output file would have a worksheet (with the format defined in the template file) for every data row in the data source file. Is this the scenario?
– Ted D.
Feb 21 at 17:46
If there is only one template that may change over time and you never use anything other than the current template, then the code could live in the template file. The template format could be updated by modifying constants at the beginning of the macro or could exist on a sheet of the template file as you described. In the new workbook, will the worksheet names be specified by the template (shape name instead of the default "Sheet 1")? If using the shape name (or a worksheet name column described by the template) then these worksheet names need to follow the worksheet naming rules.
– Ted D.
Feb 21 at 17:58
You are right, I have corrected : workbook instead of speadsheet. The code will be with the data as I want to be able to change the template. There will be one file per raw data in the output.
– lalebarde
Feb 24 at 16:12
add a comment |
1
Mailing is a special programmed function. VBA is the way to program a similar function. Here is one of many source codes for the task of How To Create Multiple Worksheets From A List Of Cell Values. You may need to google "excel 2010" or make the needed 2010 adjustments.
– Ted D.
Feb 21 at 16:39
That helps but I am not a VBA programmer. I can do it with enough examples covering my needs thought. Do you have other links to open a template and write in a new file for each sheet, and another one to read some cells in the sheet where the VBA is and write some cells in the output sheet ?
– lalebarde
Feb 21 at 16:51
You're using the word spreadsheet. Do you mean Worksheet within a workbook? Ideally the code would live in its own workbook file. You can open the code workbook file and run the macro. The macro would require 3 other file names: template file, data source file and new output file name. The new output file would have a worksheet (with the format defined in the template file) for every data row in the data source file. Is this the scenario?
– Ted D.
Feb 21 at 17:46
If there is only one template that may change over time and you never use anything other than the current template, then the code could live in the template file. The template format could be updated by modifying constants at the beginning of the macro or could exist on a sheet of the template file as you described. In the new workbook, will the worksheet names be specified by the template (shape name instead of the default "Sheet 1")? If using the shape name (or a worksheet name column described by the template) then these worksheet names need to follow the worksheet naming rules.
– Ted D.
Feb 21 at 17:58
You are right, I have corrected : workbook instead of speadsheet. The code will be with the data as I want to be able to change the template. There will be one file per raw data in the output.
– lalebarde
Feb 24 at 16:12
1
1
Mailing is a special programmed function. VBA is the way to program a similar function. Here is one of many source codes for the task of How To Create Multiple Worksheets From A List Of Cell Values. You may need to google "excel 2010" or make the needed 2010 adjustments.
– Ted D.
Feb 21 at 16:39
Mailing is a special programmed function. VBA is the way to program a similar function. Here is one of many source codes for the task of How To Create Multiple Worksheets From A List Of Cell Values. You may need to google "excel 2010" or make the needed 2010 adjustments.
– Ted D.
Feb 21 at 16:39
That helps but I am not a VBA programmer. I can do it with enough examples covering my needs thought. Do you have other links to open a template and write in a new file for each sheet, and another one to read some cells in the sheet where the VBA is and write some cells in the output sheet ?
– lalebarde
Feb 21 at 16:51
That helps but I am not a VBA programmer. I can do it with enough examples covering my needs thought. Do you have other links to open a template and write in a new file for each sheet, and another one to read some cells in the sheet where the VBA is and write some cells in the output sheet ?
– lalebarde
Feb 21 at 16:51
You're using the word spreadsheet. Do you mean Worksheet within a workbook? Ideally the code would live in its own workbook file. You can open the code workbook file and run the macro. The macro would require 3 other file names: template file, data source file and new output file name. The new output file would have a worksheet (with the format defined in the template file) for every data row in the data source file. Is this the scenario?
– Ted D.
Feb 21 at 17:46
You're using the word spreadsheet. Do you mean Worksheet within a workbook? Ideally the code would live in its own workbook file. You can open the code workbook file and run the macro. The macro would require 3 other file names: template file, data source file and new output file name. The new output file would have a worksheet (with the format defined in the template file) for every data row in the data source file. Is this the scenario?
– Ted D.
Feb 21 at 17:46
If there is only one template that may change over time and you never use anything other than the current template, then the code could live in the template file. The template format could be updated by modifying constants at the beginning of the macro or could exist on a sheet of the template file as you described. In the new workbook, will the worksheet names be specified by the template (shape name instead of the default "Sheet 1")? If using the shape name (or a worksheet name column described by the template) then these worksheet names need to follow the worksheet naming rules.
– Ted D.
Feb 21 at 17:58
If there is only one template that may change over time and you never use anything other than the current template, then the code could live in the template file. The template format could be updated by modifying constants at the beginning of the macro or could exist on a sheet of the template file as you described. In the new workbook, will the worksheet names be specified by the template (shape name instead of the default "Sheet 1")? If using the shape name (or a worksheet name column described by the template) then these worksheet names need to follow the worksheet naming rules.
– Ted D.
Feb 21 at 17:58
You are right, I have corrected : workbook instead of speadsheet. The code will be with the data as I want to be able to change the template. There will be one file per raw data in the output.
– lalebarde
Feb 24 at 16:12
You are right, I have corrected : workbook instead of speadsheet. The code will be with the data as I want to be able to change the template. There will be one file per raw data in the output.
– lalebarde
Feb 24 at 16:12
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1408206%2fhow-to-merge-excel-data-with-an-excel-template-to-output-excel-workbooks%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1408206%2fhow-to-merge-excel-data-with-an-excel-template-to-output-excel-workbooks%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Mailing is a special programmed function. VBA is the way to program a similar function. Here is one of many source codes for the task of How To Create Multiple Worksheets From A List Of Cell Values. You may need to google "excel 2010" or make the needed 2010 adjustments.
– Ted D.
Feb 21 at 16:39
That helps but I am not a VBA programmer. I can do it with enough examples covering my needs thought. Do you have other links to open a template and write in a new file for each sheet, and another one to read some cells in the sheet where the VBA is and write some cells in the output sheet ?
– lalebarde
Feb 21 at 16:51
You're using the word spreadsheet. Do you mean Worksheet within a workbook? Ideally the code would live in its own workbook file. You can open the code workbook file and run the macro. The macro would require 3 other file names: template file, data source file and new output file name. The new output file would have a worksheet (with the format defined in the template file) for every data row in the data source file. Is this the scenario?
– Ted D.
Feb 21 at 17:46
If there is only one template that may change over time and you never use anything other than the current template, then the code could live in the template file. The template format could be updated by modifying constants at the beginning of the macro or could exist on a sheet of the template file as you described. In the new workbook, will the worksheet names be specified by the template (shape name instead of the default "Sheet 1")? If using the shape name (or a worksheet name column described by the template) then these worksheet names need to follow the worksheet naming rules.
– Ted D.
Feb 21 at 17:58
You are right, I have corrected : workbook instead of speadsheet. The code will be with the data as I want to be able to change the template. There will be one file per raw data in the output.
– lalebarde
Feb 24 at 16:12