How do I reference a range of cells depending on another cell valu
 

What I am trying to do is write a formula that can be used on a number of my
spreadsheets and will manipulate a range of data. However the length of this
range of data varies from sheet to sheet so I want to be able to plug a value
into a reference cell that will modify the range that this formula is
referencing. Is this possibile and if so how do I do it?

An alternative route that might suffice would be something like the offset
function IF I could modify the degree of offset based on a value plugged into
a reference cell.

Many thanks for your help, this is definately slowing me down!

How do I reference a range of cells depending on another cell valu
 

Could you use a derivative of this OFFSET and COUNTA Function on Debra's
website?

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk




"batkinson" wrote in message
...
What I am trying to do is write a formula that can be used on a number of
my
spreadsheets and will manipulate a range of data. However the length of
this
range of data varies from sheet to sheet so I want to be able to plug a
value
into a reference cell that will modify the range that this formula is
referencing. Is this possibile and if so how do I do it?

An alternative route that might suffice would be something like the offset
function IF I could modify the degree of offset based on a value plugged
into
a reference cell.

Many thanks for your help, this is definately slowing me down!