Hi Ankur, This is what I wanted.Thanks for your help!
Is it possible that I can convert your formula (B5:N23) in array formula? Regards, Sandip On Thu, Jan 21, 2010 at 11:55 PM, ankur <ankurpande...@gmail.com> wrote: > HI SANDIP > if you need any other clarification , plz let me know > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Fri, Jan 22, 2010 at 1:24 PM, ankur <ankurpande...@gmail.com> wrote: > > HI SANDIP > > check the revised sheet, this is acc to ur need > > if you want formulas in next rows and cloumns just drag the last row > > Have A Nice Time & Enjoy Life > > > > Regards: > > CMA Ankur Pandey > > (Someone Different) > > > > I'm not the best but i'm not like the rest~~ > > > > > > > > On Fri, Jan 22, 2010 at 6:24 AM, Sandip Patel <myitems2...@gmail.com> > wrote: > >> 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 > >> > > > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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
