Single Range - Reference Repeated On a Single Sheet

devouk

New Member
Joined
Nov 3, 2007
Messages
5
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
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

devouk

New Member
Joined
Nov 3, 2007
Messages
5
checked the links and will just add them as a text links if anyone wants to try

in office 2003 and 2007 format ..

Code:
http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xls
Code:
http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xlsx
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,851
Messages
5,598,452
Members
414,240
Latest member
xnanx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top