linking cells

[Peter (The irish paddy)]

Hi Folks,

I have created a quot so I can enter the number of Radiator vs. no of
thermostats and I get an overall price.
I would like to create a second page which lists the number of Rads across
the top and the Number of thermostats down the side, can I set up in Excel
that it fills in the price on this second sheet.

 

[Khoshravan]

For creating a quot, do you use a lookup function?
As a general solution, for these kind of tables, making a pivot table is
better.
Look in Google or Excel help for Pivot table.

 

[Peter (The irish paddy)]

Hi Khoshravan,

Thanks for you help on this.

all the best

cheers

peter