Karin5281Copper ContributorJan 04, 2021Data validation I'm trying to recreate a data validation that works in a different workbook. I have a column of data on a separate worksheet titled dropbox. My data validation formula (which is the same as the other...Show More
rhancockBrass ContributorJan 04, 2021Karin5281 "dropbox" is a tab on the worksheet it is trying to access. =dropbox!A1:A10 is referring to cells A1-A10 on the "dropbox" page.
Karin5281Copper Contributor to rhancockJan 04, 2021rhancock Yes, I know that part. But why won't that work as the source for my data validation? It kicks back an error message.mtarlerSilver Contributor to Karin5281Jan 04, 2021Karin5281 that error message sounds a lot like this case:The problem here is that the 'Allow' is set to 'Custom' instead of 'List'If this isn't your problem, can you share the workbook?Karin5281Copper Contributor to mtarlerJan 04, 2021mtarler that worked! Thank you so much.
Karin5281Copper Contributor to rhancockJan 04, 2021rhancock Yes, I know that part. But why won't that work as the source for my data validation? It kicks back an error message.
mtarlerSilver Contributor to Karin5281Jan 04, 2021Karin5281 that error message sounds a lot like this case:The problem here is that the 'Allow' is set to 'Custom' instead of 'List'If this isn't your problem, can you share the workbook?
