I suppose this falls loosely into the category of computer science.
I am making a spreadsheet to track my diet. It has fields in which data can be entered using a drop-down list from a table of foods. Then the spreadsheet looks up the calories, carbs, etc from the table using the vlookup function.
The problem is that there are too many fields to conveniently view on the screen. Excel has a feature which allows you to make an input screen which has all the fields for one record on one screen. However, the drop down list does not function on that screen.
I suppose I will have to make some kind of macro, unless somebody knows another way of doing it.