Hi,
I have dropdown list in sheet1 and sheet2.
If I select one value from sheet1 it has to select the same value in sheet2 automatically.
Do we have any existing options to link two dropdown in different sheets in excel.
Please let me know how I can achieve this.
Thanks...