ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   dynamic range ?? (https://www.excelbanter.com/excel-discussion-misc-queries/247598-dynamic-range.html)

Ana

dynamic range ??
 
Hi,

I need to calculate the SUM between 2 dates , I choose each date from a drop
list.
I need that each time I change the dates the result of the SUM change.

I need to define a dynamic name but I do not know how to do it and use the
referece of the 2 date I have.
Anyone knows how to do it?

Thank you

Ana

dynamic range ??
 
I found the solution
thanks


"Ana" wrote:

Hi,

I need to calculate the SUM between 2 dates , I choose each date from a drop
list.
I need that each time I change the dates the result of the SUM change.

I need to define a dynamic name but I do not know how to do it and use the
referece of the 2 date I have.
Anyone knows how to do it?

Thank you



All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com