Formula help needed
Hi:
I have a spreadsheet that needs to capture some basic information
(name, street, city, etc.) from a form that individuals are filling
out.
The form is in Excel and there is a box that has Name, Company, Street,
City, State, Zip.
Hopefully the individual will put each item on a separate line.
How do I get the information from the form onto the spreadsheet? There
is a column for each field; however, the sheet is already divided into
companies. It would be nice to have a formula put each person under
the correct company.
Any help would be appreciated.
Thanks!
cheetah
|