software

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.

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 quot;=quot;. In the block for what to replace it with put
quot;George=quot;.
Now copy and paste the formulas as you wish. Then go into the paste sheets
and replace (Edit - Replace again) the quot;George=quot; with quot;=quot;.
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
quot;Georgequot; gt; wrote in message
...
gt;I am trying to if statements that take information from sheet 1 and
gt;transpose
gt; it on to sheet 2. I want to keep the formulas for other worksheets as
gt; this
gt; going to be used as a template for about 200 worksheets. How do I do this
gt; without having the formula always reference the original worksheet in the
gt; formula when bring it over. For example the formula looks like this:
gt; =IF(Sheet1!AZ33=0,Sheet1!AF33,Sheet1!AZ33)
gt; Then when I copy it over it looks like this:
gt; =IF('[Bank of Nova Scotia bord id 200.xls]Sheet1'!AZ33=0,'[Bank of Nova
gt; Scotia bord id 200.xls]Sheet1'!AF33,'[Bank of Nova Scotia bord id
gt; 200.xls]Sheet1'!AZ33)
gt; I need help as this problem could cause serious time problems for me.