trying to make it do this

lets say that cell a1 has an account number and a2 has nothing, when an
ammount is placed in cell a2 i want cell C3 to have a1's account number
and cell c4 to have the amount in a2

i have to do this for about 100 cells, so i dont think i can use IF.

any help would be great,

thanks
Mark


--
mark petrak
------------------------------------------------------------------------
mark petrak's Profile: http://www.excelforum.com/member.php...o&userid=26804
View this thread: http://www.excelforum.com/showthread...hreadid=400572