data in new row

[wessie3000]

Ok this has probably been asked a thousand times. But i just cant figure it out.
Its probably fairly simple, as usual and in the end ill probably say"Ah yes of course"

I need a button that puts data in an other sheet, on a new empty row.

Ive seen it several times and i just need a clean example.

Thanx thanx thanx

[Richard Buttrey]

Hi, and welcome to the forum.

Maybe

Please Login or Register  to view this content.

[wessie3000]

Aha yes that works. Thanx for that.
But how does it work?
Why ("A1:Z1")
And the second line. What exactly does it do?

[wessie3000]

Oh i understand the first line of course.

[Richard Buttrey]

The second line finds the next available cell after the last value in column A on sheet 2 and pastes as values the stuff that has been copied from A1:Z1 on sheet1

[wessie3000]

But what does the cell(2, 1) do?