My office has a contact list in Excel and we are always adding new contacts to the list. It's a shared doc that everyone is updating frequently. (Really this should probably be set up as a database in Access, but we're not there yet.) Is there a way to create a form where users can enter all the info and it will put all the info into a new row at the bottom of the list? Maybe with a macro?
How can OfficeQuestions help you get a job?
Learn how your participation of OfficeQuestions can be a valuable asset on your resume.
1
|
|
|
|
|
1
|
There is a feature in XL 2003 called a "List" and the same thing in XL 2007 called a "Table". In xl2003 you access it from the Data menu. The List/Table automatically expands when data is added to it. There is a writeup, today, about this feature at... http://datapigtechnologies.com/blog/ '-- Jim Cone - Portland, Oregon USA |
||
|
|
Not the answer you're looking for? Browse other questions tagged excel macro or ask your own question.
Welcome to OfficeQuestions
A place to ask and answer questions about the Microsoft Office™ suite of applications. Whether you need help with an Excel™ formula have a question about formatting a Word™ document, OfficeQuestions is the place to share knowledge about Office.
Share This Page
Share OfficeQuestions with your friends and colleagues
Follow Us
Follow OfficeQuestions on Twitter and receive updates about the site.
Careers
Find out how OfficeQuestions can make a difference in your next interview
