u r welcome sandip 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 Sun, Jan 24, 2010 at 12:49 AM, San Pat <myitems2...@gmail.com> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
