I'm trying to create a data sheet that will auto-populate other sheets as data is entered into the 'Data' sheet. The problem I'm running into is that each column does not have data entries for every date. I need a way to skip the blank cells and put the next data filled cell in the next cell on the formula filled sheet. (I need this in order to conduct other functions and create a chart.) Attached is the workbook I am working with (not all data is included for memory sake). Any help is appreciated!