Help, Copy and paste last row data to last row another sheet

[englandmark]

Hi all,
I need a code
if criteria is met with new entry
last row entry
Copy text data from cell
to last row of another sheet

example

New entry in worksheet ("Shop") Column a "Car" is selected
Copy and paste Column f
to
next blank row column ("D") of worksheet ("Report")
then return to worksheet ("Shop")

thanks in advance guys

 

[Logit]

.
Your post say ROW but it appears you are wanting to copy a COLUMN ?

Please unconfuse me ...

 

[englandmark]

? I need to copy the cell in the last row not the whole row , I said column because the row number is always adding

 

[englandmark]

Hope this is clearer
If car is selected from a drop box on sheet 1 last entry
Another cells data on same row is copied to a cell on sheet 2 next blank row
Then return to sheet 1