Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a range area referred anywhere and repeatively on a new worksheetpage
Hi
I have a grid / table which has prices on which i wish to do calculations on so i entered the information and then named it as a range pricegrid (pricegrid refers to cells between (a1:d26)) I then create a new worksheet which i wish to refer to pricegrid on the same page. if i am refer to =pricegrid on the next worksheet and the rows and columns exactly aligns with the value everything works i now want to move to a14 and want to use =pricegrid it will show value as it cant display in a different area i presume i can use the offset function but how can i create value on the first weeksheet which will identify the parameter to use in the offset command is this the best way ?? i am not too sure on the syntax of the offset command but for the example would it be something like this =offset(pricegrid,1,1,4,26) in the example given ? thank you for any replies to point me in the right direction thanks Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Range area within VLookup? | Excel Worksheet Functions | |||
Print Area as dynamic range? | Excel Worksheet Functions | |||
How do i return data in a cell from the referred cell? | Excel Worksheet Functions | |||
Conditional format but referred from other cell | Excel Discussion (Misc queries) | |||
Print area/range | Excel Discussion (Misc queries) |