Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
en:user_guide:worksheet_lists [2020/06/16 22:56] tiger [Working with many worksheets] |
en:user_guide:worksheet_lists [2020/06/23 11:04] tiger [Know your process for one worksheet; then switch to multiple] |
||
|---|---|---|---|
| Line 17: | Line 17: | ||
| ==== Know your process for one worksheet; then switch to multiple ==== | ==== Know your process for one worksheet; then switch to multiple ==== | ||
| - | The first step is to specify the process for one source worksheet just like it is done for a single worksheet case. Use **WSheet Use** to specify the only source | + | The first step is to specify the process for one source worksheet just like it is done for a single worksheet case. Use **WSheet Use** to specify the target consolidation |
| - replace **WSheet Use** for the only source worksheet by **WBook List Start** for all the worksheets at the beginning (NB: keep **WSheet Use** for the target!); | - replace **WSheet Use** for the only source worksheet by **WBook List Start** for all the worksheets at the beginning (NB: keep **WSheet Use** for the target!); | ||
| - specify all the worksheets in the Workbook list parameter | - specify all the worksheets in the Workbook list parameter | ||
| - add **WBook List Next** to the end of the operations; | - add **WBook List Next** to the end of the operations; | ||
| - | - use the [[en: | + | - use the [[en: |
| - replace the target cell of cell and range operations to allow for | - replace the target cell of cell and range operations to allow for | ||
| * appending rows; | * appending rows; | ||