hi all,

New here and fairly new to excel. Can do all the basic sum and countif formulas but not much after that.

I am trying to make sheet "daily summary" fill in all the data to match the data on the sheet "stats" dependant on the date that is entered at the top. So if I were to input the 16/12/2019 on the daily summary, it would pull all the data from the stats sheet from that dates column.

If any one could point me in the right direct to sort that would really appreciated.

Thanks
Michael

Daily Summary.JPG

stats.JPG