Transferring cell values from worksheet to another

[Phoenix_Turn]

Hi all,

I was wondering at the moment, In worksheet 1: "Sheet1", there are 3 columns of values.

In worksheet 2: there are existing values with also too 3 columns.

Now, if a button is clicked, the values of worksheet 1, are then copied below the existing data in "Sheet2".

Was wondering is there any instructions using vba to do so using loops, the offset function?

Thank you!

Edit: Here's an example:

In sheet1:

A B C
1 Cat Cow Dog

2 Pig Sow Bird

3 Tiger Hamster Ant


For sheet 2, here are the existing data:

A B C
1 Lizard Termite Mosquito

2 Snail Slug Gorilla

3 Tiger Hamster Ant

So sheet 1 needs to be added below sheet 2: Hence the end result is:

A B C
1 Lizard Termite Mosquito

2 Snail Slug Gorilla

3 Tiger Hamster Ant

4 Cat Cow Dog

5 Pig Sow Bird

6 Tiger Hamster Ant

 

[Phoenix_Turn]

Heres a better view


Edit: Here's an example:

In sheet1:

A B C
1 Cat Cow Dog

2 Pig Sow Bird

3 Tiger Hamster Ant


For sheet 2, here are the existing data:

A B C
1 Lizard Termite Mosquito

2 Snail Slug Gorilla

3 Tiger Hamster Ant

So sheet 1 needs to be added below sheet 2: Hence the end result is:

A B C
1 Lizard Termite Mosquito

2 Snail Slug Gorilla

3 Tiger Hamster Ant

4 Cat Cow Dog

5 Pig Sow Bird

6 Tiger Hamster Ant

 

[Phoenix_Turn]

bump