Dear Ganesh Sorry for late reply but Actually I want result Single sheet not another sheet.
Regards Amar On Fri, Oct 10, 2014 at 9:32 PM, Ganesh N <ganeshg...@gmail.com> wrote: > Dear Amar, > > PFA. Just try now. If you have any concern let me know. > > Regards, > Ganesh N > > On Fri, Oct 10, 2014 at 4:38 PM, amar takale <amartak...@gmail.com> wrote: >> >> Dear friend >> Actially I want all result Show in one sheet.which you do this is like >> hyperlink >> Regards >> Amar >> >> On Thu, Oct 9, 2014 at 4:54 PM, Ganesh N <ganeshg...@gmail.com> wrote: >> > Hi amar, >> > >> > PFA. >> > >> > Regards, >> > Ganesh N >> > >> > On Thu, Oct 9, 2014 at 11:52 AM, amar takale <amartak...@gmail.com> >> > wrote: >> >> >> >> Dear Sir >> >> >> >> Pls find attached another sheet for detailed clarification.Here I show >> >> how to look output will show.Bos there are same one stock are under >> >> different category. >> >> >> >> Like BHEL it show under both 3 categary so if l hit any button >> >> (BSE,Nifty,PSU) it must show that under category.So if I hit button as >> >> per my requirement then stocks will show as per that under >> >> category.(note that one stock are under different 2 or 3 category) >> >> >> >> Regards >> >> Amar >> >> >> >> On Tue, Oct 7, 2014 at 7:49 PM, Paul Schreiner <schreiner_p...@att.net> >> >> wrote: >> >> > As I said, what you describe can be accomplished with the use of >> >> > Filters. >> >> > >> >> > In the attached filters, I enabled filters on your data. >> >> > >> >> > I then recorded a macro (called Button_Nifty50) >> >> > in which I filtered on the "Nifty 50" column, >> >> > and hid the BSE column. >> >> > >> >> > I then recorded a macro (called Button_ShowAll) in which I unhid all >> >> > columns >> >> > and removed the filters. >> >> > >> >> > I then recorded a macro (called Button_BSE30) >> >> > in which I filtered on the "BSE 30" column >> >> > and hid the Nifty 50 column. >> >> > >> >> > I ran the Button_ShowAll macro and recorded a macro called >> >> > Button_Other >> >> > in which I filtered the Nifty 50 column for a value of "Other" >> >> > (your example seemed to suggest that "Other" was in the BSE column, >> >> > but >> >> > you >> >> > data has it in the Nifty50 column) >> >> > >> >> > Once I had these recorded macros, I cleaned them up a bit (by adding >> >> > an >> >> > IF() >> >> > test to the showall macro, and others) >> >> > >> >> > then assigned the macros to the buttons. >> >> > >> >> > It SEEMS to do what you're asking. >> >> > >> >> > >> >> > Paul >> >> > ----------------------------------------- >> >> > “Do all the good you can, >> >> > By all the means you can, >> >> > In all the ways you can, >> >> > In all the places you can, >> >> > At all the times you can, >> >> > To all the people you can, >> >> > As long as ever you can.” - John Wesley >> >> > ----------------------------------------- >> >> > >> >> > From: amar takale <amartak...@gmail.com> >> >> > To: excel-macros@googlegroups.com >> >> > Sent: Tuesday, October 7, 2014 9:57 AM >> >> > Subject: Re: $$Excel-Macros$$ Sort VBA required >> >> > >> >> > Dear sir >> >> > >> >> > Pls find attached sheet where I show how to look output.Actually I >> >> > want after hit specific tab (like nifty,bse & other) will show that >> >> > under category Stocks thats it. >> >> > >> >> > I hope clarify my issue >> >> > >> >> > Regards >> >> > amar >> >> > >> >> > On Mon, Oct 6, 2014 at 7:14 PM, Paul Schreiner >> >> > <schreiner_p...@att.net> >> >> > wrote: >> >> >> I'm not sure about your requirement. >> >> >> >> >> >> You SAY you want to sort, but what you're describing is a filter. >> >> >> >> >> >> Sorting implies a change in sequence, >> >> >> Filter implies hiding rows that do not meet specific criteria. >> >> >> >> >> >> And... why would it matter if a stock appears in both categories? >> >> >> Even if you were sorting, if you sort on column D, it doesn't matter >> >> >> what >> >> >> is >> >> >> is column E. >> >> >> >> >> >> as I said, I'm not sure about your requirement. >> >> >> >> >> >> Could you clarifiy by showing examples of what you'd expect to see >> >> >> displayed >> >> >> if you hit the "Nifty 50" button, and what you'd see displayed when >> >> >> you >> >> >> hit >> >> >> the "BSE 30" button? >> >> >> >> >> >> >> >> >> >> >> >> Paul >> >> >> ----------------------------------------- >> >> >> “Do all the good you can, >> >> >> By all the means you can, >> >> >> In all the ways you can, >> >> >> In all the places you can, >> >> >> At all the times you can, >> >> >> To all the people you can, >> >> >> As long as ever you can.” - John Wesley >> >> >> ----------------------------------------- >> >> >> >> >> >> From: amar takale <amartak...@gmail.com> >> >> >> To: excel-macros@googlegroups.com >> >> >> Sent: Monday, October 6, 2014 9:25 AM >> >> >> Subject: $$Excel-Macros$$ Sort VBA required >> >> >> >> >> >> Dear all experts >> >> >> >> >> >> I required VBA code for sorting.pls see with detailed in excel. >> >> >> >> >> >> Regards >> >> >> Amar >> >> >> >> >> >> -- >> >> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> >> >> It’s >> >> >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> >> >> https://www.facebook.com/discussexcel >> >> >> >> >> >> FORUM RULES >> >> >> >> >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> >> >> Please >> >> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> >> >> Advice >> >> >> will >> >> >> not get quick attention or may not be answered. >> >> >> 2) Don't post a question in the thread of another member. >> >> >> 3) Don't post questions regarding breaking or bypassing any security >> >> >> measure. >> >> >> 4) Acknowledge the responses you receive, good or bad. >> >> >> 5) Jobs posting is not allowed. >> >> >> 6) Sharing copyrighted material and their links is not allowed. >> >> >> >> >> >> NOTE : Don't ever post confidential data in a workbook. Forum >> >> >> owners >> >> >> and >> >> >> members are not responsible for any loss. >> >> >> --- >> >> >> You received this message because you are subscribed to the Google >> >> >> Groups >> >> >> "MS EXCEL AND VBA MACROS" group. >> >> >> To unsubscribe from this group and stop receiving emails from it, >> >> >> send >> >> >> an >> >> >> email to excel-macros+unsubscr...@googlegroups.com. >> >> >> To post to this group, send email to excel-macros@googlegroups.com. >> >> >> Visit this group at http://groups.google.com/group/excel-macros. >> >> >> For more options, visit https://groups.google.com/d/optout. >> >> > >> >> > >> >> > >> >> >> >> >> >> -- >> >> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> >> >> It’s >> >> >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> >> >> https://www.facebook.com/discussexcel >> >> >> >> >> >> FORUM RULES >> >> >> >> >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> >> >> Please >> >> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> >> >> Advice >> >> >> will >> >> >> not get quick attention or may not be answered. >> >> >> 2) Don't post a question in the thread of another member. >> >> >> 3) Don't post questions regarding breaking or bypassing any security >> >> >> measure. >> >> >> 4) Acknowledge the responses you receive, good or bad. >> >> >> 5) Jobs posting is not allowed. >> >> >> 6) Sharing copyrighted material and their links is not allowed. >> >> >> >> >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners >> >> >> and >> >> >> members are not responsible for any loss. >> >> >> --- >> >> >> You received this message because you are subscribed to the Google >> >> >> Groups >> >> >> "MS EXCEL AND VBA MACROS" group. >> >> >> To unsubscribe from this group and stop receiving emails from it, >> >> >> send >> >> >> an >> >> >> email to excel-macros+unsubscr...@googlegroups.com. >> >> >> To post to this group, send email to excel-macros@googlegroups.com. >> >> >> Visit this group at http://groups.google.com/group/excel-macros. >> >> >> For more options, visit https://groups.google.com/d/optout. >> >> > >> >> > -- >> >> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> >> > It’s >> >> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> >> > https://www.facebook.com/discussexcel >> >> > >> >> > FORUM RULES >> >> > >> >> > 1) Use concise, accurate thread titles. Poor thread titles, like >> >> > Please >> >> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> >> > Advice >> >> > will >> >> > not get quick attention or may not be answered. >> >> > 2) Don't post a question in the thread of another member. >> >> > 3) Don't post questions regarding breaking or bypassing any security >> >> > measure. >> >> > 4) Acknowledge the responses you receive, good or bad. >> >> > 5) Jobs posting is not allowed. >> >> > 6) Sharing copyrighted material and their links is not allowed. >> >> > >> >> > NOTE : Don't ever post confidential data in a workbook. Forum owners >> >> > and >> >> > members are not responsible for any loss. >> >> > --- >> >> > You received this message because you are subscribed to the Google >> >> > Groups >> >> > "MS EXCEL AND VBA MACROS" group. >> >> > To unsubscribe from this group and stop receiving emails from it, >> >> > send >> >> > an >> >> > email to excel-macros+unsubscr...@googlegroups.com. >> >> > To post to this group, send email to excel-macros@googlegroups.com. >> >> > Visit this group at http://groups.google.com/group/excel-macros. >> >> > For more options, visit https://groups.google.com/d/optout. >> >> > >> >> > >> >> > -- >> >> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> >> > It’s >> >> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> >> > https://www.facebook.com/discussexcel >> >> > >> >> > FORUM RULES >> >> > >> >> > 1) Use concise, accurate thread titles. Poor thread titles, like >> >> > Please >> >> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> >> > Advice >> >> > will >> >> > not get quick attention or may not be answered. >> >> > 2) Don't post a question in the thread of another member. >> >> > 3) Don't post questions regarding breaking or bypassing any security >> >> > measure. >> >> > 4) Acknowledge the responses you receive, good or bad. >> >> > 5) Jobs posting is not allowed. >> >> > 6) Sharing copyrighted material and their links is not allowed. >> >> > >> >> > NOTE : Don't ever post confidential data in a workbook. Forum owners >> >> > and >> >> > members are not responsible for any loss. >> >> > --- >> >> > You received this message because you are subscribed to the Google >> >> > Groups >> >> > "MS EXCEL AND VBA MACROS" group. >> >> > To unsubscribe from this group and stop receiving emails from it, >> >> > send >> >> > an >> >> > email to excel-macros+unsubscr...@googlegroups.com. >> >> > To post to this group, send email to excel-macros@googlegroups.com. >> >> > Visit this group at http://groups.google.com/group/excel-macros. >> >> > For more options, visit https://groups.google.com/d/optout. >> >> >> >> -- >> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> >> It’s >> >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> >> https://www.facebook.com/discussexcel >> >> >> >> FORUM RULES >> >> >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> >> will >> >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Jobs posting is not allowed. >> >> 6) Sharing copyrighted material and their links is not allowed. >> >> >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners >> >> and >> >> members are not responsible for any loss. >> >> --- >> >> You received this message because you are subscribed to the Google >> >> Groups >> >> "MS EXCEL AND VBA MACROS" group. >> >> To unsubscribe from this group and stop receiving emails from it, send >> >> an >> >> email to excel-macros+unsubscr...@googlegroups.com. >> >> To post to this group, send email to excel-macros@googlegroups.com. >> >> Visit this group at http://groups.google.com/group/excel-macros. >> >> For more options, visit https://groups.google.com/d/optout. >> > >> > >> > -- >> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> > It’s >> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> > https://www.facebook.com/discussexcel >> > >> > FORUM RULES >> > >> > 1) Use concise, accurate thread titles. Poor thread titles, like Please >> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> > will >> > not get quick attention or may not be answered. >> > 2) Don't post a question in the thread of another member. >> > 3) Don't post questions regarding breaking or bypassing any security >> > measure. >> > 4) Acknowledge the responses you receive, good or bad. >> > 5) Jobs posting is not allowed. >> > 6) Sharing copyrighted material and their links is not allowed. >> > >> > NOTE : Don't ever post confidential data in a workbook. Forum owners and >> > members are not responsible for any loss. >> > --- >> > You received this message because you are subscribed to the Google >> > Groups >> > "MS EXCEL AND VBA MACROS" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an >> > email to excel-macros+unsubscr...@googlegroups.com. >> > To post to this group, send email to excel-macros@googlegroups.com. >> > Visit this group at http://groups.google.com/group/excel-macros. >> > For more options, visit https://groups.google.com/d/optout. >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
