View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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.