Is there a possibility wherein we can have a set of values populated when we enter or chose a value in the first cell and the cells next to it correspondingly pick up info from another excel tab/sheet.
For Eg
Sl No Option Dest
1 A1 - Gingerbread MA1
2 A2 - Lemon MA1...