Steps that make your block

Finally, the most exciting part: assembling the steps of a block.

Error

These steps are really yours, add, modify, delete them as you wish. If you could choose a scenario to start with, then those steps are already filled, but you can modify them as well. To the right are the editing options. Below you can find some tips on an optimal block structure.

Tips for an optimal block structure

This list is a suggested (rough) order of your steps within the block (all of them are optional, use the ones that you need, one or more times):

  • Start the block with a comment step shortly describing its goal and solution. This helps greatly to maintain the process in the future.
  • Create new folders that belong to this block
  • Copy/move/rename workbooks as preparation for working with the worksheets in them
  • Start a loop to process worksheets from a list of workbooks
  • Start a loop to process list of rows/columns in a worksheet
  • Create new worksheets
  • Add filters to the source worksheets using
    • Parameters from the parameter worksheet; or
    • Values from the source worksheets; or
    • Values from the current row of a row list
  • Copy ranges from source worksheets to target ones
  • Set target cell values using source values (and possible calculations)
  • Clear filters
  • Release worksheets that were created within a loop
  • Take the next row in a row list
  • Take the next row in a workbook list

This website uses cookies to ensure you get the best experience on our website.