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
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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:
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,024
Members
448,543
Latest member
MartinLarkin

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
Back
Top