View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
San San is offline
external usenet poster
 
Posts: 14
Default Exporting data using Pulldown List & VLOOKUP

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,