I have two cells that both have text in them. Cell A2 contains the old
status. Cell B2 contains the new status. I'd like to keep the history of
the old status and update it with the new status on top. So cell A2 will now
look like:
5/6 New Status
4/20 Old Status

Can this be done? I'm using Excel 2003. I'm guessing it will be VBA code
but don't know what it will say. Thanks.

=A1 & " Old status" and copy paste special - values to keep the value
static.



--
Regards
Dave Hawley
www.ozgrid.com
"Nadine" <(E-Mail Removed)> wrote in message
news:381946A0-82EA-411C-BC66-(E-Mail Removed)...
>I have two cells that both have text in them. Cell A2 contains the old
> status. Cell B2 contains the new status. I'd like to keep the history of
> the old status and update it with the new status on top. So cell A2 will
> now
> look like:
> 5/6 New Status
> 4/20 Old Status
>
> Can this be done? I'm using Excel 2003. I'm guessing it will be VBA code
> but don't know what it will say. Thanks.

I'm looking for something that can be done more automatically. I can easily
do this as a more manual step but I'm looking for something that will do it
for all the 1000+ rows I have. Any ideas? Thanks so much for responding.

"ozgrid.com" wrote:

> =A1 & " Old status" and copy paste special - values to keep the value
> static.
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "Nadine" <(E-Mail Removed)> wrote in message
> news:381946A0-82EA-411C-BC66-(E-Mail Removed)...
> >I have two cells that both have text in them. Cell A2 contains the old
> > status. Cell B2 contains the new status. I'd like to keep the history of
> > the old status and update it with the new status on top. So cell A2 will
> > now
> > look like:
> > 5/6 New Status
> > 4/20 Old Status
> >
> > Can this be done? I'm using Excel 2003. I'm guessing it will be VBA code
> > but don't know what it will say. Thanks.
>