Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have to change a bunch of formula that need to reference a different workbook.
The one workbook will have a price list the other will have all the quote
sheets. At first I had a page with the mark ups and hourly rate in the first workbook that they were used on another page to mark up the products. But I realized that this wouldn't work because an changes in the first book would make those changes to the other work books when they got opened - creating a huge can of worms so no I need to move the control sheet to the quote work book. But this will mean changes all the formula a very time consuming and tedious process. Can I set up the formula in the control worksheet and have it as a cell reference effect the contents of that cell. This is one of the formulas that I need to use: =IF(Questionaire!$F$16=1,I1073,IF(Questionaire!$F$ 16=2,I1073*'Look up tables'!$D$9,IF(Questionaire!$F$16=3,I1073*'Look up tables'!$D$10,IF(Questionaire!$F$16=4,I1073*'Look up tables'!$D$11,IF(Questionaire!$F$16=5,I1073*'Look up tables'!$D$12,IF(Questionaire!$F$16=6,I1073*'Look up tables'!$D$13,IF(Questionaire!$F$16=7,I1073*'Look up tables'!$D$14,IF(Questionaire!$F$16=8,I1073*'Look up tables'!$D$15,"")))))) )) Any suggestions? Marc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change a tab name with cell reference and formula? | Excel Worksheet Functions | |||
circular reference formula | Excel Discussion (Misc queries) | |||
Change sheet reference in new workbook | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |