I'm attempting to setup a macro where it copies all of the info from
column F and pastes the contents (Values only) into the next available
empty column to the right (same worksheet). Therefore, each time the
data is pasted it's pulled from the same column (F) and is pasted a
column further over to the right everytime. I would like to paste only
the values of the originating cells as well, no formats or formulas.

Any help would be very much appreciated.

Regards,

Michael