Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
call range by cell value
I have a worksheet that I want to call data from another sheet using offset
the formula works using named ranges but the range changes by what is input by the user into certain cells. I used this formula to test it. =OFFSET(Roland,0,4)*OFFSET(Roland,0,1) Roland is the name of the range on a differenent worksheet. The value in cell b3 in the worksheet is the name of the range I want to use. -- Roland |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i call a function to a cell? | Excel Worksheet Functions | |||
How to call a cell ? | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
?? call it: general cell() ?? | Excel Discussion (Misc queries) | |||
What do I call a blank cell? | Excel Worksheet Functions |