I am needing assistance with adjusting my combo box selection to allow the data to update based on the Month selected. Currently, it only pulls data for the day. (i.e. if “October is selected, it is only pulling 11/1/2018”)
To start, I have a VBA code below. It inputs data from a spreadsheet into the Data tab on the workbook below. The VBA code is setup up to have the date entered as “mmmm-yyyy” but when inputting on the Data tab, it displays as “October-2018”, however it is formatted to input the day that the data was entered from another spreadsheet.
On the Overview tab, when October is select, the idea is to update all the data based on that selection, however it is only pulling that specific day.
Note: I'm using October because there were three days of input
How do I setup my Data Validation list to incorporate the month of October?
Bookmarks