not sure what formula to use
 

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

In C3 type: =IF(A2<"",A1,"")
In C4 type: =IF(A2<"",A2,"")

Without knowing your layout for other cells to copy to I can't advise
as to Absolute Referencing but bear it in mind when adapting it to your
needs.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=400572

more info

ok if B34 has an ammount then i want B28 to have what is in A34, and
C28 to have the ammount in B34

than it goes down a list with the number of the cells increasing


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

In B28 type: =IF(B34<"",A34,"")
In C28 type: =IF(B34<"",B34,"")

If you want the formulas to go down the list in each cell then just
drag copy the formulas down as far as you need

Or if you want to put the formulas into non-adjacent cells below then
you'll have to Copy-Paste them.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=400572