Copy/Pasting Values from visible cells (using autofilter) to visible cells

Hello everyone,

My second question to this forum and again completely new to VBA so please bare with me..

I have a spreadsheet that I have formulas in multiple cells of a column. What I want to do is the following:

I use an autofilter to hide some of the rows and I want to copy/paste values on the same cells (only on the visible rows)!

I have found some code which does copy/paste from one column to another (only visible cells) but I don't know how to customize it to copy/paste on the same column...

Can someone please help???

I have attached a sample file so that you understand what I'm talking about.

I used the following code:

Please Login or Register  to view this content.

Which copies the visible cells from column J to the respective visible cells on column F.
This works fine and pastes the values.
Can someone please revise it so that the values are pasted on row J again instead of row F?

Your help is pretty much appreciated!

Thanx

Edit: Sorry, wrong code!