Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
en:user_guide:first_process [2023/08/04 22:19] tiger [Edit/Remove process steps] |
en:user_guide:first_process [2023/08/04 22:21] (current) tiger [Know your process] |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| - Open the //master data// worksheet and go through the entries in it one by one. For each entry: | - Open the //master data// worksheet and go through the entries in it one by one. For each entry: | ||
| - Open the corresponding //source worksheet// | - Open the corresponding //source worksheet// | ||
| - | - Identify every separate cell or range on the //target template// that you can fill in a simple step. E.g. | + | - Identify every separate cell or range on the //target template// that you can fill in a simple step using the current //source worksheet//. E.g. |
| - set a cell or a range to a fix value (either constant or taken from the source worksheet or calculated using other fix values); | - set a cell or a range to a fix value (either constant or taken from the source worksheet or calculated using other fix values); | ||
| - find a cell with a certain value in a range to use the value or the location (row number or column letter) of the found cell later. | - find a cell with a certain value in a range to use the value or the location (row number or column letter) of the found cell later. | ||