Hi Experts,
I just need one thing when I select any specific address in yellow box columns then that specif address will remove from bottom list, please see screenshot and excel file you will better understand.
Thanks in advance
Farhan
Hi Experts,
I just need one thing when I select any specific address in yellow box columns then that specif address will remove from bottom list, please see screenshot and excel file you will better understand.
Thanks in advance
Farhan
Please check in cel A110 & B110, there were some formula there.
Regards,
Thangavel D
Appreciate the help? CLICK *
There was an issue with deleting the row, it screws up your array formulas.
I have changed it a bit, when you select the Teritory, the list is replaced from A111 down. Then a list range is updated, and that list range is used for your data validation.
When selecting something from the data validation, that selection will get deleted from the bottom list.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks