Hi
just to see if i understand correctly - you have
A H
1 100
2
3 500
4
5 200
you want to see
A H
1 100 100
2 500
3 500 200
4
5 200
and then when they add 700 into A2 you want it to go to H4, e.g.
A H
1 100 100
2 700 500
3 500 200
4 700
5 200
if this is what you're after i don't know of any way of achieving it ..
maybe someone else will have an idea.
sorry
JulieD
"smanuel" wrote in message
...
I still get blanks though and I am looking for a formula to use so that
you can pull the formula down using the filler so that when they add
more data to that column, it automatically fills in.
Thanks though
--
smanuel
------------------------------------------------------------------------
smanuel's Profile:
http://www.excelforum.com/member.php...o&userid=16337
View this thread: http://www.excelforum.com/showthread...hreadid=277237