The formula below is in column U in 8 workbooks. Each of these
workbooks has twenty worksheet tabs containing the formula in 20 blocks
of rows within each worksheet. As you can see anytime the formula (An
addition or subtraction of an account # (See below)) changes it is a
task to cut & paste to update the formula.


=IF(AND(COUNT(O18:R18)<0)*(OR($C$4=202,$C$4=2273, $C$4=6401,$C$4=12400,$C$4=12423,$C$4=12703,$C$4=23 840,$C$4=32438,$C$4=34007,$C$4=50116,$C$4=50702,$C $4=50861,$C$4=50874,$C$4=12465,$C$4=61100,$C$4=622 55)),"_____","N/A")

Is there a way to change have a Macro change the formula based on a
sheet that will list the accounts to be used in the formula & then copy
& paste the updated formula into all worksheets in all the workbooks?

Any ideas? Thanks?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/