Paste Special over Hundreds of Data Points

[eugchen]

this is what im trying to do in a simple way. ill send you a diagram with explanation.

Section A is data that im trying to imput into section B one at a time, in cell C6. so for instance, you enter in Houstons data on section A, which is 6 into C6. the total is then 21, as shown in the yellow. then i want this number recorded in value on section C, before changing C6 to the next city, which is Dallas, at 4. then you put in the 4 in C6 for dallas, and the total is 22. then i want the 22 put in the blue section. i want this all automated if possible, cause i have hundreds of data to put in and get the results all put in section C if possible. i have tried to record a macro of this, but since i have so much data, the macro failed, and said was too large.


Capture.JPG

[Gregb11]

Is the list in "C" going to be the same list in "A" (in same order?)? Why plug the value into "B" if you know the total will always be the same sum plus what's in COL J? There's probably much more to it than you showing, but in the spreadsheet I attached you could enter formulas into E14 and F14 and copy the down as far as you need to go. I'm sure there are more particulars you haven't expressed yet.
(so in E14, you could enter:
="Total with "&I1
and in F14 enter:
=$C$6+J1)

[eugchen]

Is the list in "C" going to be the same list in "A" (in same order?)? Why plug the value into "B" if you know the total will always be the same sum plus what's in COL J? There's probably much more to it than you showing, but in the spreadsheet I attached you could enter formulas into E14 and F14 and copy the down as far as you need to go. I'm sure there are more particulars you haven't expressed yet.
(so in E14, you could enter:
="Total with "&I1
and in F14 enter:
=$C$6+J1)

greg, thanks for your response. yea, my real sheet is more complicated and not a simple addition issue. sorry about that. i didnt want to bog people down with the complexities of the sheet.

but the basic thing i am wondering is if there is a way to utilize the "paste special value" function, then utilize again and again in an automated fashion without recording a macro. is there some formula i can put in F14, F15, F16 that can paste special automatically?

[Gregb11]

is there some formula i can put in F14, F15, F16 that can paste special automatically?

I don't know what you mean by this. What steps are you wanting to take. You enter data in section A. What's the next step and result you want?
What I uploaded allows you to enter data in Section A, and automatically updates Section C.