linking cells

  • Thread starter Peter (The irish paddy)
  • Start date

P

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.
 
Ad

Advertisements

K

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.
 
Ad

Advertisements

P

Peter (The irish paddy)

Hi Khoshravan,

Thanks for you help on this.

all the best

cheers

peter
 

Top