Reporting multiple datasets to the same rows.

This example shows how to send different datasets to the same rows in different columns. Is for UNRELATED columns, for normal use you should use master-detail and joins. Note that the number of rows inserted is the same as the bigger dataset. If you want to summarize data, you must either write the lines at the top, or use a common bottom row.

Concepts shown

•	To define a range including more than one dataset, name it as __DataSet1__DataSet2__.......__DataSetn__. This range will expand as much as the bigger dataset.

•	As often mentioned, formatting is done by Conditional Formatting. Here I show how you could use it to get alternating colored rows. (Not that I really like it… but anyway). To see how this is done select the range D4:E4 in the template, and choose Menu->Format->Conditional Format. Note that this is a better approach than formatting by code, because if your user inserts a row, the alternating format will be preserved.