I am attempting to enter the following formula using a define named or function from vba in Column J on multiple worksheets. The formula is located in about 200 locations through the workbook.

=IF(AND($C9="Red Cart",dnLocality_Rate<(VLOOKUP($D9,dnSupplement,2,FALSE))),($E9+(VLOOKUP($D9,dnSupplement,2,0)*$E9))*$F9+($H9*$I9),($E9+($E9*dnLocality_Rate))*$F9+($H9*$I9))/$B$3

Know Factors:

--the column is always Column J

--the row changes so I would need help modifying the formula to be able to recognize the specific row that the formula was on.

I would perfer to just call a function or a define name range for the formula so that when the formula is updated I do not have to physically update every location but hopefully a single location that in turn would keep the sheets updated.

Thus on the individual worksheets I could put something like =definednameformula or call a procedure.

Any suggestions are most appreciated. Thanks

Billy