excel help

[vampyr07au]

There are a couple of things I would like some help with.
I have a database for my movie collection and it uses drop down boxes to propogate it's data.


1. Is there a way to make an "add new" to the drop down box so that if the names don't exist the user can select "add new" from the drop down box and add the new names.

2. This database will be used to track movie lists from several people. Is there a way to create a button that will when clicked provide some sort of button or something that will copy and paste any data from within excel dbase 2 and insert that data in the corresponding named worksheet. This would need to open the relevant existing dbase and then transfer the data to the original sheet.
This could be created as a run once macro on its own or just as an option at the beginning of running the database itself.
If it was to be run as a standalone single macro then is there a way to make an option that allows the user to drag and drop the newest database onto it and this will then copy and remove the new entries in the multiple user dbase.
Obviously it would be reqd to check the existing entries in the existing multi user dbase so that when copying across new data it will not duplicate any entries.

[DonkeyOte]

Welcome to the Board, however, I'm afraid...

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[DonkeyOte]

And...

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Please be sure to read the forum rules before posting further.