linking cells
 

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.

--
cheers

peter

linking cells
 

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.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Peter (The irish paddy)" wrote:

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.

--
cheers

peter

linking cells
 

Hi Khoshravan,

Thanks for you help on this.

all the best

cheers

peter


"Khoshravan" wrote:

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.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Peter (The irish paddy)" wrote:

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.

--
cheers

peter