excel 2003
I'm trying to create a spreadsheet with customer information, and I need to
print out a profile sheet where all the information gets feed into.
Action taken:
1. created a spreadsheet to input information.
2. created a second spreadsheet - formated for "printing" individual
customer info. The information from the first spreadsheet gets fed into this
second sheet.
This is working but...
My question is:
How can I keep the exisitng info and just go down the row, adding new
information?
In anthoer words...I'd like to keep a master list of customers at the same
time.
Coded on the 2nd sheet: =(spreadsheet1!A2) for last name,
=(spreadsheet1!A3) for first name and so on.
I'm very new to excel 2003 and any tips will help. Thank you.
|