Single Range - Reference Repeated On a Single Sheet

[devouk]

Hi All

I wonder if someone could please help me solve this issue, I have asked on some of the newsgroups and had no replies or people who think they can solve it and never getting back to me.. might be an ego thing

What i am trying to do is

I have a table price grid for a product let say sheet 1 a1:g19
I name this as ref_pricelist

On sheet2

I want to show variations of ref_pricelist with additional formula to be applied to that original range

I know that if i use =ref_pricelist and the cells start and finish exactly at the same row and col reference i can use that.

Sorry it may not be the clearest but i do have an example of what i am trying to do .. which can be downloaded from

http://www.bradrail.co.uk/uploads/pricelistexampleprices.xls

it shows the a sheet with the problem and then a working example but using cell references to show an idea

please can some one point me in the right direction to refer to a range anywhere repeatively on sheet which is not is the perfect overlay location

i been trying to play with indirect, offset etc.. just starting to look at address but not too sure what i should be using

pleased to hear from anyone who can point me in the right direction

thank you

 

[xld]

I got a page doesn't exist error.

 

[devouk]

ooops sorry about that missed out a backslash

http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xls

hope that helps

 

[zia.butt]

there is error on page,
can u send file on this mail: zia.butt@alqaddar.com

 

[devouk]

checked the links and will just add them as a text links if anyone wants to try

in office 2003 and 2007 format ..

http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xls

http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xlsx