Hi, im super rubbish at writing macros and i was hoping an expert here could help

I need a macro so that when i type a number in a cell P6 and press enter, it copies that number, clears the cell P6, and inserts it in R6, pushing all the prior numbers i have in the row (R6,R7,R8 etc) to the right. I require this macro so that i dont have to manually copy, insert, and choose 'shift cells right' from the insert option, as im constantly updating cell P6 throughout the day with a new value.

I actually have to update the entire column P with new values during the day, so i would require this work down the whole column, inserting in the corresponding cell into column R (P6 to R6, P7 to R7 etc...)

Appreciate if someone could help.... Going to make my life at work alot easier!!

Thnx