Transfer data from sheey1 to sheet2

[IRMA MENDOSA]

Is there a way to transfer data from sheet1 into sheet 2
sheet2 is the database in which I store data coming in from sheet1, C1 is for the customers name, C2 is fro the costumers telephone number, C3 is for the Costumers Zip code
what I need this to do is transfer the data into the last empty row , for saying name in A1, telephone in B1 Zip Code in C1

When this is done use same sheet1 to write another costumer information to insert in the last empty row of sheet2 for saying name in A2, Telephone in B2, Zip code in C2 Etc.

I do not know if this is possible
Thanks in advance

 

[Tom Ogilvy]

worksheets("Sheet1").UsedRange.copy _
Destination:=Worksheets("Sheet2").Cells(rows.count,1).End(xlup)(2)

--
Regards,
Tom Ogilvy


Is there a way to transfer data from sheet1 into sheet 2
sheet2 is the database in which I store data coming in from sheet1, C1 is
for the customers name, C2 is fro the costumers telephone number, C3 is for
the Costumers Zip code
what I need this to do is transfer the data into the last empty row , for
saying name in A1, telephone in B1 Zip Code in C1

When this is done use same sheet1 to write another costumer information to
insert in the last empty row of sheet2 for saying name in A2, Telephone in
B2, Zip code in C2 Etc.

I do not know if this is possible
Thanks in advance