Question re Data Validation in Excel

  oo7juk 12:26 30 Oct 07


Is it possible for the source data to be entered on another worksheet?

I checked MS online and it stated it has to be on the same sheet as the data validation box.

Many thanks.

  xania 12:40 30 Oct 07

Not sure exactly what you mean by this query, but it is always possible to work with data linked between worksheets or workbooks using the Paste Link option in Paste Special. All I will say is that, once you set up these links, don't amend the names or relative locations as this will break the link.

  VoG II 12:42 30 Oct 07

It will work if you give your data validation list a name (Insert > Name > Define), then refer to that name on the second sheet.

  silverous 12:43 30 Oct 07

There's your answer. It doesn't come much more credible than from MS.

I tried it, and sure enough if you try to refer to another sheet with the data validation you get an error.

The only way would be to have a formula perhaps on the same sheet which then looked up the relevant data on another sheet (to save duplication) OR use VBA.

  silverous 12:43 30 Oct 07

Or do what Vog says which seems to work well :)

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009