98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Validation/lists
Validation/lists
Resolved · Low Priority · Version 2003
Gemma has attended:
Excel Intermediate course
Validation/lists
When creating lists from the validation function, and my lists are on another page, is this the same as linking formulas on worksheets?
RE: Validation/lists - 3 D Formulae
Dear Gemma
Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.
I am not 100 % sure what your query mean but I am guessing that you are referring to the Data > Validation command in the Menu bar. When you choose List you can link the use the cells from the other cells in the same sheet by entering them in the source box.
Although it is a quick way of selecting your source data but it create a lot of problem if anybody starts to delete rows and columns or data in the sheet where the data is coming from. It is better to type the values manually in the List source in the data Validation.
Answer to your question is that you can use the source cells from the same sheet but I am not aware of using the source cell from other sheets!! The list in the data Validation is used for linking cells that normally have simple data and not formulae or functions!!
If you want to link cells that have formulae or functions then you have to create a 3-D Formula similar to the one we created during the Excel Intermediate course!!
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Outlining - Grouping rows or columnsHighlight want you want to group and press ALT + SHIFT + left cursor arrow |