Excel 2007 : Form Controls to populate multiple lines

[erickpay]

Hello,

I am trying to create a communication tracking document with several columns that will contain standardized entries from lists. As the attached document shows, column headings include Industry Sector, Employee Name, Communication Type, etc. - all with their own distinct list to chose from (e.g. Forestry/Mining/Aerospace/Transportation). Each row will contain the record of a communication contact and new rows will be filled on an ongoing basis - there will be several hundred rows in the end. I would like to have each new entry utilize drop down lists to populate each cell in the new row.

Suggestions?

Many thanks!

[protonLeah]

Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. ...

Want to get your question answered quickly?
Ensure your question is not too vague. ... Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.

--------------------------
So far, all of your posts have been requests for others to produce solutions to your specifications. This is a help forum whose members are volunteers working on their own time (and for free); it is not a design agency. It seems (to me) that your are posting your assignments on the forum and waiting for sol'ns; that's not fair!