Hi all.
Is there a way to auto complete a drop down without using macro codes?
lets say Sheet1 contain the drop down options and sheet2 have the validated drop down list of 200.
Thank you.