Hi Ankur, Really appreciate your help.
It is working as I wanted. But When I change the symbol in column A, it is giving an error. Please see the attached file. Is it possible that it allows me to enter the symbol in any sequence, as long I have all the required values of that particular symbol in the next sheet. Also, in the excel sheet you send me, the formulas are in the rows 1 to 5. Is there any way I can have the same formula in the remaining rows/column, even though they are empty? Regards, Sandip -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ankur Sent: Wednesday, January 20, 2010 9:01 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Exporting data using Pulldown List hi sandip plz check the attached file i think this is what you want On 21/01/2010, Sandip Patel <myitems2...@gmail.com> wrote: > 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 > -- Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- ---------------------------------------------------------------------------------- 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
Copy of Portfolion Motior solved by ankur.xls
Description: MS-Excel spreadsheet
