Forum Discussion
Data validation
Hello everyone, I've done a data validation function from a list of 10 products, and I've replicated it to 10 cells. What function can I do on these 10 cells, if I choose one product from my list li...
anyone can help please?
if I understand you right,
you want to delete the record in sheet [data] whenever it is selected in sheet [data var].
if this is correct - you can try the sample I attached.
pls read notations on the worksheet.
hope you can work something out of it.
thanks..
- you might want to visit this site:
https://www.extendoffice.com/documents/excel/2327-excel-hide-previously-used-items-in-dropdown.htmlhttps://www.extendoffice.com/documents/excel/2327-excel-hide-previously-used-items-in-dropdown.html
from the above site I made the attached sample.
hope this might help.
thanks..