I think you're going to have to post a workbook that actually contains some data, including examples showing what the problem data look like before and after processing. All that's in your present attachment is a bunch of formulae and nothing to relate them to.

Re:
You also need to explain how changing anything in column C could affect columns M-P, since the data in those columns are manual inputs.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]