continue on next column

[ZairuZ]

i dont know if someone ask the same problem i have

I have input number on B8(46) and B9(91) and their sum on B10 then minus the sum to input number on B11(129) equal is on B12. now my problem is I want the result of the sum and minus on B12 column to be copied on the C8 column then repeat the same process of B on C column continued to D column and so on.. but rows 9 and 11 are to be input manually.

i have to fill 30 column of these process exempting the B8 column which is inputted manually then the next column is from the result of the sum and minus.

 

[Andrew Poulsom]

Welcome to MrExcel.

Can you post up some sample data please? To post a snapshot of your data put borders around it, copy it in Excel and paste it into a reply. You need to select 'Enhanced Interface - Full WYSIWYG Editing' in 'Message Editor Interface' under User CP|Edit Options (menu towards top of screen on Board).

 

[ZairuZ]

Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5 6 7 8 9 10 11 12 13
46 8 8 8 8 8 8 8 8 8 8 8 8
91
137 8 8 8 8 8 8 8 8 8 8 8 8
129
8 8 8 8 8 8 8 8 8 8 8 8 8

cant get the border
the input 46 is in B8.. thx in advance!

 

[Andrew Poulsom]

So is it:

=B12

in C8, copied across?

 

[ZairuZ]

yes sir the final answer which is in B12 will be transfer to C8 then i will input different data in C9 and C11 and so on.. my problem is that is it possible that everytime I put an input the succeeding rows of 8, 10 & 12 will not preview the answer even it has still no input on it. Like the 8's in the three rows.. which is copied from the last answer which is in B12..

 

[Andrew Poulsom]

You could use a formula like:

=IF(ISNUMBER(C9),B12,"")

 

[ZairuZ]

where exactly should i put this formula? thx.

 

[Andrew Poulsom]

In C8, copied across.

 

[ZairuZ]

thanks a lot sir! done it! :D