How do I create If/Then Macros contingent on cell values?
 

I have a workbook that is used for building cost worksheets for job
proposals. Some of the "product" is located on different sheets in the
workbook with formulas to build "costs" and insert them on the front "Quote"
page. The problem is that I have to manually copy/paste every item that I
put a quantity in to the "quote" page. Is there a way to make Excel
Automatically do this?

How do I create If/Then Macros contingent on cell values?
 

Excel formulas can refernce from one sheet to another
=sheetname!celladdress

quote sheet shows count of A
on sheet Acosting =Quote!B5
will pull the quantity from b5

then back on Quote
=ACOSTING!G32 pulls the total A cost from cell G32

"tbonescott" wrote:

I have a workbook that is used for building cost worksheets for job
proposals. Some of the "product" is located on different sheets in the
workbook with formulas to build "costs" and insert them on the front "Quote"
page. The problem is that I have to manually copy/paste every item that I
put a quantity in to the "quote" page. Is there a way to make Excel
Automatically do this?