Good Afternoon Everyone,
I'm looking for some advice on how to create a dynamic drop down list in one workbook (The list values are one column within a table in another workbook)
If i click the cell and try and create it using the data validation button in data tools it doesn't seem to like going outside of the current workbook to grab the data.
If I'm able to fix this issue i'm not sure how to use the count function to enable the list to grow or shrink (Mimic the column in the source file)
Any advice as to whether this is possible or where i'm going wrong would be greatly appreciated
Kind Regards,
Adam
I'm looking for some advice on how to create a dynamic drop down list in one workbook (The list values are one column within a table in another workbook)
If i click the cell and try and create it using the data validation button in data tools it doesn't seem to like going outside of the current workbook to grab the data.
If I'm able to fix this issue i'm not sure how to use the count function to enable the list to grow or shrink (Mimic the column in the source file)
Any advice as to whether this is possible or where i'm going wrong would be greatly appreciated
Kind Regards,
Adam
