Discussion Locked

Data Validation in Excel

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to select validation data from a list created on a second worksheet within the same workbook? I want to seperate the data list from the worksheet used for the data entry.

5 replies

by brian

I don't know what you mean by validation. There is an excel feature to only allow data if it meets a defined criteria (validation). I don't think this is what you mean. It sounds like you just want to repeat the data on another sheet. You can use a number of methods, perhaps the easiest is to create the new sheet, put the cursor in the first box you want to have the duplicate data from the other sheet appear in , hit +, navigate to the existing data and the first data cell, hit enter. The value should now be in the new sheet. You can copy by dragging and fillling the rest of the sheet to quickly coppy all values from the original sheet. These values will change as they are updated on the original.

If you want to take a snapshot use a macro to copy and paste and then assign it to a button you press. Macros can be recorded by starting the recorder, it will then watch what you do until you hit stop. Once run it will perform the same actions it recorded.

by daybreaker

This isn't really what I needed. I tried to clarify the problem in an updated comment. Thanks for trying on this one.

by daybreaker

Just to clarify, I do not want to copy the list to another worksheet. I want to be able to place the list of items to be selected on one sheet and be able to select them from a pull down list on another sheet. Essentially I will have one sheet that will handle all of the data entry and one sheet that only has the validation data list items.

by pubservant

You can use a ListBox or ComboBox control from the Control Toolbox on your data entry worksheet to select from a range on a second worksheet and assign the chosen value to a cell on the data entry worksheet. Set the ListFillRange property to the worksheet and range from which you wish to select. For example, Sheet2!A1:A10. Set the LinkedCell property to the cell on the data entry worksheet where you want the entry placed.

by choppit

No it's not possible (or at least not in Excel 2000) but I suspect you already came to this conclusion.

This discussion is closed to new replies.