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

B

batkinson

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Code to format cells on several worksheets 2
External cell reference between two excel worksheets both in One Drive 0
how can I lock/unlock a range of cells depending on state of a checkbox? 4
Vlookup cell reference 6
format cells depending on value range 5
How do I reference one OR another worksheet? 2
Word macro that can call cells out of Excel for a find and replace 0

Top