Circular referencing

[PCAIT]

The good people at MrExcel.com has been super helpful in other problems I've come across (alternating shady rows, copying sheets within a workbook, for example), and now I have a big one. Currently I'm updating 3 columns manually, and it's a total waste of time.

I have columns A, B, and C.
B and C contain numbers.
When I put a number in A, I want it added to B and C, and the new sum displayed in B and C.

I've read and watched several videos, but nothing quite how I want it, and I couldn't get them to work.

Is this possible?

Thanks so much for any help!
J

 

[Ron Coderre]

If you don't mind doing a little...ahem..."work"..
Using this sample data in A1:C5:

<tbody>
[TD="align: right"]10[/TD]
[TD="width: 64, align: right"]1[/TD]
[TD="width: 64, align: right"]100[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]200[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]300[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"]400[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]500[/TD]

</tbody>

● Copy A1:A5
● Select C1:C5
● Paste_Special...Values...Add
..Press ENTER

These will be the results:
[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 64, align: right"]10[/TD]
[TD="width: 64, align: right"]11[/TD]
[TD="width: 64, align: right"]110[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]310[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]510[/TD]
[/TR]
</tbody>[/TABLE]

Is that something you can work with?

 

[PCAIT]

If you don't mind doing a little...ahem..."work"..
Using this sample data in A1:C5:

<tbody>
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD="width: 64, align: right"]100[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]200[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]300[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"]400[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]500[/TD]

</tbody>

● Copy A1:A5
● Select C1:C5
● Paste_Special...Values...Add
..Press ENTER

These will be the results:
[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 64, align: right"]10[/TD]
[TD="width: 64, align: right"]11[/TD]
[TD="width: 64, align: right"]110[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]310[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]510[/TD]
[/TR]
</tbody>[/TABLE]

Is that something you can work with?

I can totally work with that! Thank you so much!
Is there anything Excel can't do? lol