Drop Down Menu Value Storage

[robotdell]

Hello all, I was wondering if someone could help with this very strange problem.

I have a drop down menu that conditionally populates the other cells with information based on what is chosen from the drop down menu. E.G: you click "January 2012" and it brings up values associated with January's numbers.

What I was wondering is that there are a group of cells that need to be populated by a different office staff member, and these numbers change from month to month. Is there anyway that you can do this (by VB or whichever) so that when one person types in the numbers, it stores it in a back tab, but still is completely editable? And then you can pull down a different drop down menu selection, and it brings up the earlier stored numbers? Please let me know if this makes sense and if anyone can help!

Thanks

 

[iliace]

If I understand correctly, what you want is more of a database form than a spreadsheet. It can be done with Excel, but the VBA programming required is pretty intense. Most likely, you'll be better off doing this in an Access database, which probably won't require anything other than built-in form/table/query functionality.