Help help help please please please

[helpme1992]

Hi all

In need of help! I have a spreadsheet containing dates in columns (12/09/16 in cell A1, 19/09/16 in cell A2 etc). Underneath each date (which is effectively the column header) I have ten rows of numbers. I need to be able to type a date into a cell on another sheet and have a formula that automatically brings up those ten rows of info onto the other sheet. Any Excel wiz's out there that could help I would be SO SO SO SO SO appreciative!!!

THANK YOU

M

 

[helpme1992]

Steve . . . where do I even begin to express my gratitude,

It has worked perfectly! After some playing around I have successfully managed to incorporate it into my spreadsheet - beyond elated Steve! Had been trying all of yesterday to find a formula / understand how to use it to no avail. You have been my saving grace!

THANK YOU again Steve you're amazing,

Over and out

M