Formulas can only return values.

They cannot "move" data.

You would need VBA code to achieve the actual "moving".


Gord Dibben Excel MVP

On Tue, 19 Jul 2005 12:55:03 -0700, KUMPFfrog
wrote:

I have a large file and would like a function that would, in effect, be
something like IF B2 is empty then move the data E2:L2 to E1:L1
the formula would be copied throughout the length of column D.

is this possible?