I need a cell to copy the above cell and paste into the current cell.
It would also help if It could append " P/O" at the end of the newly pasted
cell.

It might be simple, but I am having a hard time trying to make this work.
Any help would be greatly appreciated.

One way:

ActiveCell.Value = ActiveCell.Offset(-1, 0).Value & " P/O"


"Mikey B" wrote in message
...
I need a cell to copy the above cell and paste into the current cell.
It would also help if It could append " P/O" at the end of the newly
pasted
cell.

It might be simple, but I am having a hard time trying to make this work.
Any help would be greatly appreciated.

activecell.Value = Activecell.Offset(-1,0).Value & " P/O"

--
Regards,
Tom Ogilvy


"Mikey B" wrote:

I need a cell to copy the above cell and paste into the current cell.
It would also help if It could append " P/O" at the end of the newly pasted
cell.

It might be simple, but I am having a hard time trying to make this work.
Any help would be greatly appreciated.

Thanks Tom O. and PCLIVE for your quick answers.

It works perfectly.
It makes sense, I just did'nt know the vocabulary.

Thanks again for the help