Re: $$Excel-Macros$$ Sort VBA required
Dear Poul sir Thank you so much for your code, for the effort and time dedicated.Output came as per my mind now I am very happy. Thanks sir once again Regards On Mon, Oct 13, 2014 at 7:44 PM, Paul Schreiner schreiner_p...@att.net wrote: I thought I'd sent this, but it looks like I did not. If you create an AutoFilter, then your buttons can simply apply the filter (as attached) 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 13, 2014 8:48 AM Subject: Re: $$Excel-Macros$$ Sort VBA required 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
Re: $$Excel-Macros$$ Sort VBA required
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
Re: $$Excel-Macros$$ Sort VBA required
I thought I'd sent this, but it looks like I did not. If you create an AutoFilter, then your buttons can simply apply the filter (as attached) 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 13, 2014 8:48 AM Subject: Re: $$Excel-Macros$$ Sort VBA required 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
Re: $$Excel-Macros$$ Sort VBA required
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
Re: $$Excel-Macros$$ Sort VBA required
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
Re: $$Excel-Macros$$ Sort VBA required
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
Re: $$Excel-Macros$$ Sort VBA required
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
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
Re: $$Excel-Macros$$ Sort VBA required
Dear sir Also I required if i hit show all button then show all stocks Regards Amar On Tue, Oct 7, 2014 at 7:27 PM, amar takale amartak...@gmail.com wrote: 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
Re: $$Excel-Macros$$ Sort VBA required
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
Re: $$Excel-Macros$$ Sort VBA required
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.