Re: $$Excel-Macros$$ split text by pipe sign
cheers man... + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 3:46 PM, Waseem Saifi wrote: > thank you vaibhav, > > it's perfect > > On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi wrote: > >> check this... >> >> + >> *I did not do this for you. God is here working through me for you.* >> >> On Sun, Oct 12, 2014 at 11:08 AM, Waseem Saifi >> wrote: >> >>> Hi Vaibhav, >>> >>> I want through formula. nor by text to column neither macro as already >>> mentioned it in attached file. In just one cell. >>> >>> On Sat, Oct 11, 2014 at 6:22 AM, Vaibhav Joshi wrote: >>> how do you want output? Formula or thru Macro? + *I did not do this for you. God is here working through me for you.* On Sat, Oct 11, 2014 at 10:19 AM, Waseem Saifi wrote: > Hi Experts, > > I have attached a file which contain text in cell A15. I want to > split this text by pipe sign [|] in cells next to cell A15. > > Thanks in Advance. > > > Regards, > Waseem Saifi > > -- > 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.
Re: $$Excel-Macros$$ Report
welcome bro.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 3:23 PM, joseph camill wrote: > Thank you Vaibhav > > On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi wrote: > >> Thanks bro... >> On Oct 12, 2014 6:05 PM, "Ashish Kumar" >> wrote: >> >>> Hi Vaibhav Bhai, >>> >>> Nice Solution. Sheet is working Great. >>> >>> >>> Regards >>> Ashish >>> >>> -- >>> 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
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 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 > 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 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 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 wrote: >>> > Hi amar, >>> > >>> > PFA. >>> > >>> > Regards, >>> > Ganesh N >>> > >>> > On Thu, Oct 9, 2014 at 11:52 AM, amar takale >>> > 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 >>> >> >>> >> 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 >>> >> > 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 >>> >> > >>> >> > 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
Re: $$Excel-Macros$$ Job Opening for MIS profile.
Hi Pramod, Please share job location & description. Regards, Tarun Verma On Wednesday, October 8, 2014 10:34:15 AM UTC+5:30, pramodb35 wrote: > > Hi All. > > I have also one Opning in my company. As MIS profile. > > Salary 19 k and pickup and drop and also meals . > > Regards > Pramod > > Pramod > On 8 Oct 2014 09:51, "Ashish Kumar" > > wrote: > >> Hi Friends >> >> We have 2 Openings for MIS profile. >> >> Experience - 1 to 2 Yrs >> Salary - 10 K (Take Home) + ESI + PF + Gratuity >> Job Location - Gurgaon. >> Freshers are Welcome but have Good Hands on Excel. >> >> 1 Vacancy is for Gurgaon and 1 for Mundka (New Delhi). [Peeragarhi - >> Rohtak Road] >> >> Interested Candidates please send your resumes. >> >> >> Regards >> Ashish >> >> -- >> 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...@googlegroups.com . >> To post to this group, send email to excel-...@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.
Re: $$Excel-Macros$$ Help in Time Tracker
As you undoubtely noticed, the number 8.45 does NOT represent 8 hours and 45 minutes, but 8 hours and .45 of an hour, which is 8 hours and 27 minutes. you cannot simply subtract these number and interpret the numbers as time. Now, to excel, a DATE is actually the number of days since 1/1/1900. So, Saturday, February 01, 2014 is actually stored in Excel as: 41671 TIME in Excel is a fractional part of a day. 8:45 AM is actually .3645833 of a day. 8:10 PM is actually .8402778 of a day. THESE numbers you can subtract (.47569444) since there are 24 hours in a day, then 24*.47569444 = 11.417 hours. So, your task is to convert your numeric representation: 8.45 to an actual excel "time" value. there is an Excel function called TIME(), which takes hours, minutes and seconds and converts it to an excel time. The "hours" portion of 8.45 is found by using int() For the in-time in cell C3, you can use =INT(C3) (results in 8) For the "minutes" portion, you have to subtract the hours: =C3-INT(C3) But that gives you .45 so multiply it by 100 to get "45": =(C3-INT(C3))*100 the end result is: =TIME(INT(C3),(C3-INT(C3))*100,0) Now, your "OUT TIME" is done the same way, but the hour figure needs to have 12 added to it go show a PM time: =TIME(INT(D3)+12,(D3-INT(D3))*100,0) This gives you two "Excel time" values, which you can subtract to get the fractional part of a day: .47569444 Now, since there are 24 hours in a day, you need to multiply this value by 24 to get: 11.417 hours (which is .417 HOURS, not 41.667 minutes!) let me know if you need help applying this logic to your workbook. 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: Vijayendra Rao >To: excel-macros@googlegroups.com >Sent: Monday, October 13, 2014 10:39 AM >Subject: $$Excel-Macros$$ Help in Time Tracker > > > >Dear Experts, > > >Can you please help me to convert time to numbers. Attached is the my file and >my formula is showing some wrong numbers. Request you to help on the same. > >Regards, >Vijayendra >94491 67631 -- >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.
$$Excel-Macros$$ Help in Time Tracker
Dear Experts, Can you please help me to convert time to numbers. Attached is the my file and my formula is showing some wrong numbers. Request you to help on the same. Regards, Vijayendra 94491 67631 -- 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. Time tracker.xlsx Description: MS-Excel 2007 spreadsheet
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 >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 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 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 wrote: >>> > Hi amar, >>> > >>> > PFA. >>> > >>> > Regards, >>> > Ganesh N >>> > >>> > On Thu, Oct 9, 2014 at 11:52 AM, amar takale >>> > 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 >>> >> 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 >>> >> > 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 >>> >> > >>> >> > 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
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 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 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 wrote: >> > Hi amar, >> > >> > PFA. >> > >> > Regards, >> > Ganesh N >> > >> > On Thu, Oct 9, 2014 at 11:52 AM, amar takale >> > 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 >> >> 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 >> >> > 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 >> >> > >> >> > 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 >> >> >> 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) ! Joi
Re: $$Excel-Macros$$ Need a macro to get consolidated report
can you share sample for conso file too.. + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 1:27 AM, Ujjwal Desai wrote: > Hello , > > I am in need of a macro which will help me to get a consolidated report of > daily data saved in the folder. > > Requirement : > > 1.Need a consolidated report of each excel file saved in a particular > folder (Tab "Workflow"). > 2.Also report should get automatic pivot option once all the data are > consolidated from the different file. > > Note : Data to be consolidated for tab workflow only in each excel file > (sample attached) > > Thanks, > Ujjwal > > -- > 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.
Re: $$Excel-Macros$$ excel add-in to .exe
What is it you're trying to do? The reality is: macros in excel are written in VBA Which is Visual Basic for APPLICATIONS. That means, that is initially Visual Basic, with features added depending on the Application. For instance, the all cells of an Excel worksheet are selected using the Cells.Select statement. But microsoft Word doesn't HAVE cells, so to select the content, you use: Range.WholeStory So you see, VBA is VERY dependent upon the Application it is developed in. So, generally, there wouldn't be much use to be able to convert the VBA macros to an .exe format, since they normally would require the application in order to run! So, if you can explain what you have in your VBA and what you're trying to do with it, perhaps we can help accomplish your task, just not the exact way you've described. 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: "myxlg...@gmail.com" >To: excel-macros@googlegroups.com >Sent: Saturday, October 11, 2014 9:45 AM >Subject: $$Excel-Macros$$ excel add-in to .exe > > > >Sir, >is it possible to convert add-in (some macros) to .exe file. >if possible pls suggest software (vb.net or any) & procedure. >i checked excel compiler which is free in net but not succeed > > >thanks -- >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.
Re: $$Excel-Macros$$ Re: Need Macro enabled Button to select Filter Values
Why were you not able to change the captions?
Do you need help with that?
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: Ahmed Siddique
>To: excel-macros@googlegroups.com
>Sent: Saturday, October 11, 2014 1:51 AM
>Subject: Re: $$Excel-Macros$$ Re: Need Macro enabled Button to select Filter
>Values
>
>
>
>Thanks Paul.
>Actually I am learning on daily basis following your posts and implementing as
>much in my projects. I was not able to change the captions actually, so had to
>use two buttons.
>But thanks a lot.
>
>
>
>On Oct 10, 2014 7:50 PM, "Paul Schreiner" wrote:
>
>What do you know of Excel and VBA?
>>
>>This is a pretty simple exercise.
>>Simply insert an ActiveX button.
>>change the Properties so that the name is: Btn_Filter.
>>Select "View Code"
>>add this to the macro:
>>Private Sub Btn_Filter_Click()
>>If (Left(UCase(Btn_Filter.Caption), 4) <> "TYPE") Then
>>Btn_Filter.Caption = "Type 1"
>>ActiveSheet.Range("$A$1:$A$1").AutoFilter Field:=1,
>> Criteria1:="Type 1"
>>ElseIf (Btn_Filter.Caption = "Type 1") Then
>>Btn_Filter.Caption = "Type2"
>>ActiveSheet.Range("$A$1:$A$1").AutoFilter Field:=1,
>> Criteria1:="Type2"
>>Else
>>Btn_Filter.Caption = "Click to Filter"
>>If (ActiveSheet.FilterMode) Then ActiveSheet.ShowAllData
>>End If
>>End Sub
>>
>>hope this helps
>>On Friday, October 10, 2014 7:10:17 AM UTC-4, simplyali wrote:
>>Dear Excel Gurus,
>>>
>>>
>>>I need one help in the attached Excel. I need a Macro Button to be placed on
>>>the sheet, on clicking the same it should select the option out of two.
>>>
>>>
>>>Example:
>>>
>>>
>>>When I click on the Button first time, it select Type 1 from the first
>>>Column, and change the Button Text to Type 2. Similarly, wen I click on teh
>>>Button again, It selects Type 2 from the Column and the Button Test changes
>>>to Type 1.
>>>
>>>
>>>
>>>Note:" I will be having only two values for the Column.--
>>>Thanks and Regards,
>>>Ahmed Ali Siddique
>>>
>>>
--
>>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 p
Re: $$Excel-Macros$$ split text by pipe sign
thank you vaibhav, it's perfect On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi wrote: > check this... > > + > *I did not do this for you. God is here working through me for you.* > > On Sun, Oct 12, 2014 at 11:08 AM, Waseem Saifi > wrote: > >> Hi Vaibhav, >> >> I want through formula. nor by text to column neither macro as already >> mentioned it in attached file. In just one cell. >> >> On Sat, Oct 11, 2014 at 6:22 AM, Vaibhav Joshi wrote: >> >>> how do you want output? >>> >>> Formula or thru Macro? >>> >>> >>> >>> + >>> *I did not do this for you. God is here working through me for you.* >>> >>> On Sat, Oct 11, 2014 at 10:19 AM, Waseem Saifi >>> wrote: >>> Hi Experts, I have attached a file which contain text in cell A15. I want to split this text by pipe sign [|] in cells next to cell A15. Thanks in Advance. Regards, Waseem Saifi -- 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 w
Re: $$Excel-Macros$$ Report
Thank you Vaibhav On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi wrote: > Thanks bro... > On Oct 12, 2014 6:05 PM, "Ashish Kumar" wrote: > >> Hi Vaibhav Bhai, >> >> Nice Solution. Sheet is working Great. >> >> >> Regards >> Ashish >> >> -- >> 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.
