Code not pasting work in right cell

So I have this code below that seperately works perfectly fine together however theres a slight problem that I need help fixing.

Code Below:

Please Login or Register  to view this content.

The problem is this part of the code instead of the code

Please Login or Register  to view this content.

Instead of the code pasting the data directly under the old data in the next empty cell for some reason it is pasting the data in row 19 missing a whole load of empty cells. I can't really see whats wrong with the code, because in its own macro it works perfect. so please have a look guys

cheers romperstomper i'm relatively new to vba so is there any chance you can show me what needs changing in that code. it would be really appreciate thanks again for the reply

even though romperstomper seems to have solved the problem, i'm so new to vba that i still haven't gotta clue whats going on. so i'm gonna post again

this code below is selecting to much data in the data load sheet it should only be selecting cells that are in a2:d that have data in them. then it should copy them and paste them in the rawdata sheet. currently its copying to much so when I paste data a second time the data is not in the next empty cell

Please Login or Register  to view this content.

cheers romperstomper I was just being an idiot for a second.

It does work really well so i have no problems but out of interest why is the code still copying more cells than the data is actually in, its still copying a load of blank cells.

thanks alot romper stomper you've been great help thanks