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.