D
dujo.malbasa
Hello everybody,
Please help me on my problem, I am new to macro definition so don't be
surprised if I don't know some essentials. Well, I took some online
tutorials, and tried to learn macros myself, but it is more difficult
job that I thought it will be. Any advices are welcome.
Here is my problem:
I have multiple existing data in my worksheet, workbook, same thing. I
would like to have an option by clicking on various buttons to make a
list in new sheet or workbook.
In fact I don't know how to make order to paste copied data bellow in
last empty row.
For example:
Sheet1 A B C D
1 e f 3 d
2 g l 6
3 d 6 2
Sheet2 A B C D
1 z h f l
2 5 5 5
3 g h 3
4 d 6 2
ecc. ->different number of rows occupied
In sheet3 I have buttons to call different sheets to be listed one
bellow other in Sheet4- for these two it should be like:
Sheet4 A B C D
1 z h f l
2 5 5 5
3 g h 3
4 d 6 2
5
6 z h f l
7 5 5 5
8 g h 3
9 d 6 2
Thanks a lot in advance!
Best regards,
Dujo
Please help me on my problem, I am new to macro definition so don't be
surprised if I don't know some essentials. Well, I took some online
tutorials, and tried to learn macros myself, but it is more difficult
job that I thought it will be. Any advices are welcome.
Here is my problem:
I have multiple existing data in my worksheet, workbook, same thing. I
would like to have an option by clicking on various buttons to make a
list in new sheet or workbook.
In fact I don't know how to make order to paste copied data bellow in
last empty row.
For example:
Sheet1 A B C D
1 e f 3 d
2 g l 6
3 d 6 2
Sheet2 A B C D
1 z h f l
2 5 5 5
3 g h 3
4 d 6 2
ecc. ->different number of rows occupied
In sheet3 I have buttons to call different sheets to be listed one
bellow other in Sheet4- for these two it should be like:
Sheet4 A B C D
1 z h f l
2 5 5 5
3 g h 3
4 d 6 2
5
6 z h f l
7 5 5 5
8 g h 3
9 d 6 2
Thanks a lot in advance!
Best regards,
Dujo