Hi Friends,

I am developing a portfolio tracker excel file. I am having some difficulty
in implementing one function, which I think I cannot create using macro.

I am downloading various parameters using the SMF Add-In. Which is working
fine. After downloading these data I want to export them into the other sheet
"Pull Down Option". I tried to use OFFSET and VLOOKUP function. But it is not
working. In the Pull Down Option sheet, I have created a droop down list, so
when I change the droop down list, the data associated (Sheet Data) with it &
a stock symbol should change.

Regards,

You say it's not working, San, but you don't say what you did and HOW it's
not working.

--- "San" wrote:
I tried to use OFFSET and VLOOKUP function. But it is not
working. In the Pull Down Option sheet, I have created a droop down list, so
when I change the droop down list, the data associated (Sheet Data) with it &
a stock symbol should change.