copy data and paste it in another sheet

[newbie2]

pls help

http://www.mrexcel.com/forum/excel-q...worksheet.html

[bakerman]

Tested both solutions given too you on mrexcel and they both work fine for me.
AlphaFrog's solution only misses the columheaders, Kenneth Hobson has wrong positioning but apart from that they do exactly what you asked for.

So what isn't working for you ?