I have had several questions that have fixed problems that have led me to various solutions all of which now culminate in my Input Form having a list of Valid Pay Period Ending Dates. Only one problem. My validation list which gives me my drop down list for the clerk to select from has an extra blank line following each line of data from which they select.
I've attached a sample Excel 2007 Macro Enabled wkbk. The problem is on sheet "Payroll Data Input cells W1 and V4. They both do the same thing.
Anyone see where the problem is?