Hello,
I would like to have two sheets, one to fill out a form and one to store the answers.
On this Selections Sheet, I would like to have a Person dropdown at the top which would determine which column the answers will be stored in on the Storage Table Sheet.
I would like to be able to "save" these answers for each Person (using the Storage Table) and switch between Persons.
Please see attached example for a better idea.
You cannot do this (easily) with formulas, you will need VBA. As soon as you change the DD, the reference to it on the other sheet will change.
Why not just use those DD's IN your table and populate your table with them?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks