Forum Discussion
Misha Ayzenberg
Sep 27, 2018Copper Contributor
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...
Misha Ayzenberg
Sep 27, 2018Copper Contributor
for example, i have list of cataloge num.
if i choose 358151060715892 in A2, i want that its number will desapear from the next cells (A3-A7).
attached the file.
Lorenzo Kim
Sep 27, 2018Bronze Contributor
I do not see any attachments...
- Misha AyzenbergSep 27, 2018Copper Contributor
check please
- Misha AyzenbergOct 02, 2018Copper Contributor
anyone can help please?
- Lorenzo KimOct 02, 2018Bronze Contributor
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..