move data from multiple cells in one row to another

K

KUMPFfrog

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?
 
G

Gord Dibben

Formulas can only return values.

They cannot "move" data.

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


Gord Dibben Excel MVP
 
Top