Copy/paste button - next blank row

I have this sheet, with information. Like this

------------
-----
------------
----------- Button

------------
-----
------------
----------- Button

------------
-----
------------
----------- Button

When i press the button i want it to copy the data, from say:
A1:A3 - J1:J3

3 Rows and 10 columns, starting from A1 or A3 or something. And paste it into Sheet 2, The same place. But next time i hit the button it will be under the cell with data. The next blank row.

If its data like this in sheet2:
First click on button. Data here:
1:-----
2:----
3:---
Data here on next click
4:----
5:----
6:-----

I have a button with this code, can you please help my with this problem?

Please Login or Register  to view this content.

Thanks:D

Hi
try the button with codes in the attached file
Ravi

Hi

Thanks so much. Just what i wanted.

Problem is, that i get an "Run time error 1004 application defined or object defined error". Any clue of what i can do to fix it?


Thanks:D