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.
As you can see in the attached file, in the sheet "Data", 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 should change. Regards, Sandip -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Portfolion Motior.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
