View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeremy Jeremy is offline
external usenet poster
 
Posts: 5
Default saving fcell contents in a separate list

Can anyone help.

I have a spreadsheet containing information on one
customer in several cells. this spreadsheet is used for
each new customer contact. I would like to save the info
in this documnet in a separate spreadsheet with all the
cell information in one row as shown below.

Document 1

Customer: Cust 1

info 1 info 3

Info 2 info 4


Document 2


Cust 1 info1 info 2 info 3 info 4
Cust 2 info1 info 2 info 3 info 4
Cust 3 info1 info 2 info 3 info 4
Cust 4 info1 info 2 info 3 info 4

What I need is a progamming device on the first document
which will save the cell info into the second document in
the next availalbe row.