input data and automatically move to next row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub to transform table into cols 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Need to add row based on column value 2
Find duplicates, sum and delete dups 2
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
saving fcell contents in a separate list 3
Excel 07 vs. 03 "listrows" reference <subscript out of range> 2
Resize a row but copy but skip columns I don't want to copy 6

Back
Top