Hi Devin,

Formulae can only fill the cells they're in - not another cell. So, unless you put an appropriate formula in each of your blank cells, you'll not be able to achieve your goal without vba.

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