Need macro copy above cell to current
 

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.

Need macro copy above cell to current
 

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.

Need macro copy above cell to current
 

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.

Need macro copy above cell to current
 

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