Using Named Ranges in Excel with a selection of cells?
<p><strong>Is it possible in Excel to use a defined named range such as <code>myArray</code> refers to <code>=summary_data!$C$2:$H$6</code></strong></p>

<p><strong>Then use this name in another sheet to paste the contents of the data to a given range <code>=summary_data!$C$2:$H$6</code></strong></p>

<p>The reason to do this is that I am injecting data into other sheets in a template and the front sheet takes the data from many sheets.</p>

<p>Currently I can do this with single cells using the following but defining each individual cell is tedious:</p>

<p><code>=INDIRECT("'" &amp;V1&amp; "'!" &amp; "summary_data_C2")</code>  a name is set to summary_data_C2 an V1 contains the worksheet name.</p>