input data and automatically move to next row
 

What I have is a price list with the name of the customer. What I want to do
is after inputing the customer info, copy the name and address to a separate
sheet in a separate cell automaticlly inputing that info in a separate cell,
as well as recall that info in the customer info section on the first page.
Example sheet 1 row 1 col a-d (cust info)
row 2 col a-d (cust info)
row 3 col a-d (cust info)...
copy to sheet 2 row 1 col a-d (copy cust info)
row 2 col a-d (copy cust info)
row 3 col a-d (copy cust info)
respectively...

input data and automatically move to next row
 

If you want to create a link between the cells on the different
worksheets, all you need to do is in the destination cell, hit the =
(equals), then click on the origin worksheet, and select the origin
cell.


holypractice102 wrote:
What I have is a price list with the name of the customer. What I want to do
is after inputing the customer info, copy the name and address to a separate
sheet in a separate cell automaticlly inputing that info in a separate cell,
as well as recall that info in the customer info section on the first page.
Example sheet 1 row 1 col a-d (cust info)
row 2 col a-d (cust info)
row 3 col a-d (cust info)...
copy to sheet 2 row 1 col a-d (copy cust info)
row 2 col a-d (copy cust info)
row 3 col a-d (copy cust info)
respectively...