Hi guys, a newbie here....Is it possible for the following?

Into cell M9
If cell G6 is blank insert into cell M9..cell A6,
OR
if cell G7 is blank insert into cell M9 ...cellA7
OR
if cell G8 is blank insert into cell M9 ...cellA8

Any help appreciated


milton


--
miltont
------------------------------------------------------------------------
miltont's Profile: http://www.excelforum.com/member.php...o&userid=25345
View this thread: http://www.excelforum.com/showthread...hreadid=388253