Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
en:user_guide:worksheet_basic [2021/01/22 12:49] tiger [Example: Data consolidation] |
en:user_guide:worksheet_basic [2021/01/22 12:51] (current) tiger [Example: Data consolidation] |
||
|---|---|---|---|
| Line 51: | Line 51: | ||
| Several departments are delivering monthly financial information using a well-prepared template. Each department delivers a separate workbook containing only one report worksheet. The workbooks are collected in a specific folder. The process to automate is consolidating these reports: | Several departments are delivering monthly financial information using a well-prepared template. Each department delivers a separate workbook containing only one report worksheet. The workbooks are collected in a specific folder. The process to automate is consolidating these reports: | ||
| * to company level; | * to company level; | ||
| - | * to yet another workbook; | + | * to yet another, already existing, |
| * on one worksheet; | * on one worksheet; | ||
| * having another template. | * having another template. | ||
| Line 57: | Line 57: | ||
| The process looks like that: | The process looks like that: | ||
| - | * First, the target worksheet should be identified and used: **[[en: | + | * First, the target |
| * Then a workbook list should be set up to go through the workbooks in the report folder: **[[en: | * Then a workbook list should be set up to go through the workbooks in the report folder: **[[en: | ||
| * Select the necessary range from the current report worksheet and copy them to the appropriate location in the company template: **[[en: | * Select the necessary range from the current report worksheet and copy them to the appropriate location in the company template: **[[en: | ||