Hi there,
I have spreadsheets which I have fields that need to be populated. Year|Month|Date|Detail|Expense|Category|Sub-Category
I bring information in from other sources (like credit card records) to populate all except the Category and Sub-Category fields
If the spreadsheet is not filtered, I can select a cell and right click then using "Pick from Dropdown List" I can plug in the appropriate Category, and do the same on the Sub-Category
If the spreadsheet is filtered to just the new year I'm entering data for, the available items to choose from are not visible or at most only those entered in the visible cells are, so it becomes far more difficult to populate the necessary fields, and the problem is I've filtered to those records on which those fields are currently blank so that I can populate them.
Is there a way to force Excel to display the options for picking from the dropdown list for the rows that aren't visible so a selection can be made in the visible rows?
Thanks in advance.
Bookmarks