Need MSExcel 2007 Formula

[IshfaqPeerzada]

Hello, Masters of excel.
In column R5 i put =IMSUM(P5,Q5).I need the
amount of R5 to auto enter in S5 not formula & then i need S5+R6 in S6. This will be in spreadsheet, i am trying to making a template.
Thanks in anticipation.

[MrShorty]

I need the amount of R5 to auto enter in S5 not formula

I think I would need to understand why you cannot put a formula (=R5) into S5. It would certainly be possible using VBA to copy the value of R5 into S5 without the cell formula, but it seems to be so much more difficult and unnecessary than putting =R5 into S5.

& then i need S5+R6 in S6.

It seems too obvious, so I'm not sure it is right. Shouldn't S6 be as simple as =IMSUM(s5,r6)?

It seems like this pattern will create a "running" total in column S, is that correct? With the correct combination of relative and absolute references, a simple =IMSUM($R$5:R5) copied down, will create a running total (note the absolute reference). Is that what you are looking for?

[IshfaqPeerzada]

I think I would need to understand why you cannot put a formula (=R5) into S5. It would certainly be possible using VBA to copy the value of R5 into S5 without the cell formula, but it seems to be so much more difficult and unnecessary than putting =R5 into S5.

It seems too obvious, so I'm not sure it is right. Shouldn't S6 be as simple as =IMSUM(s5,r6)?

It seems like this pattern will create a "running" total in column S, is that correct? With the correct combination of relative and absolute references, a simple =IMSUM($R$5:R5) copied down, will create a running total (note the absolute reference). Is that what you are looking for?

It worked thanx a lot. I am realy thankful to you. Realy Thanx, thanx, & many many thanx.