VBA Code Copy/ paste from one sheet, then again copy/paste to another sheet which has a table

[DanielFran]

Hi,

I need help to write a vba code for the following:

In 'Sheet 2' there are columns A - K (and data is on row 5), so I need specific columns to be copied and pasted into 'Sheet 3'

So in ' Sheet 3':
Col A - will paste data from 'Sheet 2' Col A
Col B - will paste data from 'Sheet 2' Col B
Col C - will paste data from 'Sheet 2' Col J
Col D - will paste data from 'Sheet 2' Col E

Now, in 'Sheet 1' Columns A-K and data is in row 7 but this is a TABLE, so in sheet 1 the following to happen:
Col A - will paste data from 'Sheet 3' Col A
Col B - will paste data from 'Sheet 3' Col B
Col D - will paste data from 'Sheet 3' Col C
Col E - will paste data from 'Sheet 3' Col D

Then to clear contents in sheet 2 Col A-K ( data from row 5) and 'Sheet 3' Col A-D (data from row 5)

Kind Regards,
Dan