Hi, I have a two sheets on my excel spreadsheet - Sheet1 and Sheet2. I have set up a drop down function in cell A2 in Sheet1. In sheet2 I have the titles in the drop down going along row 1 from A1-DI. Beneath each of the titles in Sheet 2 are several cells of information relevant to that specific title.
My goal is to create a formula that will drag through the cells of information from Sheet2 into Sheet1 into cell A3 onwards depending on what title is selected in the drop down in A2 e.g. in the drop down in Sheet 1 cell A2 if I selected "John Smith" then the information in Sheet 2 below "John Smith" would appear in Sheet 1 cell A3 and descend until all of the relevant information would appear in Sheet 1.
Thank you in advance for your help, it is greatly appreciated.
My goal is to create a formula that will drag through the cells of information from Sheet2 into Sheet1 into cell A3 onwards depending on what title is selected in the drop down in A2 e.g. in the drop down in Sheet 1 cell A2 if I selected "John Smith" then the information in Sheet 2 below "John Smith" would appear in Sheet 1 cell A3 and descend until all of the relevant information would appear in Sheet 1.
Thank you in advance for your help, it is greatly appreciated.