Major vba help needed please

[saxby146]

B	C	D	E	F	G	H	I	J
Contact details	E-mail	Activity	Quantity	Caters For per hour	Cost	Charge	Profit	Item Subtotal
Pam TEL: 07979 865526		Air Rifles		15 p/h	£260.00	£400.00	£140.00	£0
		Archery		15 p/h	£260.00	£400.00	£140.00	£0

<tbody>
</tbody>

I have a work book with 2 pages. Sheet 1(Quote Calculator) and sheet 2 (Quote)
I need to copy and paste columns D,E,H,J from the quote calculator sheet to the quote sheet with the use of a macro? however I need it to only paste when there is a value in the quantity column. The some of the cells to be copied have their own formula in them too. I hope this makes sense.
Thanks
Dan

 

[My Aswer Is This]

I will move on.

@My Aswer Is This - My revised code does not do the same thing, I used the correct column for comparison in it.

 

[JLGWhiz]

I will move on.

@My Aswer Is This - My apologies, I was referring to the wrong post. The only change I made on this one was to paste values only.

 

[saxby146]

Thanks guys I have started from scratch and your script is working perfectly now. it was my mistake not yours obvs as I have no idea what I'm doing, many thanks!! very happy.