Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with formula
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with a formula | Excel Discussion (Misc queries) | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |