Forum Discussion
Solved
Linked files
Hello everyone, First time I join this community. Here is my (complex for me) query. I have one file with a list of ingredients, suppliers, prices. Then I have individual files with recipes. Each ...
- here are some sites you can visit:
https://exceljet.net/excel-data-validation-guide
https://www.howtoexcel.org/tips-and-tricks/11-awesome-examples-of-data-validation/
good luck..
Thanks Lorenzo,
Do you mean using filters?
Jyc
no, I don't use filters. just plain Data Validation and vlookup.
hope that it will get you going with your project.
thanks..
hope that it will get you going with your project.
thanks..
Looks great. Thanks.
I am not familiar with Data Validation but will look at tutorials.
Jyc
- Data validation is like a controller - it checks data entry - allow selection from a list (which I did for column A - to select ingredient) and many more...
it is very interesting - hope you learn many things useful for your projects..- here are some sites you can visit:
https://exceljet.net/excel-data-validation-guide
https://www.howtoexcel.org/tips-and-tricks/11-awesome-examples-of-data-validation/
good luck..