helpme1992
New Member
- Joined
- Sep 2, 2016
- Messages
- 13
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 B1 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
In need of help! I have a spreadsheet containing dates in columns (12/09/16 in cell A1, 19/09/16 in cell B1 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