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...
|