Is there anyway to display a column of Data from another sheet, in the same workbook, based on an entry in a drop-down. For example, A drop-down in A1 on sheet2 has options A, B, C, D, E. When A is selected in the drop-down list, data from sheet1 on column A is displayed on sheet 2 in column B. When C is selected in the drop-down. Data from column C in Sheet1 is displayed in Column B on sheet 2, etc.
Thank you!!