transfer data from sheet1 into sheet 2

  • Thread starter Thread starter IRMA MENDOSA
  • Start date Start date
I

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
 
Try this examples

http://www.rondebruin.nl/copy1.htm
Copy to a Database sheet with VBA



--
Regards Ron de Bruin
http://www.rondebruin.nl


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
 
Back
Top