Hi,
I have 2 problems I am trying to solve and unsure where to begin. I will describe them;

1. I have a spread sheet with a date drop down box on an output sheet and some raw monthly data in another. I would like to select the date in the drop down and pull the corresponding data from the data sheet into the appropriate cell in the output sheet for the monthly data.

2. The second is I have a YTD box I would like to fill based on all previous values from that current year. (I can figure the correct math out if you just help me add them for now)


I attached a sample workbook to help figure it out what I mean. The help is appreciated.

ExcelSheet.xlsm