Copying and pasting a series of cells

[MattBeckwith]

When I copy and paste the following cell

=IF('13'!B13>0,'13'!B13,NA())

to the remainder of the days of the month, what I get is

=IF('13'!B14>0,'13'!B14,NA())
=IF('13'!B15>0,'13'!B15,NA())
etc

But what I want to get is

=IF('14'!B13>0,'14'!B13,NA())
=IF('15'!B13>0,'15'!B13,NA())
etc

I'd even settle for

=IF('13'!B13>0,'13'!B13,NA())
=IF('13'!b13>0,'13'!B13,NA())
etc

whereafter I could just modify the formulas individually by hand.

But Excel just assumes a certain kind of translation. So I have to undo its translation and change it to the desired one.

Is there a way to override the translation effect when cutting and pasting formulas? Or ideally to modify it to go a certain way rather than another?

Thanks.

[CLR]

I don't have Excel up and running right now to test this with, but give this
a try....

=IF(13!$B$13>0,13!$B$13,NA())

Vaya con Dios,
Chuck, CABGx3



"MattBeckwith" <[email protected]>
wrote in message
news:[email protected]...
>
> When I copy and paste the following cell
>
> > =IF('13'!B13>0,'13'!B13,NA())
>
> to the remainder of the days of the month, what I get is
>
> > =IF('13'!B14>0,'13'!B14,NA())
> > =IF('13'!B15>0,'13'!B15,NA())
> > etc
>
> But what I want to get is
>
> > =IF('14'!B13>0,'14'!B13,NA())
> > =IF('15'!B13>0,'15'!B13,NA())
> > etc
>
> I'd even settle for
>
> > =IF('13'!B13>0,'13'!B13,NA())
> > =IF('13'!b13>0,'13'!B13,NA())
> > etc
>
> whereafter I could just modify the formulas individually by hand.
>
> But Excel just assumes a certain kind of translation. So I have to
> undo its translation and change it to the desired one.
>
> Is there a way to override the translation effect when cutting and
> pasting formulas? Or ideally to modify it to go a certain way rather
> than another?
>
> Thanks.
>
>
> --
> MattBeckwith
>
>
> ------------------------------------------------------------------------
> MattBeckwith's Profile:
http://www.excelforum.com/member.php...o&userid=30571
> View this thread: http://www.excelforum.com/showthread...hreadid=511550
>

[MattBeckwith]

Okay, that allowed me to copy and paste without any modifications being made. What does the dollar sign do, anyway? Thanks for the help.

[CLR]

The $ changes the cell reference form "relative" to "absolute"....

Vaya con Dios,
Chuck, CABGx3


"MattBeckwith" <[email protected]>
wrote in message
news:[email protected]...
>
> Okay, that allowed me to copy and paste without any modifications being
> made. What does the dollar sign do, anyway? Thanks for the help.
>
>
> --
> MattBeckwith
>
>
> ------------------------------------------------------------------------
> MattBeckwith's Profile:
http://www.excelforum.com/member.php...o&userid=30571
> View this thread: http://www.excelforum.com/showthread...hreadid=511550
>