copy and paste data to another workbook vba

hi, i have this code,is a code for copy and paste in another workbook but i dont know how to select all the data that i will write and then copy and paste in another workbook. please help me with my code

Please Login or Register  to view this content.

Hi,

I think that your problem is here:

Please Login or Register  to view this content.

Try running your code without the .Select

yeah thats one of my problems but do you know how can i select all the written data and then paste it into another workbook . after try many times i just select a range, but then another problem appears because first i copy in one sheet and after that in another and in the last sheet it select the range of the other sheet and write there and i dont know how to fix that

Please Login or Register  to view this content.

Select your sheet first i.e.

Please Login or Register  to view this content.