move data from multiple cells in one row to another
 

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?

And what happens when B2 is NOT empty?
*******************
~Anne Troy

www.OfficeArticles.com


"KUMPFfrog" wrote in message
...
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?

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?