Grabbing data from one sheet and moving it to a specific location in another sheet

Good afternoon.

I am currently working with a VBA heavy project and I have run into an issue that I am not quite able to work through.

In one sheet I have a table containing data like this,

columns A B C D


01/04/2020 Name Value SWF
01/04/2020 Name Value SWF
01/04/2020 Name Value SWF
01/04/2020 Name Value SWF
01/04/2020 Name Value SWF
01/04/2020 Name Value SWF
01/04/2020 Name Value SWF
01/04/2020 Name Value SWF



I want to achieve the following.


IF column D contains the text "SWF" select column D C and B and copy

Paste the three columns of data to sheet "Fixed Point" in column H row 3

Repeat for any remaining rows in the first sheet pasting a row down in the target sheet.

This is my code

Please Login or Register  to view this content.

Whilst it appears to grab the correct data it pastes the data always into cell B2 C2 and D2 in the target sheet (Not H3, I3 and J3 like I'm intending) and then overwrites the same cells with the next line of data and so on. So I am left with the last row of data from the source sheet pasted into cells B2 C2 and D2 instead of a nice list of all the values I require in H, I, J 3 - 10.


Can anyone help me with what I am doing wrong?


From testing it seems that its the following section that needs tweaking to put the data in column H row 3, I just cant seem to make it work.

Please Login or Register  to view this content.

Kind regards

Jon

Assuming there is a header...

Please Login or Register  to view this content.

..........................................
Thanks.gif