Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
I am trying to if statements that take information from sheet 1 and transpose
it on to sheet 2. I want to keep the formulas for other worksheets as this going to be used as a template for about 200 worksheets. How do I do this without having the formula always reference the original worksheet in the formula when bring it over. For example the formula looks like this: =IF(Sheet1!AZ33=0,Sheet1!AF33,Sheet1!AZ33) Then when I copy it over it looks like this: =IF('[Bank of Nova Scotia bord id 200.xls]Sheet1'!AZ33=0,'[Bank of Nova Scotia bord id 200.xls]Sheet1'!AF33,'[Bank of Nova Scotia bord id 200.xls]Sheet1'!AZ33) I need help as this problem could cause serious time problems for me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
George
One way is to change the formulas so they aren't formulas before you copy them, then change them back after you paste them into the other sheet. For example, in your template sheet, click on Edit - Replace. In the block for what to replace put "=". In the block for what to replace it with put "George=". Now copy and paste the formulas as you wish. Then go into the paste sheets and replace (Edit - Replace again) the "George=" with "=". If you have a prohibitive number of sheets you need to do this with, and if you are familiar with macros, you might record a macro for the task. Post back if you want to go the macro route and you need further help. HTH Otto "George" wrote in message ... I am trying to if statements that take information from sheet 1 and transpose it on to sheet 2. I want to keep the formulas for other worksheets as this going to be used as a template for about 200 worksheets. How do I do this without having the formula always reference the original worksheet in the formula when bring it over. For example the formula looks like this: =IF(Sheet1!AZ33=0,Sheet1!AF33,Sheet1!AZ33) Then when I copy it over it looks like this: =IF('[Bank of Nova Scotia bord id 200.xls]Sheet1'!AZ33=0,'[Bank of Nova Scotia bord id 200.xls]Sheet1'!AF33,'[Bank of Nova Scotia bord id 200.xls]Sheet1'!AZ33) I need help as this problem could cause serious time problems for me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |