Jan Feb Mar
A1 A5 A5 A5
A2
A3
A5=Sum(A1:A3)
At the end of Jan, how can I make A5 not change so in Feb there will be new
numbers ?
Jan Feb Mar
A1 A5 A5 A5
A2
A3
A5=Sum(A1:A3)
At the end of Jan, how can I make A5 not change so in Feb there will be new
numbers ?
copy -> paste special -> values
"Tony Guzzo" <[email protected]> wrote in message
news:[email protected]...
: Jan Feb Mar
: A1 A5 A5 A5
: A2
: A3
: A5=Sum(A1:A3)
:
: At the end of Jan, how can I make A5 not change so in Feb there will be
new
: numbers ?
Your question doesn't convey a sense of what problem you are trying to
solve.
- Are you asking about a timing trigger that will fire at the end of each
month?
- Are you asking how to write an Excel macro?
- Are you asking how to write VBA code?
???
Luke
"Tony Guzzo" <[email protected]> wrote in message
news:[email protected]...
> Jan Feb Mar
> A1 A5 A5 A5
> A2
> A3
> A5=Sum(A1:A3)
>
> At the end of Jan, how can I make A5 not change so in Feb there will be
new
> numbers ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks