Hi Experts over there !
The file in link Sample File
1. In Sheet Portfolio, in Column A, I need scheme names in auto fill text box from Column D in sheet NAV
2. Once text is selected from auto fill text box, respect value Column E of sheet NAV should appear in Column C of sheet Portfolio and value in column F of sheet NAV should appear in Column B of sheet Portfolio
Request assistance please
The file in link Sample File
1. In Sheet Portfolio, in Column A, I need scheme names in auto fill text box from Column D in sheet NAV
2. Once text is selected from auto fill text box, respect value Column E of sheet NAV should appear in Column C of sheet Portfolio and value in column F of sheet NAV should appear in Column B of sheet Portfolio
Request assistance please