Hi All,
I'm working in sheet1 and trying to create a list from values in sheet2 column A:A.
The data valation function will not allow me to create a list using values from another worksheet.
Is there a way to call the values from sheet2 into sheet 1 cell A1: A5000?
I'm working in sheet1 and trying to create a list from values in sheet2 column A:A.
The data valation function will not allow me to create a list using values from another worksheet.
Is there a way to call the values from sheet2 into sheet 1 cell A1: A5000?