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?