| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total a column contingent upon the cell to the right being non-bla | Excel Worksheet Functions | |||
| Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
| Cell has several values how to create new rows | Excel Worksheet Functions | |||
| IF function contingent upon cell not being blank | Excel Worksheet Functions | |||
| FORMULA TO MAKE CELL COLOR CONTINGENT | Excel Discussion (Misc queries) | |||
Hybrid Mode
