Cell Reference Question
 

Hi,

I have a category list in sheet1! named CategoriesList=$A$1:$C$100. In
column A I insert the various categories and clumns B and C the costs and
sales prices.
In sheet2! I have:

ColA ColB ColC
ColD ColE

Dataval(CategoriesList)

Dadaval(MaterialsList;LaborList) Indirect(Bx) Quantity Cost
SalePrice
Dadaval(MaterialsList;LaborList) Indirect(Bx) Quantity Cost
SalePrice
Dadaval(MaterialsList;LaborList) Indirect(Bx) Quantity Cost
SalePrice
etc..



Total Mat. Price (=sumif...)

Total Labor Price (=sumif...)

How do I set a button that will update the category in sheet1! that
corresponds to the category chosen in sheet2! ?

Thanks,

Marcio