Cell Reference Question

M

MCorrea

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy cell values if cells match on two diff sheets 0
VBA Question - Applying values 6
VBA Question Multiply vs' replace 2
Select Columns based on cell value 1
Hate DBL post but I really need help 0
Subject: VBA Question If column contains keyword 2
copying text 0
Reference Cell in custom format???? 3

Top