<div>
AWESOME Guys,<br />
Thanks MDS for the help.<br />
Thank you Patrick - that’s perfect, then I doesn’t have to worry about expanding column set, HUGE lifesaver, right there!!!
</div>


AWESOME Guys,
Thanks MDS for the help.
Thank you Patrick - that’s perfect, then I doesn’t have to worry about expanding column set, HUGE lifesaver, right there!!!

<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
Assuming there is a a table from column C to Z starting from row row 10, then this is the dynamic range formula for it<br />
=mySource!$C$10:INDEX(mySo<wbr />urce!$Z:$Z<wbr />,MATCH(REP<wbr />T(&quot;z&quot;,20),<wbr />mySource!$<wbr />C:$C))<br />
<br />
Now what if I only had one column at column C and want to make it dynamic, how the same approach formula can be used in that case (using index match) <br />
<br />
so I am looking for a dynamic named range formula for a range that's just one column, using the same approach as discussed?<br />
<br />
thanks
</div>
</div>


Hello All,

Assuming there is a a table from column C to Z starting from row row 10, then this is the dynamic range formula for it
=mySource!$C$10:INDEX(mySource!$Z:$Z,MATCH(REPT("z",20),mySource!$C:$C))

Now what if I only had one column at column C and want to make it dynamic, how the same approach formula can be used in that case (using index match) 

so I am looking for a dynamic named range formula for a range that's just one column, using the same approach as discussed?

thanks

Dynamic This!

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.