Prev: tracking changes in excel in an unshared workbook
Next: Multiple lists in a cell
From: Julie on 24 Feb 2010 13:10
I am trying to update my data range in a nested array function without having
to change every cell. Is there a way to change the entire data range within
the sheet? We are using our lead sheet as a template and when we are using
it again the raw data range expanded so now we need to pick up the additional
rows and columns. Any suggestions?
From: T. Valko on 24 Feb 2010 13:17
Sounds like you need a dynamic range. See this:

http://contextures.com/xlNames01.html#Dynamic

--
Biff
Microsoft Excel MVP


"Julie" <Julie(a)discussions.microsoft.com> wrote in message
news:B8DF00A7-2595-4044-9C0F-AAE3515B022D(a)microsoft.com...
>I am trying to update my data range in a nested array function without
>having
> to change every cell. Is there a way to change the entire data range
> within
> the sheet? We are using our lead sheet as a template and when we are
> using
> it again the raw data range expanded so now we need to pick up the
> additional
> rows and columns. Any suggestions?


 | 
Pages: 1
Prev: tracking changes in excel in an unshared workbook
Next: Multiple lists in a cell