hi Sandip i dont know how will it be done.... i think it is not possible in this condition keeping your requirements , may be other members can give any idea about this....
On 26/01/2010, San Pat <myitems2...@gmail.com> wrote: > Hi Ankur, > > Is it possible that you can covert the current formula of B5:N23 cells to an > array formula? > > Regards, > Sandip > > ---------- Forwarded message ---------- > From: ankur <ankurpande...@gmail.com> > Date: Thu, Jan 21, 2010 at 11:54 PM > Subject: Re: $$Excel-Macros$$ Exporting data using Pulldown List > To: excel-macros@googlegroups.com > > > 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 > -- 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
