refering to a name range area as a reference value multiple times ona worksheet at different locatio

[Blinds Nottingham]

i was wondering if i had posted this in the right section as it could
apply to both

please could you take a look at the following post

http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/f088a5737dd26570

thank you

 

[Don Guillett]

Is there some reason you can't post your question here instead of asking us
to look elsewhere?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
message
news:[email protected]...

 

[Blinds Nottingham]

Hi

Sorry didnt want to be accused of cross posting ... !!


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

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Blinds Nottingham]

hi don

where you able to get everything you needed

thanks

nick