Use the Find - Replace All feature
First - MAKE A BACK-UP COPY OF YOUR FILE JUST IN CASE!!!!!
Go to Edit - Find (or do Ctrl+F)
In the "Find what" area type: =IF(+data!B
Select Formulas in the "Look in" drop down list
Click on Replace
In the "Replace with" area type: =IF(+data!A
Now click Replace All
--
Cutter
------------------------------------------------------------------------
Cutter's Profile:
http://www.excelforum.com/member.php...fo&userid=9848
View this thread:
http://www.excelforum.com/showthread...hreadid=399543