Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution
i have send you two attachment, which you are taking about ? Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:56 AM, amar takale wrote: > Dear Deba > Again Thanks for help,if i want more than 3 chart show how to modify code. > > On Fri, Dec 14, 2012 at 11:44 AM, Deba Ranjan wrote: > >> Amar, >> >> >> U can see this attachment also. PFA. might it will help you. >> >> >> >> Thanks & Regards, >> *Deba ranjan* >> >> >> >> >> >> >> On Fri, Dec 14, 2012 at 11:24 AM, Deba Ranjan wrote: >> >>> Attachment missed... >>> >>> Hi Amar, >>> >>> PFA the chart sheet, might it will help you out. >>> >>> >>> -deba >>> >>> >>> >>> Thanks & Regards, >>> *Deba ranjan* >>> >>> >>> >>> >>> >>> >>> On Fri, Dec 14, 2012 at 11:23 AM, Deba Ranjan wrote: >>> >>>> Hi Amar, >>>> >>>> PFA the chart sheet, might it will help you out. >>>> >>>> >>>> -deba >>>> >>>> >>>> >>>> >>>> >>>> Thanks & Regards, >>>> *Deba ranjan* >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Fri, Dec 14, 2012 at 11:05 AM, amar takale wrote: >>>> >>>>> Dear All Experts, >>>>> Can you help me above two file,last week you help me which is very >>>>> Helpful &knowledgeable for me.I love excel So in free time I do R&D in >>>>> excel that time I search two file on internet. >>>>> >>>>> 1) In which two chart if I click sales then show Sales Chart,If I >>>>> click Pat then show PAT Chart,then I decided to add more than two chart >>>>> (Min 5 chart) in sheet but code is for only two chart Can you expand VBA >>>>> code maximum 5 chart or more then I only click chart name & show that >>>>> specific Chart& Other are hide.I had more R&D in that but not success. >>>>> 2) On Internet I found photo file in which we can change brightness of >>>>> photo but when I add my photo in excel that is not work, why?change >>>>> picture >>>>> name also. >>>>> >>>>> So Pls Guide me >>>>> >>>>> Appreciate the help. >>>>> >>>>> Regards >>>>> Amar >>>>> >>>>> -- >>>>> 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 post to this group, send email to excel-macros@googlegroups.com. >>>>> To unsubscribe from this group, send email to >>>>> excel-macros+unsubscr...@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>>>> >>>>> >>>>> >>>> >>>> >>> >> -- >> 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 thre
Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution
Thanks Amar !! Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:52 AM, amar takale wrote: > Dear Deba Rajan, > > First Congratulation for winner of Calendar quiz.Dear Deba which you send > file it is fantastic,Mind blowing,I like it very much.It is also > very useful our Excel user Group members. > > Regards > Amar > > > > On Fri, Dec 14, 2012 at 11:24 AM, Deba Ranjan wrote: > >> Attachment missed... >> >> Hi Amar, >> >> PFA the chart sheet, might it will help you out. >> >> >> -deba >> >> >> >> Thanks & Regards, >> *Deba ranjan* >> >> >> >> >> >> >> On Fri, Dec 14, 2012 at 11:23 AM, Deba Ranjan wrote: >> >>> Hi Amar, >>> >>> PFA the chart sheet, might it will help you out. >>> >>> >>> -deba >>> >>> >>> >>> >>> >>> Thanks & Regards, >>> *Deba ranjan* >>> >>> >>> >>> >>> >>> >>> On Fri, Dec 14, 2012 at 11:05 AM, amar takale wrote: >>> >>>> Dear All Experts, >>>> Can you help me above two file,last week you help me which is very >>>> Helpful &knowledgeable for me.I love excel So in free time I do R&D in >>>> excel that time I search two file on internet. >>>> >>>> 1) In which two chart if I click sales then show Sales Chart,If I click >>>> Pat then show PAT Chart,then I decided to add more than two chart (Min 5 >>>> chart) in sheet but code is for only two chart Can you expand VBA code >>>> maximum 5 chart or more then I only click chart name & show that specific >>>> Chart& Other are hide.I had more R&D in that but not success. >>>> 2) On Internet I found photo file in which we can change brightness of >>>> photo but when I add my photo in excel that is not work, why?change picture >>>> name also. >>>> >>>> So Pls Guide me >>>> >>>> Appreciate the help. >>>> >>>> Regards >>>> Amar >>>> >>>> -- >>>> 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 post to this group, send email to excel-macros@googlegroups.com. >>>> To unsubscribe from this group, send email to >>>> excel-macros+unsubscr...@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>>> >>>> >>>> >>> >>> >> -- >> 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. >>
Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution
Attachment missed... Hi Amar, PFA the chart sheet, might it will help you out. -deba Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:23 AM, Deba Ranjan wrote: > Hi Amar, > > PFA the chart sheet, might it will help you out. > > > -deba > > > > > > Thanks & Regards, > *Deba ranjan* > > > > > > > On Fri, Dec 14, 2012 at 11:05 AM, amar takale wrote: > >> Dear All Experts, >> Can you help me above two file,last week you help me which is very >> Helpful &knowledgeable for me.I love excel So in free time I do R&D in >> excel that time I search two file on internet. >> >> 1) In which two chart if I click sales then show Sales Chart,If I click >> Pat then show PAT Chart,then I decided to add more than two chart (Min 5 >> chart) in sheet but code is for only two chart Can you expand VBA code >> maximum 5 chart or more then I only click chart name & show that specific >> Chart& Other are hide.I had more R&D in that but not success. >> 2) On Internet I found photo file in which we can change brightness of >> photo but when I add my photo in excel that is not work, why?change picture >> name also. >> >> So Pls Guide me >> >> Appreciate the help. >> >> Regards >> Amar >> >> -- >> 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 post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> > > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. series Chart.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Chart show & Hide-Request help for solution
Hi Amar, PFA the chart sheet, might it will help you out. -deba Thanks & Regards, *Deba ranjan* On Fri, Dec 14, 2012 at 11:05 AM, amar takale wrote: > Dear All Experts, > Can you help me above two file,last week you help me which is very > Helpful &knowledgeable for me.I love excel So in free time I do R&D in > excel that time I search two file on internet. > > 1) In which two chart if I click sales then show Sales Chart,If I click > Pat then show PAT Chart,then I decided to add more than two chart (Min 5 > chart) in sheet but code is for only two chart Can you expand VBA code > maximum 5 chart or more then I only click chart name & show that specific > Chart& Other are hide.I had more R&D in that but not success. > 2) On Internet I found photo file in which we can change brightness of > photo but when I add my photo in excel that is not work, why?change picture > name also. > > So Pls Guide me > > Appreciate the help. > > Regards > Amar > > -- > 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Formula to Calculate Age in Excel
Hi, if the date is (D111) - 12/20/1991, then for no. year : =DATEDIF(D111,TODAY(),"y") = 20 for no. of month : =DATEDIF(D111,TODAY(),"m") = 251 for no. of days : =DATEDIF(D111,TODAY(),"d") = 7658 --- and if you want link 20 years, some month and some days then - just chnage the text as - for count of year- =DATEDIF(D111,TODAY(),"y") = 20 days for count of month- =DATEDIF(D111,TODAY(),"ym") = 11 months for count of days = =DATEDIF(D111,TODAY(),"md") = 17 days -- deba Thanks & Regards, *Deba ranjan* On Fri, Dec 7, 2012 at 12:12 PM, Rakesh Kumar Sharma wrote: > Dear Team, > > Can you help me how to calculate age ( in Year, month & day) in Excel > > -- > Regards, > > Rakesh Kumar Sharma > Contact: +91-9971024741 > > > -- > 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.
Done !! Regards, Debaranjan Thanks & Regards, *Deba ranjan* On Sun, Nov 18, 2012 at 9:53 PM, Ayush Jain wrote: > Dear members, > > Let's get set for the new year 2013 > > Here is inviting you to participate in a quiz to make calendar for the new > year in excel. > > There are some rules to be followed : > 1) No macros to be used and should be formula based, only xlsx file to be > submitted. > 2) The calendar should be dynamic for any year, if you change the year , > the calendar should update automatically. > 3) The calendar should be in one sheet only > 4) The leap year should be considered. > 5) Last date to submit the calendar is 2nd December 2012 > 6) Make sure you create calendar yourself and do not download from anywhere > 7) Send your calendar to my email id - jainayush85[at]gmail.com. If you > post in the forum, there are chances people take reference from your > calendar. > 8) Once you send the calendar, you can reply to this post for the > confirmation. > > The following will add points to your calendar : > 1) Highlight current date > 2) Highlight bank/public holidays > 3) Calendar formatting and user friendliness > > There is a prize for the best calendar and recognition for the runner up. > Sponsors for the prize are invited, you can contact me if you want to be > sponsor. > > Looking forward to your active participation in the quiz. Let me know if > you have any queries. > > Many thanks for your contribution to this group. Keep it up > > Regards > Ayush Jain > Group Manager > > -- > 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ R-project
Hi All, Sorry, the r-project is not a part of this forum. But i just want to know if somebody might have some idea on this. Any one know about R-project ? if positive please let me know some tips. --Every body have right to know something then nothing !! Thanks & Regards, *Deba ranjan* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ How to shrink a picture in userform * *
you are welcome !! Thanks & Regards, *Deba ranjan* On Fri, Oct 12, 2012 at 4:21 PM, Hilary Lomotey wrote: > excellent Deba, it works. thanks > > On Fri, Oct 12, 2012 at 10:40 AM, Deba Ranjan wrote: > >> [image: Boxbe] <https://www.boxbe.com/overview> This message is >> eligible for Automatic Cleanup! (drdeva...@gmail.com) Add cleanup >> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DIV24O%252BE%252BSEf55ZTinRUco8g61un2u83T4Swibf%252F98O1Tl%252BebiE7pOF0Pl3H8j1cSaETX6pj4Ld5ZBBycD8yVEl6zMztDIdnPf09ixd58GvnECZMeA31FRLIeUiHXwJIz3lxgRIs4IJQ%253D%26key%3DtQKg0cxGGCi5v%252B88wgd56IY5PoTbhmIc8h5eyCs56vQ%253D&tc=12643475184_1129298209>| >> More >> info<http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12643475184_1129298209> >> >> Hi Hilary, >> >> After Inserting the Pic in the Userform, you need to go to the >> properties, >> and Select the -PictureSizeMode as 1. >> >> you can see the pic full. >> >> >> Thanks & Regards, >> *Deba ranjan * >> >> >> >> >> >> On Fri, Oct 12, 2012 at 4:03 PM, Hilary Lomotey wrote: >> >>> i have inserted a picture in a user form in the attached, however, i >>> cant see the whole picture in the userform only a minute portion, i need >>> assistance to shrink the picture in the userform to fit. in the excel sheet >>> itself i placed a picture there to give you an idea of the size that i want >>> it to appear on the userform if activated. thanks >>> >>> On Fri, Oct 12, 2012 at 10:23 AM, Swapnil Palande < >>> palande.swapni...@gmail.com> wrote: >>> >>>> [image: Boxbe] <https://www.boxbe.com/overview> This message is >>>> eligible for Automatic Cleanup! (palande.swapni...@gmail.com) Add >>>> cleanup >>>> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3Dnbh4O98vG0%252FGgrIeHYe0FTqAeOQAjJUt6R95tPlGzfLJgGjWBHC0P6ggDRdwHwOtpk7xb0%252B%252FNzY%252Fh2oh7nY1FvAep6DwhmfEXXySBlcDmXK%252FLHIF6oLSOKASfa0XbZHeM4Al3qV54wRvkijnkLuA9w%253D%253D%26key%3DKrHA7kFQFX1lMl4NfhAIkKQofFfto3fqE5xjclNUu5o%253D&tc=12643357478_1784932202>| >>>> More >>>> info<http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12643357478_1784932202> >>>> >>>> Hi, >>>> >>>> Didn't get what exactly you want, pls explain more. >>>> Regards, >>>> >>>> Swapnil. >>>> On Fri, Oct 12, 2012 at 3:27 PM, Hilary Lomotey wrote: >>>> >>>>> Hello Experts >>>>> >>>>> I'd like you to please help me in reducing both the height & width of >>>>> the picture (ie .- Go to VBA environment and open the userform )so >>>>> that the pic. overall size will appear smaller if the userform is >>>>> activated >>>>> such as the one in the excel sheet itself. >>>>> >>>>> thanks >>>>> >>>>> >>>>> >>>>> -- >>>>> Join official facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>> >>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> 6) Jobs posting is not allowed. >>>>> >>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >>>>> allowed. >>>>> >>>>> NOTE : Don't ever post personal or 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"
Re: $$Excel-Macros$$ How to shrink a picture in userform *
Hi Hilary, After Inserting the Pic in the Userform, you need to go to the properties, and Select the -PictureSizeMode as 1. you can see the pic full. Thanks & Regards, *Deba ranjan * On Fri, Oct 12, 2012 at 4:03 PM, Hilary Lomotey wrote: > i have inserted a picture in a user form in the attached, however, i cant > see the whole picture in the userform only a minute portion, i need > assistance to shrink the picture in the userform to fit. in the excel sheet > itself i placed a picture there to give you an idea of the size that i want > it to appear on the userform if activated. thanks > > On Fri, Oct 12, 2012 at 10:23 AM, Swapnil Palande < > palande.swapni...@gmail.com> wrote: > >> [image: Boxbe] <https://www.boxbe.com/overview> This message is >> eligible for Automatic Cleanup! (palande.swapni...@gmail.com) Add >> cleanup >> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3Dnbh4O98vG0%252FGgrIeHYe0FTqAeOQAjJUt6R95tPlGzfLJgGjWBHC0P6ggDRdwHwOtpk7xb0%252B%252FNzY%252Fh2oh7nY1FvAep6DwhmfEXXySBlcDmXK%252FLHIF6oLSOKASfa0XbZHeM4Al3qV54wRvkijnkLuA9w%253D%253D%26key%3DKrHA7kFQFX1lMl4NfhAIkKQofFfto3fqE5xjclNUu5o%253D&tc=12643357478_1784932202>| >> More >> info<http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12643357478_1784932202> >> >> Hi, >> >> Didn't get what exactly you want, pls explain more. >> Regards, >> >> Swapnil. >> On Fri, Oct 12, 2012 at 3:27 PM, Hilary Lomotey wrote: >> >>> Hello Experts >>> >>> I'd like you to please help me in reducing both the height & width of >>> the picture (ie .- Go to VBA environment and open the userform )so that >>> the pic. overall size will appear smaller if the userform is activated such >>> as the one in the excel sheet itself. >>> >>> thanks >>> >>> >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. >>> To unsubscribe from this group, send email to >>> excel-macros+unsubscr...@googlegroups.com. >>> >>> >>> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@google
Re: $$Excel-Macros$$ Convert to number
Hi Robin, can use this for cleaning the number:- =IFERROR(CLEAN(TRIM(A2)),"") Thanks & Regards, *Deba Ranjan P* On Mon, Sep 17, 2012 at 12:47 PM, Karan Singh wrote: > Hi Robinson, > > Use =trim(your number) > > Regards > Karan Singh > > > > > On Mon, Sep 17, 2012 at 12:41 PM, Robinson Boreh wrote: > >> Dear members, >> I have an excel sheet with numbers, but they contain a non numeral >> character at the end and i can not therefore sort nor do any mathematical >> function on the . Please assist with a formula of getting rid of the >> non-number characters so i can sort and add. >> >> Regards, >> Boreh >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012
Heartiest Congratulations brother. Thanks & Regards, *Deba Ranjan * On Mon, Sep 3, 2012 at 3:04 PM, Indrajit $nai wrote: > *Congrats Noorain. :)* > * > * > * > * > On Mon, Sep 3, 2012 at 11:59 AM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> Hi Noorain, >> >> Great job Dear, >> Congratulations !!! >> >> >> >> On Mon, Sep 3, 2012 at 10:40 AM, Seraj Alam wrote: >> >>> congrats noorain bhai. >>> >>> >>> On Mon, Sep 3, 2012 at 10:35 AM, अनिल नारायण गवली < >>> gawlianil8...@gmail.com> wrote: >>> >>>> Dear noorian, >>>> >>>> Congrats Dear..:) >>>> >>>> Thanks & Regards, >>>> Gawli Anil >>>> >>>> On Mon, Sep 3, 2012 at 10:20 AM, Kuldeep Singh >>> > wrote: >>>> >>>>> >>>>> Congrats Noorain Sir. >>>>> >>>>> Regards, >>>>> Kuldeep Singh >>>>> Back Office Executive (MIS) >>>>> Info Edge India Limited (naukri.com) >>>>> Phone.: +91-120-4763789, Extn.: 789 >>>>> naukrikuld...@gmail.com || www.naukri.com >>>>> *Please* *Consider the environment. Please don't print this e-mail >>>>> unless you really need to.* >>>>> >>>>> >>>>> On Sun, Sep 2, 2012 at 12:55 PM, Mohammed Muneer >>>>> wrote: >>>>> >>>>>> Dear Noor, >>>>>> >>>>>> ** ** >>>>>> >>>>>> Congratulations friend, this is a really a landmark on whole excel >>>>>> platform. >>>>>> >>>>>> ** ** >>>>>> >>>>>> U r doing a tremendously great job, by bringing untiring efforts from >>>>>> u r side to help all the group members – when they are at a stage of >>>>>> feeling helpless to solve the problems arising in excel formula, >>>>>> functions >>>>>> and vba. >>>>>> >>>>>> ** ** >>>>>> >>>>>> The problem in excel are mountain in size when coming to solve them >>>>>> by ourselves, but for u the problem is trivial and of mole sized. >>>>>> >>>>>> ** ** >>>>>> >>>>>> I am happy to hear from Mr. Ayush the excel macros group MVP. >>>>>> >>>>>> ** ** >>>>>> >>>>>> Fairly it’s worth sharing this moment with all of us, and getting the >>>>>> greetings from the group members. >>>>>> >>>>>> ** ** >>>>>> >>>>>> At last keep it up! >>>>>> >>>>>> ** ** >>>>>> >>>>>> Regards, >>>>>> >>>>>> Muneer, >>>>>> >>>>>> CC…. >>>>>> >>>>>> ** ** >>>>>> >>>>>> ** ** >>>>>> >>>>>> ** ** >>>>>> >>>>>> ** ** >>>>>> >>>>>> -- >>>>>> Join official facebook page of this forum @ >>>>>> https://www.facebook.com/discussexcel >>>>>> >>>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>>> >>>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>>> in signatures are prohibited. >>>>>> >>>>>> 6) Jobs posting is not allowed. >>>>>> >>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/the
Re: $$Excel-Macros$$ Cell show blank but in it show formula
Dear Amar, Use Iferror before the desire formula. you can use: =IFERROR(VLOOKUP(F5,$B$4:$D$9,3,0),"") Thanks & Regards, *Deba Ranjan P* On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote: > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012
My Heartiest Noorain Bro, congrts many more. Really heart of this members. Thanks & Regards, *Deba Ranjan P* On Sat, Aug 4, 2012 at 10:44 AM, अनिल नारायण गवली wrote: > congrats noorian ansari:) > Regards, > Gawli Anil > > On Sat, Aug 4, 2012 at 10:38 AM, Kuldeep Singh wrote: > >> >> Congratulations Noorain Sir. >> >> Regards, >> Kuldeep Singh >> Back Office Executive (MIS) >> Info Edge India Limited (naukri.com) >> Phone.: +91-120-4763789, Extn.: 789,9716615535 >> naukrikuld...@gmail.com || www.naukri.com || www.naukrigulf.com >> *Please* *Consider the environment. Please don't print this e-mail >> unless you really need to.* >> >> >> On Sat, Aug 4, 2012 at 10:35 AM, Rajan_Verma wrote: >> >>> *Congrats noorain. * >>> >>> * * >>> >>> * * >>> >>> *Regards* >>> >>> *Rajan verma* >>> >>> *+91 7838100659 [IM-Gtalk]* >>> >>> * * >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain >>> *Sent:* 03 August 2012 11:10 >>> >>> *To:* excel-macros >>> *Subject:* $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July >>> 2012 >>> >>> ** ** >>> >>> Dear members,**** >>> >>> >>> Noorain Ansari has been selected as 'Most Helpful Member' for the month >>> of July'12. He has posted 143 posts in July 2012 and helped many forum >>> members through his excel expertise. >>> >>> I truly appreciate his consistency and commitment to the group. He is >>> really doing great job. >>> >>> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, >>> Sunita and other folks for helping excel enthusiasts voluntarily !! >>> Keep posting. >>> >>> Regards, >>> >>> Ayush Jain >>> >>> Group Manager >>> >>> Microsoft MVP >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use c
Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text
Dear JP, See the attached, hope this too will help you for extracting text. Thanks & Regards, *Deba Ranjan P* On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI wrote: > Dear JP, > > Formula is working fine.. > Please see attached sheet. > > On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S < > bhat.jayaprak...@gmail.com> wrote: > >> Dear Experts, >> >> Good Morning. >> >> I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1 >> Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I >> required help to replace Olny the Text. >> >> enclosed sample file. Please help. >> >> Thank you. >> >> JP. >> >> -- >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. >> Forum owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> > > > -- > With Regards, > Noorain Ansari > http:// > <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> > http:// <http://www.excelvbaclinic.blogspot.com> > excelvbaclinic.blogspot.com <http://www.excelvbaclinic.blogspot.com> > http://accesssqclinic.blogspot.in/ > > > > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Number to be removed thru - Formula - plz Help (Vbsolved).xlsm Description: Binary data
Re: $$Excel-Macros$$ Please help me.
Dear Mangesh,
To create this calendar in the range B2:H9, follow these steps:
1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge &
Center.
2. Enter a date into the merged range. The day of the month isn’t important.
3. Enter the abbreviated day names in the range B3:H3.
Performing Magic with Array Formulas
4. Select B4:H9 and enter this array formula. Remember: To enter an array
formula, press
Ctrl+Shift+Enter (not just Enter).
{=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1))<>MONTH(DATE(YEAR(B2),
MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””,
DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONT
H(B2),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)}
5. Format the range B4:H9 to use this custom number format: d. This step
formats the
dates to show only the day. Use the Custom category in the Number tab of
the Format
Cells dialog box to specify this custom number format.
6. Adjust the column widths and format the cells as you like.
7. Change the month and year in cell B2. The calendar updates
automatically.
After creating this calendar, you can copy the range to any other worksheet
or workbook.
Thanks & Regards,
*Deba Ranjan P*
On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay wrote:
> Please tell us so that we can edit and learn it. How to make ?
> calender_Simple.xls file
>
>
> On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI > wrote:
>
>> Dear Manoj,
>>
>> Please find attached simple Calender.
>>
>> You can create it simply.
>>
>> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar > > wrote:
>>
>>> Dear Expert,
>>>
>>>
>>> I want to make Calender on excel
>>>
>>> when i enter year & month in a coll it show me date wise calender...
>>>
>>>
>>>
>>> Regard
>>> Manoj
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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 an
Re: $$Excel-Macros$$ Please help me.
Dear Manoj,
Calender in excel can be prepared by Array formula too, its purely full
array for whole the months and years.
=IF(MONTH(DATE(YEAR(C5),MONTH(C5),1))<>MONTH(DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)
Thanks & Regards,
*Deba Ranjan P*
On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar wrote:
> Dear Expert,
>
>
> I want to make Calender on excel
>
> when i enter year & month in a coll it show me date wise calender...
>
>
>
> Regard
> Manoj
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
yearly calendar.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Look up errors from 2 sheets.
Thanks Every greato great gurus. Thanks & Regards, *Deba Ranjan P* On Thu, Jul 12, 2012 at 9:36 AM, Seraj Alam wrote: > Hi, > > Please see attached solution of your query and let me knowis it full > fill your requirement or not??? > > > > On Tue, Jul 10, 2012 at 2:50 AM, Deba Ranjan wrote: > >> That is what the problem, i have like wise thousand datas which manually >> not possible to enter one by one, i want to look up by some eventual >> formulas. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Tue, Jul 10, 2012 at 3:17 PM, Norman Cliff May wrote: >> >>> The lookup names have to be entered the same on both sheets, some need a >>> space and some don't have a space. Look more closely at the ones that >>> yield #N/A. >>> >>> >>> On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan wrote: >>> >>>> Hi Experts, >>>> >>>> i am getting error in vlookups in finding the names from 2 sheets. >>>> i have used index, match formula, but still have some errors. Please look >>>> into this, might have lack of formulas in this. Please suggest what need to >>>> use in such cases. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> Thanks & Regards, >>>> *Deba Ranjan P* >>>> >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> To unsubscribe, send a blank email to >>>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-prom
Re: $$Excel-Macros$$ Text - Splitting - Help Required through Formula
Dear Jaya,
You can also use:-
First Word:-
=IFERROR(LEFT(A3,FIND(" ",A3,1)),"")
Second word-
=TRIM(IFERROR(LEFT(RIGHT(A3,LEN(A3)-FIND(" ",A3,1)),FIND("
",RIGHT(A3,LEN(A3)-FIND(" ",A3,1,""))
Third word:-
=RIGHT(A3,LEN(A3)-FIND("#",SUBSTITUTE(A3,"
","#",LEN(A3)-LEN(SUBSTITUTE(A3," ","")
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jul 11, 2012 at 5:26 PM, Manoj Kumar wrote:
> Dear JP,
>
> Select the range Press ALT+D+E Click Delimited Next Click Space Click
> Finish
> Regard
> Manoj
>
>
> On Wed, Jul 11, 2012 at 5:20 PM, Jayaprakash S > wrote:
>
>> Dear Masters,
>>
>> Greetings!!
>>
>> Could you please help me to split the Text thruough a Formula for the
>> attached example...
>>
>>
>> Thank you.
>>
>> JP.
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
--
FORUM RULES (986+ members already BANNED for violation)
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ no of sheets in a workbook
Dear Sunita Ji,
After Alt + F11,
Go to View And Select Project Explorer,
Selcect Projects Windows too, it will help to change its Properties.
Select the desrie requirements in the Project Explorer, Double click the
desire objects, you will find the codes. And refer the before attached file.
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jul 11, 2012 at 2:15 PM, सुनिता पौडेल wrote:
> Dear Deba ji,
>
> While I do Alt+f11 blank workbook shows. What to do?
> However I inserted userform and followed upto step 10. Here i got stuck.
> Do I have to copy the codes twice ? I am so blank
>
> Regrds
>
>
> On Wed, Jul 11, 2012 at 11:06 AM, Deba Ranjan wrote:
>
>> Dear Sunita Ji,
>>
>> Hope below step may help you, Rest By our Lovely Experts will
>> elaborate you more.
>>
>> 1. Go to Developer
>> 2. Click Insert
>> 3. Button (Form Control)
>> 4. Assign Macros to Buttons
>> 5. View Code (Alt + F11)
>> 6. We need 1 Userform, so insert userform
>> 7. Insert 1 List Box in the userform
>> 8. Insert 3 command buttons in the Userform
>> 9. Insert I checkBox
>> 10.Double click the desrire buttons or List box and Insert the codes.
>>(See the attached file of the user form and codes)
>> 11. Initialize UserForm and write code given below.
>>
>> See the attached file and by pressing Alt + F11 , please see the coding ,
>> hope you will understand the basic.
>>
>>
>>
>> Eg:-
>>
>> Option Explicit
>>
>> Public OriginalSheet As Object
>>
>> Private Sub CommandButton1_Click()
>> MsgBox Sheets.Count
>> End Sub
>>
>> Private Sub Label1_Click()
>>
>> End Sub
>>
>> Private Sub UserForm_Initialize()
>> ' Recorded by deba to show Sheet Names
>> Dim SheetData() As String
>> Dim ShtCnt As Integer
>> Dim ShtNum As Integer
>> Dim Sht As Object
>> Dim ListPos As Integer
>>
>> Set OriginalSheet = ActiveSheet
>> ShtCnt = ActiveWorkbook.Sheets.Count
>> ReDim SheetData(1 To ShtCnt, 1 To 4)
>> ShtNum = 1
>> For Each Sht In ActiveWorkbook.Sheets
>> If Sht.Name = ActiveSheet.Name Then _
>> ListPos = ShtNum - 1
>> SheetData(ShtNum, 1) = Sht.Name
>> Select Case TypeName(Sht)
>> Case "Worksheet"
>> SheetData(ShtNum, 2) = "Sheet"
>> SheetData(ShtNum, 3) = _
>> Application.CountA(Sht.Cells)
>> Case "Chart"
>> SheetData(ShtNum, 2) = "Chart"
>> SheetData(ShtNum, 3) = "N/A"
>> Case "DialogSheet"
>> SheetData(ShtNum, 2) = "Dialog"
>> SheetData(ShtNum, 3) = "N/A"
>> End Select
>> If Sht.Visible Then
>> SheetData(ShtNum, 4) = "True"
>> Else
>> SheetData(ShtNum, 4) = "False"
>> End If
>> ShtNum = ShtNum + 1
>> Next Sht
>> With ListBox1
>> .ColumnWidths = "100 pt;30 pt;40 pt;50 pt"
>> .List = SheetData
>> .ListIndex = ListPos
>> End With
>> End Sub
>>
>> Private Sub CancelButton_Click()
>> OriginalSheet.Activate
>> Unload Me
>> End Sub
>>
>> Private Sub cbPreview_Click()
>> If cbPreview Then Sheets(ListBox1.Value).Activate
>> End Sub
>>
>> Private Sub ListBox1_Click()
>> If cbPreview Then _
>> Sheets(ListBox1.Value).Activate
>> End Sub
>>
>> Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
>> Call OKButton_Click
>> End Sub
>>
>> Private Sub OKButton_Click()
>> Dim UserSheet As Object
>> Set UserSheet = Sheets(ListBox1.Value)
>> If UserSheet.Visible Then
>> UserSheet.Activate
>> Else
>> If MsgBox("Unhide sheet?", _
>> vbQuestion + vbYesNoCancel) = vbYes Then
>> UserSheet.Visible = True
>> UserSheet.Activate
>> Else
>> OriginalSheet.Activate
>> End If
>> End If
>> Unload Me
>> End Sub
>>
>>
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>>
>>
>>
>> On Wed, Jul 11, 2012 at 9:55 AM, सुनिता पौडेल wrote:
>>
>>> Dear Noorain, Don and all,
>>>
>&g
Re: $$Excel-Macros$$ Extracting a word from the cell.......
Hi Shai,
For First Word:-
=IFERROR(LEFT(G2,FIND(" ",G2,1)),"G2")
For Second:-
=IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND(" ",G2,1)),FIND("
",RIGHT(G2,LEN(G2)-FIND(" ",G2,1,"")
For third:-
=IFERROR(IF(LEN(C2&F2)+2>=LEN(G2),””,MID(G2,LEN(C2)+7,LEN(G2)-LEN(C2&F2)-7)),"")
For Forth:-
=IFERROR(RIGHT(G2,LEN(G2)-FIND("#",SUBSTITUTE(G2,"
","#",LEN(G2)-LEN(SUBSTITUTE(G2," ",""),"G2")
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jul 11, 2012 at 10:02 AM, Abdulgani Shaikh
wrote:
> This is really great !
>
> Suppose I want extract 2nd or 3rd or 4th word, then ?
>
> Regards
>
>
>
> On Wed, Jul 11, 2012 at 9:39 AM, Mohammed Muneer wrote:
>
>> Dear Don,
>>
>> Superb & Innovative.
>>
>> Keep it up!
>>
>> Both code and formula good.
>>
>> ** **
>>
>> ** **
>>
>> *“Experience is the mother of Knowledge”*
>>
>> * *
>>
>> Whenever I receive a help from u people, in a fraction of seconds I feel
>> myself why I can’t do this magic by myself.
>>
>> But I keep trying to do some until I get an idea.
>>
>> ** **
>>
>> But I never felt unhappy on my failure.
>>
>> ** **
>>
>> Pray for me, I will be one among u who r active hands for these group
>> members.
>>
>> ** **
>>
>> Lots of thanks…….
>>
>> ** **
>>
>> ** **
>>
>> Regards,
>>
>> Muneer,
>>
>> CC….
>>
>>
>>
>> ** **
>>
>> If you are saying you want the first word in a string then
>>
>> =LEFT(D10,FIND(" ",D10))
>>
>> or
>>
>>
>>
>> Sub fw()
>>
>> For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row
>>
>> Cells(i, "c").Value = Left(Cells(i, "d"), InStr(1, Cells(i, "d"), " "))**
>> **
>>
>> Next i
>>
>> End Sub
>>
>>
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>>
>>
>> *From:* Mohammed Muneer
>>
>> *Sent:* Tuesday, July 10, 2012 9:25 AM
>>
>> *To:* excel-macros@googlegroups.com
>>
>> *Subject:* $$Excel-Macros$$ Extracting a word from the cell...
>>
>>
>>
>>
>>
>> Hi! Everybody,
>>
>> Dear Group,
>>
>>
>>
>> I want to extract a word from the sentence in cell beside.
>>
>>
>>
>> Plz, find the attachment………
>>
>>
>>
>>
>>
>>
>>
>> Regards,
>>
>> Muneer,
>>
>> CC….
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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.
>>
>
Re: $$Excel-Macros$$ Re: Look up errors from 2 sheets.
Thanks Ji,but could you please solve in the sheet. Thanks & Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 4:08 PM, CoRe wrote: > Hello , > > > In case you have to files .xls and .xlsx you have to make formula with > Insert Function ( ALT + I + F ). > > instead of write =vlookup or =lookup > > give it a try. > > On Tuesday, July 10, 2012 12:23:47 PM UTC+3, Bhaity wrote: >> >> Hi Experts, >> >> i am getting error in vlookups in finding the names from 2 sheets. i >> have used index, match formula, but still have some errors. Please look >> into this, might have lack of formulas in this. Please suggest what need to >> use in such cases. >> >> >> >> >> >> >> >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Look up errors from 2 sheets.
That is what the problem, i have like wise thousand datas which manually not possible to enter one by one, i want to look up by some eventual formulas. Thanks & Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 3:17 PM, Norman Cliff May wrote: > The lookup names have to be entered the same on both sheets, some need a > space and some don't have a space. Look more closely at the ones that > yield #N/A. > > > On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan wrote: > >> Hi Experts, >> >> i am getting error in vlookups in finding the names from 2 sheets. i >> have used index, match formula, but still have some errors. Please look >> into this, might have lack of formulas in this. Please suggest what need to >> use in such cases. >> >> >> >> >> >> >> >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Unique Name Query
Hi Karan, PFA... Use this formula for unique extraction: =IFERROR(INDEX($A$1:$A$11,MATCH(0,COUNTIF($C$2:C2,$A$1:$A$11),0)),"") And for counting unique numbers: =SUM(1/COUNTIF(A1:A11,A1:A11)) Thanks & Regards, *Deba Ranjan P* On Sat, Jul 7, 2012 at 11:58 AM, Deba Ranjan wrote: > Hi Karan, > > Use this formula for unique extraction: > > =IFERROR(INDEX($A$1:$A$11,MATCH(0,COUNTIF($C$2:C2,$A$1:$A$11),0)),"") > > And for counting unique numbers: > > =SUM(1/COUNTIF(A1:A11,A1:A11)) -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Unique Name query.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Excel Function_Code
Hi Jai, what my logic is that , if i have many conditional formula as per the requirements of the data base, then we have create a lot function manually in the Visual application. So its very transparent that if already function code is written in the add - in , then repeatedly we don't have to write the function code again. directly we can use those function. As an example, there are 100 names which i need to concatenate in a single cell, so we need the a macros which we need to bring the name in a single cell. Like wise if many function already coded in the macros in Add-ins, then i hope it will be very easy to solve at a time without much effort and time. And in the first posting i have already attached one example for this. Please check. Thanks & Regards, *Deba Ranjan P* On Thu, Jul 5, 2012 at 11:39 AM, Jai wrote: > > Please tell me how can use this add in please send the example sheet > > Thanks > > > > > > > > > > > > > > > > > > > > > On Thu, Jul 5, 2012 at 9:52 AM, Deba Ranjan wrote: > >> Thanks Chile, >> Working fine. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Wed, Jul 4, 2012 at 9:19 PM, ChilExcel wrote: >> >>> Please see attached Add-Ins, I think is what you need >>> >>> open excel add ins and then search >>> >>> functions "user defined" >>> >>> you should always add add ins before using >>> >>> >>> Chilexcel >>> >>> >>> 2012/7/4 dguillett1 : >>> > http://www.add-in-express.com/docs/net-excel-xll-addins.php >>> > >>> > Don Guillett >>> > Microsoft Excel Developer >>> > SalesAid Software >>> > dguille...@gmail.com >>> > >>> > From: Deba Ranjan >>> > Sent: Wednesday, July 04, 2012 1:43 AM >>> > To: excel-macros@googlegroups.com >>> > Subject: $$Excel-Macros$$ Excel Function_Code >>> > >>> > Dear experts, >>> > >>> >i am keep on trying to make mention below function code >>> (concatenate) as >>> > Excel Add-ins. Can we make function as Add -ins ?. - whenever and >>> wherever >>> > we wish to insert the add-in function at any system it should work out. >>> > >>> >i have tried to save as add- in and after adding the add - in to the >>> > excel, it is not working. Any solution for this please. >>> > >>> > Note- Can we make in one single add- in more then 1 function ? >>> > >>> > Code:- >>> > Function Full_con(rng As Range) >>> > Dim cell As Range >>> > Dim str As String >>> > For Each cell In rng >>> > str = str & cell & " " & "," & " " >>> > Next cell >>> > str = VBA.Right(str, Len(str) - 1) >>> > Full_con = str >>> > End Function >>> > >>> > >>> > Thanks & Regards, >>> > Deba Ranjan P >>> > >>> > >>> > >>> > -- >>> > FORUM RULES (986+ members already BANNED for violation) >>> > >>> > 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) Cross-promotion of, or links to, forums competitive to this forum in >>> > signatures are prohibited. >>> > >>> > NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum >>> > owners and members are not responsible for any loss. >>> > >>> > >>> -- >>> > To post to this group, send email to excel-macros@googlegroups.com >>> > >>> > To unsubscribe, send a blank email to >>> > excel-macros+unsubscr...@googlegroups.com >>> > >>> &
Re: $$Excel-Macros$$ Excel Function_Code
Thanks Chile, Working fine. Thanks & Regards, *Deba Ranjan P* On Wed, Jul 4, 2012 at 9:19 PM, ChilExcel wrote: > Please see attached Add-Ins, I think is what you need > > open excel add ins and then search > > functions "user defined" > > you should always add add ins before using > > > Chilexcel > > > 2012/7/4 dguillett1 : > > http://www.add-in-express.com/docs/net-excel-xll-addins.php > > > > Don Guillett > > Microsoft Excel Developer > > SalesAid Software > > dguille...@gmail.com > > > > From: Deba Ranjan > > Sent: Wednesday, July 04, 2012 1:43 AM > > To: excel-macros@googlegroups.com > > Subject: $$Excel-Macros$$ Excel Function_Code > > > > Dear experts, > > > >i am keep on trying to make mention below function code (concatenate) > as > > Excel Add-ins. Can we make function as Add -ins ?. - whenever and > wherever > > we wish to insert the add-in function at any system it should work out. > > > >i have tried to save as add- in and after adding the add - in to the > > excel, it is not working. Any solution for this please. > > > > Note- Can we make in one single add- in more then 1 function ? > > > > Code:- > > Function Full_con(rng As Range) > > Dim cell As Range > > Dim str As String > > For Each cell In rng > > str = str & cell & " " & "," & " " > > Next cell > > str = VBA.Right(str, Len(str) - 1) > > Full_con = str > > End Function > > > > > > Thanks & Regards, > > Deba Ranjan P > > > > > > > > -- > > FORUM RULES (986+ members already BANNED for violation) > > > > 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) Cross-promotion of, or links to, forums competitive to this forum in > > signatures are prohibited. > > > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > > owners and members are not responsible for any loss. > > > > > -- > > To post to this group, send email to excel-macros@googlegroups.com > > > > To unsubscribe, send a blank email to > > excel-macros+unsubscr...@googlegroups.com > > > > -- > > FORUM RULES (986+ members already BANNED for violation) > > > > 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) Cross-promotion of, or links to, forums competitive to this forum in > > signatures are prohibited. > > > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > > owners and members are not responsible for any loss. > > > > > -- > > To post to this group, send email to excel-macros@googlegroups.com > > > > To unsubscribe, send a blank email to > > excel-macros+unsubscr...@googlegroups.com > > > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube.com/user/timextag41 > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12)
Verma Ji, congrates...very much Thanks & Regards, *Deba Ranjan P* On Thu, Jul 5, 2012 at 9:21 AM, Anil Gawli wrote: > heartly congrats Mr Rajan..:) > > Regards, > Gawli Anil. > > On Thu, Jul 5, 2012 at 8:32 AM, Raghav wrote: > >> Congratulations Rajan. >> >> ** ** >> >> Regards, >> >> Raghav >> >> Sr. Analyst >> >> Tata Teleservices Ltd. >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain >> *Sent:* Wednesday, July 04, 2012 9:47 PM >> >> *To:* excel-macros >> *Subject:* $$Excel-Macros$$ Rajan Verma - Most helpful Member(June >> '12) >> >> ** ** >> >> Hello Everyone, >> >> >> Rajan Verma has been selected as 'Most Helpful Member' for the month of >> June'2012. This is third time in row. :) >> He has posted 149 posts in June 2012 and helped many people through his >> expertise. >> >> I truly appreciate his consistency and commitment to group. He is really >> doing great job. >> >> >> Thanks to Noorain, Deba Ranjan, Don, David, Lalit, Lokesh, Hilary, Asa >> and other folks for helping excel enthusiasts voluntarily !! Keep it up !! >> >> >> >> >> Keep posting. >> >> Regards >> >> Ayush Jain >> >> Group Manager , Microsoft MVP >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ---
Re: $$Excel-Macros$$ Excel Function_Code
Any response please to my query ! Thanks & Regards, *Deba Ranjan P* On Wed, Jul 4, 2012 at 2:12 PM, Deba Ranjan wrote: > Any update please. can we make add-ins to this above query !! > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Wed, Jul 4, 2012 at 12:13 PM, Deba Ranjan wrote: > >> Dear experts, >> >>i am keep on trying to make mention below function code (concatenate) >> as Excel Add-ins. Can we make function as Add -ins ?. - whenever and >> wherever we wish to insert the add-in function at any system it should work >> out. >> >>i have tried to save as add- in and after adding the add - in to the >> excel, it is not working. Any solution for this please. >> >> Note- Can we make in one single add- in more then 1 function ? >> >> Code:- >> Function Full_con(rng As Range) >> Dim cell As Range >> Dim str As String >> For Each cell In rng >> str = str & cell & " " & "," & " " >> Next cell >> str = VBA.Right(str, Len(str) - 1) >> Full_con = str >> End Function >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Excel Function_Code
Any update please. can we make add-ins to this above query !! Thanks & Regards, *Deba Ranjan P* On Wed, Jul 4, 2012 at 12:13 PM, Deba Ranjan wrote: > Dear experts, > >i am keep on trying to make mention below function code (concatenate) > as Excel Add-ins. Can we make function as Add -ins ?. - whenever and > wherever we wish to insert the add-in function at any system it should work > out. > >i have tried to save as add- in and after adding the add - in to the > excel, it is not working. Any solution for this please. > > Note- Can we make in one single add- in more then 1 function ? > > Code:- > Function Full_con(rng As Range) > Dim cell As Range > Dim str As String > For Each cell In rng > str = str & cell & " " & "," & " " > Next cell > str = VBA.Right(str, Len(str) - 1) > Full_con = str > End Function > > > Thanks & Regards, > *Deba Ranjan P* > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Excel Function_Code
Dear experts, i am keep on trying to make mention below function code (concatenate) as Excel Add-ins. Can we make function as Add -ins ?. - whenever and wherever we wish to insert the add-in function at any system it should work out. i have tried to save as add- in and after adding the add - in to the excel, it is not working. Any solution for this please. Note- Can we make in one single add- in more then 1 function ? Code:- Function Full_con(rng As Range) Dim cell As Range Dim str As String For Each cell In rng str = str & cell & " " & "," & " " Next cell str = VBA.Right(str, Len(str) - 1) Full_con = str End Function -------- Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Function_Addin.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file
Well enjoyed the example the story of santa banta. good fun. Thanks & Regards, *Deba Ranjan P* On Tue, Jul 3, 2012 at 1:54 PM, Divaker Pandey wrote: > :) > As your question as my answer. > > Ek Bucket thi usme pani, patthar , aur lakdi ka tukda tha, uska weight 10 > kg tha. ab Shanta ne poocha Pani,pathar aur lakdi ka weight kitna hai, to > banta bola pehale pathar nikal do fir weight karo, ab jitna weight kam hoga > wo pathar ka weight hoga. aur same lakdi ke liye karo. last tumhe pathar, > lakdi aur pani ka weight pata chal jayega. > > hope you will got your answer. > > just take it as fun. > > Divaker > > > > On Tue, Jul 3, 2012 at 1:02 PM, LAKSHMAN PRASAD wrote: > >> >> Dear Expert, >> Is there any way to find out how much memory is being used by a excel >> sheet in particular excel file . >> Like I have a file named XYZ (5mb memory used ) and in this file have >> three sheet (sheet1, sheet2, sheet3) then how much memory used by sheets , >> sheet1-??? >> sheet2-??? >> sheet3-??? >> Total-5MB >> ** >> Regards >> *Lakshman Prasad* >> Manager (Finance) >> GAURSONS INDIA LIMITED >> Ph: +91 12 456777 Mob. No. 9582279261 >> Website: http://www.gaursonsindia.com/ >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
Dear Ashish and Dilip. Sorry for the delay, its a really awesome stage. heartiest congratulate to both and please keep helping to this group. Thanks & Regards, *Deba Ranjan P* On Mon, Jul 2, 2012 at 9:23 PM, vijayajith VA wrote: > CongratsASHISH *DILIP... > > > On Mon, Jul 2, 2012 at 9:18 PM, wrote: > >> ** >> Congratulation Ashish and Dilip. >> >> Sandeep Chhajer. >> Sent on my BlackBerry® from Vodafone >> -- >> *From: * Sam Mathai Chacko >> *Sender: * excel-macros@googlegroups.com >> *Date: *Mon, 2 Jul 2012 21:01:24 +0530 >> *To: * >> *ReplyTo: * excel-macros@googlegroups.com >> *Cc: *Dilip Pandey >> *Subject: *Re: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul >> and Dilip Pandey !! >> >> Excellent achievement once again by Ashish and Dilip. Kuddos to both. >> >> Regards, >> Sam Mathai Chacko >> >> On Mon, Jul 2, 2012 at 7:32 PM, ashish koul wrote: >> >>> Thank you all... >>> >>> >>> On Mon, Jul 2, 2012 at 4:39 PM, Amol Shrivastava wrote: >>> >>>> *Congratulations Ashish and Dilip...!!* >>>> >>>> -- >>>> Thanks & Regards, >>>> >>>> Amol Shrivastava >>>> +91 99671 18180 >>>> >>>> >>>> >>>> >>>> On Mon, Jul 2, 2012 at 4:35 PM, Aindril De wrote: >>>> >>>>> Congratulations Ashish and Dilip!! >>>>> Your Contributions have always been an asset to our group.. >>>>> >>>>> Hard Luck Don...!! >>>>> Your contributions have always been really helpful in our group.. >>>>> Better luck next time!! >>>>> >>>>> Cheers >>>>> Andy >>>>> >>>>> On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote: >>>>> >>>>>> Dear members, >>>>>> >>>>>> I am extremely happy to inform you that two members of the group are >>>>>> awarded Microsoft Most Valuable Professional Award. >>>>>> My heartiest congratulations to *Ashish koul* and *Dilip Pandey*and >>>>>> thanks for their big support to this forum. >>>>>> >>>>>> Keep posting ! >>>>>> >>>>>> Best regards, >>>>>> Ayush Jain >>>>>> Group Manager >>>>>> Microsoft MVP >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>> >>>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>>> in signatures are prohibited. >>>>>> >>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>> Forum owners and members are not responsible for any loss. >>>>>> >>>>>> >>>>>> -- >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> >>>>>> To unsubscribe, send a blank email to >>>>>> excel-macros+unsubscr...@googlegroups.com >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> Warm Regards, >>>>> Aindril De >>>>> Ph: 9811300157 >>>>> >>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
Re: $$Excel-Macros$$ Remove Punctuation
Yes hope show...
i have tried the coding provided by Lalit Ji, there i just made a very
small change in selection range, its fine working.
i have pasted the code in the desire sheet in VBA application and made
run , all the almost punctuation got removed. hence easily it was done.
Below the code:-
Remove Punction
Sub RemovePunctuation()
Dim arrPunc As Variant
Dim lngLoop As Long
Dim rngCol As Range
Dim rngRangeAs Range
arrPunc = Array(".", "!", ":", ";", "-", "#", "(", ")", "[", "]", "'",
"""", "/", ",")
Set rngRange = *Selection.SpecialCells(xlCellTypeConstants, 23)**
*
For Each rngCol In rngRange
If Not LCase(rngCol.Value) Like "*date*" Then
For lngLoop = LBound(arrPunc) To UBound(arrPunc) - 1
rngCol.EntireColumn.Replace What:=arrPunc(lngLoop),
Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
Next lngLoop
Else
For lngLoop = LBound(arrPunc) To UBound(arrPunc) - 1
If arrPunc(lngLoop) <> "/" Then
rngCol.EntireColumn.Replace What:=arrPunc(lngLoop),
Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
End If
Next lngLoop
End If
Next rngCol
MsgBox "Heelo its done"
End Sub
Thanks Experts.
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 27, 2012 at 6:35 PM, Rajan_Verma wrote:
> I think find and replace is best approach..
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anil Gawli
> *Sent:* 27 June 2012 3:15
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Remove Punctuation
>
> ** **
>
> pls find attached sheet
>
> On Wed, Jun 27, 2012 at 2:52 PM, Deba Ranjan wrote:*
> ***
>
> Sir,
>
> PFAand there are lots of punctuation which need to be clean.
>
> For cleaning and trimming the sheets i have used the code below mention
> and it is fine working:-
>
>
> Sub TrimCleanCells()
> Dim Rng As Range, myCell As Range
> Set Rng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants, 23)
> For Each myCell In Rng
> myCell.Value =
> WorksheetFunction.Trim(WorksheetFunction.Clean(myCell.Value))
> Next
> msgBox "you have cleaned and trimmed everything"
> End Sub
>
>
> But i unable to clean for Punctuation !!
>
>
> ** **
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
> ** **
>
>
>
>
>
> On Wed, Jun 27, 2012 at 2:46 PM, NOORAIN ANSARI
> wrote:
>
> Deba Please share your workbook
>
>
> On Wed, Jun 27, 2012 at 2:38 PM, Deba Ranjan wrote:
> > Dear experts,
> >
> >
> > Is there any VBA code to remove punctuation in a sheets ?
> >
> > -- i am doing it manually by ctr + H (replacing the desire
> punctuation
> > with "") and it takes many times to remove huge data.
> >
> > so is there any coding for removing punctuation at a time ?
> >
> >
> > Thanks & Regards,
> > Deba Ranjan P
> >
> >
> >
> > --
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 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) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > To
Re: $$Excel-Macros$$ Re: Remove Punctuation
Thanks Lait Ji,
Working fine.
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 27, 2012 at 4:20 PM, Lalit_Mohan wrote:
> Sub RemovePunctuation()
> Dim arrPunc As Variant
> Dim lngLoop As Long
> Dim rngCol As Range
> Dim rngRangeAs Range
>
>
> arrPunc = Array(".", "!", ":", ";", "-", "#", "(", ")", "[", "]", "'",
> """", "/", ",")
>
> Set rngRange = ActiveSheet.Range("A1:L1")
>
> For Each rngCol In rngRange
> If Not LCase(rngCol.Value) Like "*date*" Then
> For lngLoop = LBound(arrPunc) To UBound(arrPunc) - 1
> rngCol.EntireColumn.Replace What:=arrPunc(lngLoop),
> Replacement:="", LookAt:=xlPart, _
> SearchOrder:=xlByRows, MatchCase:=False,
> SearchFormat:=False, _
> ReplaceFormat:=False
> Next lngLoop
> Else
> For lngLoop = LBound(arrPunc) To UBound(arrPunc) - 1
> If arrPunc(lngLoop) <> "/" Then
> rngCol.EntireColumn.Replace What:=arrPunc(lngLoop),
> Replacement:="", LookAt:=xlPart, _
> SearchOrder:=xlByRows, MatchCase:=False,
> SearchFormat:=False, _
> ReplaceFormat:=False
> End If
> Next lngLoop
> End If
> Next rngCol
> End Sub
>
--
--
FORUM RULES (986+ members already BANNED for violation)
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Remove Punctuation
ok ok. thats true, any thanks Anil Ji, Thanks & Regards, *Deba Ranjan P* On Wed, Jun 27, 2012 at 4:02 PM, Anil Gawli wrote: > it is possible but how u hold the values and replace it with others, for > that u have to save the value as temp and then replace it. > > Regards, > Gawli Anil > > On Wed, Jun 27, 2012 at 3:43 PM, Deba Ranjan wrote: > >> Thanks Anil Ji, >> >> its superb working. Anil Ji, Is there any option for removing all the >> punctuation mark at a time with code and without userform help ? >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Wed, Jun 27, 2012 at 3:36 PM, Anil Gawli wrote: >> >>> sorry for wrong attachment >>> just see this attachment >>> >>> On Wed, Jun 27, 2012 at 3:30 PM, Anil Gawli wrote: >>> >>>> just press ctrl+shift+A >>>> it works now. >>>> Regards, >>>> Gawli Anil. >>>> >>>> On Wed, Jun 27, 2012 at 3:20 PM, Deba Ranjan wrote: >>>> >>>>> Anil Ji, >>>>> >>>>>That is working fine , Thanks.. >>>>> >>>>> Ok is there any coding for direct remove without user form. >>>>> --- i mean writing coding and run. >>>>> >>>>> Thanks again. >>>>> >>>>> >>>>> Thanks & Regards, >>>>> *Deba Ranjan P* >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Wed, Jun 27, 2012 at 3:15 PM, Anil Gawli >>>>> wrote: >>>>> >>>>>> pls find attached sheet >>>>>> >>>>>> >>>>>> On Wed, Jun 27, 2012 at 2:52 PM, Deba Ranjan wrote: >>>>>> >>>>>>> Sir, >>>>>>> >>>>>>> PFAand there are lots of punctuation which need to be clean. >>>>>>> >>>>>>> For cleaning and trimming the sheets i have used the code below >>>>>>> mention and it is fine working:- >>>>>>> >>>>>>> >>>>>>> Sub TrimCleanCells() >>>>>>> Dim Rng As Range, myCell As Range >>>>>>> Set Rng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants, 23) >>>>>>> For Each myCell In Rng >>>>>>> myCell.Value = >>>>>>> WorksheetFunction.Trim(WorksheetFunction.Clean(myCell.Value)) >>>>>>> Next >>>>>>> msgBox "you have cleaned and trimmed everything" >>>>>>> End Sub >>>>>>> >>>>>>> >>>>>>> But i unable to clean for Punctuation !! >>>>>>> >>>>>>> >>>>>>> Thanks & Regards, >>>>>>> *Deba Ranjan P* >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Wed, Jun 27, 2012 at 2:46 PM, NOORAIN ANSARI < >>>>>>> noorain.ans...@gmail.com> wrote: >>>>>>> >>>>>>>> Deba Please share your workbook >>>>>>>> >>>>>>>> On Wed, Jun 27, 2012 at 2:38 PM, Deba Ranjan >>>>>>>> wrote: >>>>>>>> > Dear experts, >>>>>>>> > >>>>>>>> > >>>>>>>> > Is there any VBA code to remove punctuation in a sheets ? >>>>>>>> > >>>>>>>> > -- i am doing it manually by ctr + H (replacing the desire >>>>>>>> punctuation >>>>>>>> > with "") and it takes many times to remove huge data. >>>>>>>> > >>>>>>>> > so is there any coding for removing punctuation at a time ? >>>>>>>> > >>>>>>>> > >>>>>>>> > Thanks & Regards, >>>>>>>> > Deba Ranjan P >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > -- >>>>>>>> > -- >>>>>>>> > FORUM RULES (986+ members already BANNED for violation) >>>>>>>> > >
Re: $$Excel-Macros$$ Remove Punctuation
Thanks Anil Ji, its superb working. Anil Ji, Is there any option for removing all the punctuation mark at a time with code and without userform help ? Thanks & Regards, *Deba Ranjan P* On Wed, Jun 27, 2012 at 3:36 PM, Anil Gawli wrote: > sorry for wrong attachment > just see this attachment > > On Wed, Jun 27, 2012 at 3:30 PM, Anil Gawli wrote: > >> just press ctrl+shift+A >> it works now. >> Regards, >> Gawli Anil. >> >> On Wed, Jun 27, 2012 at 3:20 PM, Deba Ranjan wrote: >> >>> Anil Ji, >>> >>>That is working fine , Thanks.. >>> >>> Ok is there any coding for direct remove without user form. >>> --- i mean writing coding and run. >>> >>> Thanks again. >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> >>> >>> On Wed, Jun 27, 2012 at 3:15 PM, Anil Gawli wrote: >>> >>>> pls find attached sheet >>>> >>>> >>>> On Wed, Jun 27, 2012 at 2:52 PM, Deba Ranjan wrote: >>>> >>>>> Sir, >>>>> >>>>> PFAand there are lots of punctuation which need to be clean. >>>>> >>>>> For cleaning and trimming the sheets i have used the code below >>>>> mention and it is fine working:- >>>>> >>>>> >>>>> Sub TrimCleanCells() >>>>> Dim Rng As Range, myCell As Range >>>>> Set Rng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants, 23) >>>>> For Each myCell In Rng >>>>> myCell.Value = >>>>> WorksheetFunction.Trim(WorksheetFunction.Clean(myCell.Value)) >>>>> Next >>>>> msgBox "you have cleaned and trimmed everything" >>>>> End Sub >>>>> >>>>> >>>>> But i unable to clean for Punctuation !! >>>>> >>>>> >>>>> Thanks & Regards, >>>>> *Deba Ranjan P* >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Wed, Jun 27, 2012 at 2:46 PM, NOORAIN ANSARI < >>>>> noorain.ans...@gmail.com> wrote: >>>>> >>>>>> Deba Please share your workbook >>>>>> >>>>>> On Wed, Jun 27, 2012 at 2:38 PM, Deba Ranjan >>>>>> wrote: >>>>>> > Dear experts, >>>>>> > >>>>>> > >>>>>> > Is there any VBA code to remove punctuation in a sheets ? >>>>>> > >>>>>> > -- i am doing it manually by ctr + H (replacing the desire >>>>>> punctuation >>>>>> > with "") and it takes many times to remove huge data. >>>>>> > >>>>>> > so is there any coding for removing punctuation at a time ? >>>>>> > >>>>>> > >>>>>> > Thanks & Regards, >>>>>> > Deba Ranjan P >>>>>> > >>>>>> > >>>>>> > >>>>>> > -- >>>>>> > -- >>>>>> > FORUM RULES (986+ members already BANNED for violation) >>>>>> > >>>>>> > 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) Cross-promotion of, or links to, forums competitive to this >>>>>> forum in >>>>>> > signatures are prohibited. >>>>>> > >>>>>> > NOTE : Don't ever post personal or confidential data in a workbook. >>>>>> Forum >>>>>> > owners and members are not responsible for any loss. >>>>>> > >>>>>> > >>>
Re: $$Excel-Macros$$ Remove Punctuation
Anil Ji, That is working fine , Thanks.. Ok is there any coding for direct remove without user form. --- i mean writing coding and run. Thanks again. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 27, 2012 at 3:15 PM, Anil Gawli wrote: > pls find attached sheet > > > On Wed, Jun 27, 2012 at 2:52 PM, Deba Ranjan wrote: > >> Sir, >> >> PFAand there are lots of punctuation which need to be clean. >> >> For cleaning and trimming the sheets i have used the code below mention >> and it is fine working:- >> >> >> Sub TrimCleanCells() >> Dim Rng As Range, myCell As Range >> Set Rng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants, 23) >> For Each myCell In Rng >> myCell.Value = >> WorksheetFunction.Trim(WorksheetFunction.Clean(myCell.Value)) >> Next >> msgBox "you have cleaned and trimmed everything" >> End Sub >> >> >> But i unable to clean for Punctuation !! >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Wed, Jun 27, 2012 at 2:46 PM, NOORAIN ANSARI < >> noorain.ans...@gmail.com> wrote: >> >>> Deba Please share your workbook >>> >>> On Wed, Jun 27, 2012 at 2:38 PM, Deba Ranjan >>> wrote: >>> > Dear experts, >>> > >>> > >>> > Is there any VBA code to remove punctuation in a sheets ? >>> > >>> > -- i am doing it manually by ctr + H (replacing the desire >>> punctuation >>> > with "") and it takes many times to remove huge data. >>> > >>> > so is there any coding for removing punctuation at a time ? >>> > >>> > >>> > Thanks & Regards, >>> > Deba Ranjan P >>> > >>> > >>> > >>> > -- >>> > -- >>> > FORUM RULES (986+ members already BANNED for violation) >>> > >>> > 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) Cross-promotion of, or links to, forums competitive to this forum in >>> > signatures are prohibited. >>> > >>> > NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum >>> > owners and members are not responsible for any loss. >>> > >>> > >>> -- >>> > To post to this group, send email to excel-macros@googlegroups.com >>> > >>> > To unsubscribe, send a blank email to >>> > excel-macros+unsubscr...@googlegroups.com >>> > >>> > >>> >>> >>> >>> -- >>> Thanks & regards, >>> Noorain Ansari >>> www.noorainansari.com >>> www.excelmacroworld.blogspot.com >>> >>> -- >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-m
Re: $$Excel-Macros$$ Seems Like comments but Not
Thanks all. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 18, 2012 at 11:27 PM, NOORAIN ANSARI wrote: > Dear Deba Ranjan, > > See attachment, we can create it from here. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Fri, Jun 15, 2012 at 3:59 PM, Deba Ranjan wrote: > >> Dear Experts, >> >> I show in the attached file, If we click in B2 cell to B5 cell, then >> some comments appears, actually I have notice that it is not a comments, >> Can you Please suggest what actually is ? >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> -- >> -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this >> forum in signatures are prohibited. NOTE : Don't ever post personal or >> confidential data in a workbook. Forum owners and members are not >> responsible for any loss. >> -- >> To post to this group, send email to excel-macros@googlegroups.com To >> unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Adding Auto Rows
Thanks Rajan ji, Is working fine. Dear Don ji, exactly the same you expect, i mean it should copy and past in the below row and correspondingly the same for other which is unique. Thanks all. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 18, 2012 at 9:02 PM, dguillett1 wrote: > As is often the case you do not fully explain. Do you want a BLANK row > below or copy (and insert) the value and what to do with > >Mah 5-10 L Aurangabad Mah 1-5 L Kolhapur > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Deba Ranjan > *Sent:* Monday, June 18, 2012 9:05 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Adding Auto Rows > > > Dear Experts, > > > > > Please find the attached file. There is 39 Unique name in MARKET NAME, in > every market name is double (compulsary double), if the market name is > single then we need to add one row for making double . > > Eg. if kolkata is single, so we need to add 1 row below the kolkata, is > there any macros or Formula to add row. > > > > > Thanks & Regards, > *Deba Ranjan P* > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Adding Auto Rows
Dear Experts, Please find the attached file. There is 39 Unique name in MARKET NAME, in every market name is double (compulsary double), if the market name is single then we need to add one row for making double . Eg. if kolkata is single, so we need to add 1 row below the kolkata, is there any macros or Formula to add row. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Adding Auto Rows.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Vba Password recovery & excel password remover
OK No issue broi was not ware of that. Thanks Thanks & Regards, *Deba Ranjan P* On Fri, Jun 15, 2012 at 10:38 AM, NOORAIN ANSARI wrote: > Hi Deba brother.. > > As per our forum rule, We can't share this type of information. > > Please read rule No. 3 > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Fri, Jun 15, 2012 at 10:34 AM, Deba Ranjan wrote: > >> Dear Experts, >> >> Is there any Vba Password recovery or cracker & excel password remover >> software available in Excel. >> >> >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ conditional formatting
Thanks rajan bro. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 6:41 PM, Rajan_Verma wrote: > See the attached file > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 13 June 2012 4:45 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ conditional formatting > > ** ** > > Dear Experts, > >I have attached a file which i need format conditional, i have tried > many times, but fail to do so. > My query is :- in K column, i want to format conditional, more then 4 > hours, red, and less then 4 hours yellow. (k cloumn consist formula, which > was solved by Norrain bro). > > Please solve > > > > > > Thanks & Regards, > *Deba Ranjan P* > > ** ** > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Sheet Requirements
Thanks man.. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 6:04 PM, dguillett1 wrote: > Sorry, I deleted it. You really need to try harder > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Deba Ranjan > *Sent:* Wednesday, June 13, 2012 7:13 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Sheet Requirements > > Thanks... Don bro, But still i have confusion on the coding. can > you please share with the attachment ? > i hope i will get more ideas on attached. > > thanks for that. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Wed, Jun 13, 2012 at 5:30 PM, dguillett1 wrote: > >> sub cs() >> ‘assumes your master sheet is the FIRST sheet >> dim I as long >> for I =2 to sheets.count >> sheets(i).usedrange.copy sheets(1).cells(rows.count,1).end(xlup)(2) >> next i >> end sub >> >> >> >> Don Guillett >> Microsoft MVP Excel >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Deba Ranjan >> *Sent:* Tuesday, June 12, 2012 11:43 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Sheet Requirements >> >> Thanks... >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Tue, Jun 12, 2012 at 9:43 PM, Mangesh Vimay >> wrote: >> >>> Hi Dear, >>> >>> It happens with everybody specially when someone tries to learn new >>> concepts of IT or any other topic. So keep going and this group is good to >>> help you. >>> >>> MangeSH >>> >>> On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan wrote: >>> >>>> Thanks. >>>>i love excel very much, Actually i keep on trying the coding But >>>> really i am so sorry that i really don't have this Idea. i purchased books >>>> for VBA macros and Excel, and i am trying my best to do so. Actually i am >>>> very new to this concepts (Means VBA coding). And even i am trying to >>>> learn from this group as well. >>>> I adopted to learn one by one. Let me tell you honestly, i have >>>> no system at my home. And what ever i learn, i learnt at Office but that >>>> too also i have many few times to learnt myself. So its my drawback. >>>> >>>> i hope i would able very few things a day, Any way thanks for >>>> suggesting that. i will keep trying. i have very confusion in coding when i >>>> go trough the books. Like String, long etc. >>>> >>>> >>>> Thanks & Regards, >>>> *Deba Ranjan P* >>>> >>>> >>>> >>>> >>>> >>>> On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 wrote: >>>> >>>>>Forgive me but as I recall you have been a part of this group for >>>>> awhile. If so, you should have learned enough to do this yourself. >>>>> >>>>> Don Guillett >>>>> Microsoft MVP Excel >>>>> SalesAid Software >>>>> dguille...@gmail.com >>>>> >>>>> *From:* Deba Ranjan >>>>> *Sent:* Tuesday, June 12, 2012 6:45 AM >>>>> *To:* excel-macros@googlegroups.com >>>>> *Subject:* $$Excel-Macros$$ Sheet Requirements >>>>> >>>>> Dear Experts, >>>>> >>>>> i have attached a file which contains many sheets. in every sheets >>>>> there contains data. i want a button which on clicking the whole sheet >>>>> data >>>>> consolidated. Please find the attached. >>>>> >>>>> thanks... >>>>> >>>>> >>>>> Thanks & Regards, >>>>> *Deba Ranjan P* >>>>> >>>>> >>>>> >>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 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. >>>>>
Re: $$Excel-Macros$$ Sheet Requirements
Thanks Anil Ji,.very thanks and the other members. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 5:54 PM, Anil Gawli wrote: > see the attached sheet > > On Wed, Jun 13, 2012 at 5:43 PM, Deba Ranjan wrote: > >> Thanks... Don bro, But still i have confusion on the coding. >> can you please share with the attachment ? >> i hope i will get more ideas on attached. >> >> thanks for that. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Wed, Jun 13, 2012 at 5:30 PM, dguillett1 wrote: >> >>> sub cs() >>> ‘assumes your master sheet is the FIRST sheet >>> dim I as long >>> for I =2 to sheets.count >>> sheets(i).usedrange.copy sheets(1).cells(rows.count,1).end(xlup)(2) >>> next i >>> end sub >>> >>> >>> >>> Don Guillett >>> Microsoft MVP Excel >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Deba Ranjan >>> *Sent:* Tuesday, June 12, 2012 11:43 PM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* Re: $$Excel-Macros$$ Sheet Requirements >>> >>> Thanks... >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> >>> >>> On Tue, Jun 12, 2012 at 9:43 PM, Mangesh Vimay >> > wrote: >>> >>>> Hi Dear, >>>> >>>> It happens with everybody specially when someone tries to learn new >>>> concepts of IT or any other topic. So keep going and this group is good to >>>> help you. >>>> >>>> MangeSH >>>> >>>> On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan wrote: >>>> >>>>> Thanks. >>>>>i love excel very much, Actually i keep on trying the coding >>>>> But really i am so sorry that i really don't have this Idea. i purchased >>>>> books for VBA macros and Excel, and i am trying my best to do so. Actually >>>>> i am very new to this concepts (Means VBA coding). And even i am trying >>>>> to >>>>> learn from this group as well. >>>>> I adopted to learn one by one. Let me tell you honestly, i have >>>>> no system at my home. And what ever i learn, i learnt at Office but that >>>>> too also i have many few times to learnt myself. So its my drawback. >>>>> >>>>> i hope i would able very few things a day, Any way thanks for >>>>> suggesting that. i will keep trying. i have very confusion in coding when >>>>> i >>>>> go trough the books. Like String, long etc. >>>>> >>>>> >>>>> Thanks & Regards, >>>>> *Deba Ranjan P* >>>>> >>>>> >>>>> **** >>>>> >>>>> >>>>> On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 wrote: >>>>> >>>>>>Forgive me but as I recall you have been a part of this group for >>>>>> awhile. If so, you should have learned enough to do this yourself. >>>>>> >>>>>> Don Guillett >>>>>> Microsoft MVP Excel >>>>>> SalesAid Software >>>>>> dguille...@gmail.com >>>>>> >>>>>> *From:* Deba Ranjan >>>>>> *Sent:* Tuesday, June 12, 2012 6:45 AM >>>>>> *To:* excel-macros@googlegroups.com >>>>>> *Subject:* $$Excel-Macros$$ Sheet Requirements >>>>>> >>>>>> Dear Experts, >>>>>> >>>>>> i have attached a file which contains many sheets. in every >>>>>> sheets there contains data. i want a button which on clicking the whole >>>>>> sheet data consolidated. Please find the attached. >>>>>> >>>>>> thanks... >>>>>> >>>>>> >>>>>> Thanks & Regards, >>>>>> *Deba Ranjan P* >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>> >>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>
Re: $$Excel-Macros$$ Sheet Requirements
Thanks... Don bro, But still i have confusion on the coding. can you please share with the attachment ? i hope i will get more ideas on attached. thanks for that. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 5:30 PM, dguillett1 wrote: > sub cs() > ‘assumes your master sheet is the FIRST sheet > dim I as long > for I =2 to sheets.count > sheets(i).usedrange.copy sheets(1).cells(rows.count,1).end(xlup)(2) > next i > end sub > > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Deba Ranjan > *Sent:* Tuesday, June 12, 2012 11:43 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Sheet Requirements > > Thanks... > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Tue, Jun 12, 2012 at 9:43 PM, Mangesh Vimay wrote: > >> Hi Dear, >> >> It happens with everybody specially when someone tries to learn new >> concepts of IT or any other topic. So keep going and this group is good to >> help you. >> >> MangeSH >> >> On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan wrote: >> >>> Thanks. >>>i love excel very much, Actually i keep on trying the coding But >>> really i am so sorry that i really don't have this Idea. i purchased books >>> for VBA macros and Excel, and i am trying my best to do so. Actually i am >>> very new to this concepts (Means VBA coding). And even i am trying to >>> learn from this group as well. >>> I adopted to learn one by one. Let me tell you honestly, i have no >>> system at my home. And what ever i learn, i learnt at Office but that too >>> also i have many few times to learnt myself. So its my drawback. >>> >>> i hope i would able very few things a day, Any way thanks for >>> suggesting that. i will keep trying. i have very confusion in coding when i >>> go trough the books. Like String, long etc. >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> >>> >>> On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 wrote: >>> >>>> Forgive me but as I recall you have been a part of this group for >>>> awhile. If so, you should have learned enough to do this yourself. >>>> >>>> Don Guillett >>>> Microsoft MVP Excel >>>> SalesAid Software >>>> dguille...@gmail.com >>>> >>>> *From:* Deba Ranjan >>>> *Sent:* Tuesday, June 12, 2012 6:45 AM >>>> *To:* excel-macros@googlegroups.com >>>> *Subject:* $$Excel-Macros$$ Sheet Requirements >>>> >>>> Dear Experts, >>>> >>>> i have attached a file which contains many sheets. in every sheets >>>> there contains data. i want a button which on clicking the whole sheet data >>>> consolidated. Please find the attached. >>>> >>>> thanks... >>>> >>>> >>>> Thanks & Regards, >>>> *Deba Ranjan P* >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> To unsubscribe, send a blank email to >>>> mailto:excel-macros%2bunsubscr...@googlegroups.com >>>> -- >>>> FORUM RULES (986+ members
Re: $$Excel-Macros$$ conditional formatting
Thanks bro.. awesome. Thnks again Thanks & Regards, *Deba Ranjan P* On Wed, Jun 13, 2012 at 4:49 PM, NOORAIN ANSARI wrote: > Dear Deba, > > See attached Sheet. > > for Red you use.. > > =Hour($A1)>4 > > and for yellow > > =Hour($A1)<4 > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > On Wed, Jun 13, 2012 at 4:44 PM, Deba Ranjan wrote: > >> Dear Experts, >> >>I have attached a file which i need format conditional, i have tried >> many times, but fail to do so. >> My query is :- in K column, i want to format conditional, more then 4 >> hours, red, and less then 4 hours yellow. (k cloumn consist formula, which >> was solved by Norrain bro). >> >> Please solve >> >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ conditional formatting
Dear Experts, I have attached a file which i need format conditional, i have tried many times, but fail to do so. My query is :- in K column, i want to format conditional, more then 4 hours, red, and less then 4 hours yellow. (k cloumn consist formula, which was solved by Norrain bro). Please solve Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Time calculation(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Sheet Requirements
Thanks... Thanks & Regards, *Deba Ranjan P* On Tue, Jun 12, 2012 at 9:43 PM, Mangesh Vimay wrote: > Hi Dear, > > It happens with everybody specially when someone tries to learn new > concepts of IT or any other topic. So keep going and this group is good to > help you. > > MangeSH > > On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan wrote: > >> Thanks. >>i love excel very much, Actually i keep on trying the coding But >> really i am so sorry that i really don't have this Idea. i purchased books >> for VBA macros and Excel, and i am trying my best to do so. Actually i am >> very new to this concepts (Means VBA coding). And even i am trying to >> learn from this group as well. >> I adopted to learn one by one. Let me tell you honestly, i have no >> system at my home. And what ever i learn, i learnt at Office but that too >> also i have many few times to learnt myself. So its my drawback. >> >> i hope i would able very few things a day, Any way thanks for >> suggesting that. i will keep trying. i have very confusion in coding when i >> go trough the books. Like String, long etc. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 wrote: >> >>> Forgive me but as I recall you have been a part of this group for >>> awhile. If so, you should have learned enough to do this yourself. >>> >>> Don Guillett >>> Microsoft MVP Excel >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Deba Ranjan >>> *Sent:* Tuesday, June 12, 2012 6:45 AM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* $$Excel-Macros$$ Sheet Requirements >>> >>> Dear Experts, >>> >>> i have attached a file which contains many sheets. in every sheets >>> there contains data. i want a button which on clicking the whole sheet data >>> consolidated. Please find the attached. >>> >>> thanks... >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> exc
Re: $$Excel-Macros$$ Sheet Requirements
Thanks. i love excel very much, Actually i keep on trying the coding But really i am so sorry that i really don't have this Idea. i purchased books for VBA macros and Excel, and i am trying my best to do so. Actually i am very new to this concepts (Means VBA coding). And even i am trying to learn from this group as well. I adopted to learn one by one. Let me tell you honestly, i have no system at my home. And what ever i learn, i learnt at Office but that too also i have many few times to learnt myself. So its my drawback. i hope i would able very few things a day, Any way thanks for suggesting that. i will keep trying. i have very confusion in coding when i go trough the books. Like String, long etc. Thanks & Regards, *Deba Ranjan P* On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 wrote: > Forgive me but as I recall you have been a part of this group for > awhile. If so, you should have learned enough to do this yourself. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Deba Ranjan > *Sent:* Tuesday, June 12, 2012 6:45 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Sheet Requirements > > Dear Experts, > > i have attached a file which contains many sheets. in every sheets > there contains data. i want a button which on clicking the whole sheet data > consolidated. Please find the attached. > > thanks... > > > Thanks & Regards, > *Deba Ranjan P* > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Sheet Requirements
Dear Experts, i have attached a file which contains many sheets. in every sheets there contains data. i want a button which on clicking the whole sheet data consolidated. Please find the attached. thanks... Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Conso_Dash_bd.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Concatenate Problem.
Thanks group for wonderful Ideas. thank you very much.. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:46 PM, Ahmed Honest wrote: > Rajan, > > 100% agreed, formulae of all Ms Excel can't be compare to the versality of > VBA. My solution is just one more way and yes it will take more time or > whatever it is. Moreover to give one more easy way it is answered. Know the > end user who posted the query has alternate one which ever he/she feels > like will achieve the objective as per his requirement/convenance. > > I hope know you know it very well right ? > > > > > On Mon, Jun 11, 2012 at 4:08 PM, Rajan_Verma wrote: > >> I would also like to know , how will you concatenate 1000 strings without >> VBA. >> >> ** ** >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Ahmed Honest >> *Sent:* 11 June 2012 6:26 >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Concatenate Problem. >> >> ** ** >> >> Hi Deba, >> >> >> >> the same can be achieved without VBA let me know if you wish to have >> that. Just send me your file. I will send you the solution. >> >> >> >> >> >> >> >> On Mon, Jun 11, 2012 at 3:54 PM, Deba Ranjan wrote: >> >> >> Thanks.. >> >> >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> ** ** >> >> >> >> >> >> On Mon, Jun 11, 2012 at 6:22 PM, Rajan_Verma >> wrote: >> >> The sorter one: No Loops Required >> >> >> >> *If your data is Vertical then use this* >> >> >> >> Function ConcatAll(rngRange As Range) As String >> >> ConcatAll = *Join*(Application.Transpose(rngRange), ",") >> >> End Function**** >> >> >> >> If your Data is horizontal then use this >> >> >> >> >> >> Function ConcatAll(rngRange As Range) As String >> >> ConcatAll = >> *Join*(Application.Transpose(Application.Transpose(rngRange)), >> ",") >> >> End Function >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan >> *Sent:* 11 June 2012 5:55 >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Concatenate Problem. >> >> >> >> Thanks .very >> >> >> **** >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> ** ** >> >> On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI >> wrote: >> >> See attached sheet. >> >> **** >> >> On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI >> wrote: >> >> Dear Deba, >> >> Please try below UDF, See attached sheet.. >> >> *Function Concatenate_Deba(rng As Range) >> Dim cell As Range >> Dim str As String >> For Each cell In rng >> str = str & cell & "," >> Next cell >> str = VBA.Right(str, Len(str) - 1) >> Concatenate_Deba = str >> End Function >> * >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> >> www.excelmacroworld.blogspot.com >> >> >> >> On Mon, Jun 11, 2012 at 5:35 PM, Deba Ranjan wrote: >> >> >> Dear experts, >> Please find the attached file. There is 568 names listed in >> A2, I want the whole names should come in one single cell with comma. >> Please.. >> >> >> >> >> >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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
Re: $$Excel-Macros$$ Concatenate Problem.
Ahmed ji..i think the file is already attached in this group. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:26 PM, Ahmed Honest wrote: > . -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Concatenate Problem.
Thanks.. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 6:22 PM, Rajan_Verma wrote: > The sorter one: No Loops Required > > ** ** > > *If your data is Vertical then use this* > > ** ** > > Function ConcatAll(rngRange As Range) As String > > ConcatAll = *Join*(Application.Transpose(rngRange), ",") > > End Function > > ** ** > > If your Data is horizontal then use this > > ** ** > > ** ** > > Function ConcatAll(rngRange As Range) As String > > ConcatAll = *Join*(Application.Transpose(Application.Transpose(rngRange)), > ",") > > End Function > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 11 June 2012 5:55 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Concatenate Problem. > > ** ** > > Thanks .very > > > > > Thanks & Regards, > *Deba Ranjan P* > > ** ** > > > > > > On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI > wrote: > > See attached sheet. > > ** ** > > On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI > wrote: > > Dear Deba, > > Please try below UDF, See attached sheet.. > > *Function Concatenate_Deba(rng As Range) > Dim cell As Range > Dim str As String > For Each cell In rng > str = str & cell & "," > Next cell > str = VBA.Right(str, Len(str) - 1) > Concatenate_Deba = str > End Function > * > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > > www.excelmacroworld.blogspot.com > > ** ** > > On Mon, Jun 11, 2012 at 5:35 PM, Deba Ranjan wrote:* > *** > > Dear experts, > Please find the attached file. There is 568 names listed in > A2, I want the whole names should come in one single cell with comma. > Please.. > > > > > > > > Thanks & Regards, > *Deba Ranjan P* > > ** ** > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > > > > ** ** > > ** ** > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > > www.excelmacroworld.blogspot.com > > > > > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Proble
Re: $$Excel-Macros$$ Concatenate Problem.
Thanks .very Thanks & Regards, *Deba Ranjan P* On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI wrote: > See attached sheet. > > > On Mon, Jun 11, 2012 at 5:51 PM, NOORAIN ANSARI > wrote: > >> Dear Deba, >> >> Please try below UDF, See attached sheet.. >> >> *Function Concatenate_Deba(rng As Range) >> Dim cell As Range >> Dim str As String >> For Each cell In rng >> str = str & cell & "," >> Next cell >> str = VBA.Right(str, Len(str) - 1) >> Concatenate_Deba = str >> End Function >> * >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> On Mon, Jun 11, 2012 at 5:35 PM, Deba Ranjan wrote: >> >>> Dear experts, >>> Please find the attached file. There is 568 names listed in >>> A2, I want the whole names should come in one single cell with comma. >>> Please.. >>> >>> >>> >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >> >> >> >> >> >> >> >> > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Concatenate Problem.
Dear experts, Please find the attached file. There is 568 names listed in A2, I want the whole names should come in one single cell with comma. Please.. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com concetenate_work.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Introduce Yourself !!
Dear Beloved groups, Sorry for the delay, Hi, i am Deba ranjan, Basically i am from Assam and i am *20* years old. i started currently working in organization for past 1 years as back-end Team operation in Chennai and i am pursuing my b.com in part time. i am very very much love with excel and its feature. honestly let me tell you all, i am very new to VBA code and macros and etc. Even i study by through this forum and by various websites, i need a personnel guidelines in coding. Please guys its me personnel heartiest request to direct me in the excel way coding. thanking you guys. Mail - ID :- drdeva...@gmail.com "its my luck who have pull me in to this forum" Thanks & Regards, *Deba Ranjan P* *91-9025144777* On Sun, Jun 10, 2012 at 10:44 PM, dguillett1 wrote: > > BBA University of Texas 1959, Graduate studies at UT law school and NYU. > Ex US Air Force Officer. > I am a retired Regional Manager for ING and held a stock brokers series 7 > license and insurance license. > To keep myself busy, I am an independent Excel Developer for projects > large and small and Excel MVP for years on other forums > > For many years I was also a road race car driver holding an International > FIA racing license and race driving instructor. > driving SCCA EP MGB, Formula Ford, and Formula 2 open wheel single seat > race cars in the US and Mexico. > > I live in beautiful Austin Texas on the top of a hill with a view of the > lake and at age 76 I do only what I want to do. It is really nice > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Ayush Jain > *Sent:* Sunday, June 10, 2012 11:47 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Introduce Yourself !! > > Dear all, > > Good to know you all and feels proud to be part of this forum. > > Let me introduce myself. > > I am Ayush Jain from Delhi, India. Presently working as senior analyst in > Ernst & Young and my work includes bulding Excel & Access based models for > clients for analysis, reporting, planning etc. > > I started this forum 5 years back with the aim to provide quality > solutions for excel and vba queries & I am quite happy to see what we are > today. > This is one of the largest forum which is spam free and always buzzing > with activity. > > I have received Microsoft MVP award in 2010 & 2011 for my voluntry > contribution to various communities in excel. For more details:-Please > visit my MVP profile <http://mvp.microsoft.com/profiles/Ayush> > > I really appreciate the forum members for their active paticipation and > voluntry help to others. If you have any > feedback<http://www.surveymonkey.com/s/3WM3FYH>, > click here <http://www.surveymonkey.com/s/3WM3FYH>. > Keep introducing yourself!! > > Many Thanks. > -Ayush Jain > Group Manager / Microsoft MVP > > On Sun, Jun 10, 2012 at 2:23 PM, David Grugeon wrote: > >> Hi all 'Excel'lent people >> >> This is David Grugeon from Brisbane Australia. >> >> I work as an accountant/consultant for local governments - mainly one in >> Thargomindah which is 1000 Km west of Brisbane and one in Thursday Island >> which is 2000 Km North. >> >> I use excel all the time for work and am currently working on the Budget >> for Bulloo Shire Council (Thargomindah) with about ten interlinked >> workbooks with many sheets each. I use VBA a lot where it saves me time. >> I think I have quite good Excel skills developed by helping others on >> groups like this one. If you try to answer the questions you learn a lot >> which you can use in the future. >> >> If oyu are interested Bulloo Shire council has an area of about 83000 sq >> Km (about half the size of England) and a population of about 600. >> Thursday island is the administrative centre for four islands (Thursday, >> Horn, Prince of Wales, and Goods Islands) in the Torres Strait between >> Australia and Papua New Guinea. >> >> I am 69 in a few days and lived in England until I was 47. >> >> I hope I am able to help you guys and I am sure I will learn a lot as >> well. >> >> Best regards >> David Grugeon >> >> >> On 10 June 2012 16:47, wrote: >> >>> ** >>> Hi Excel Buddies! >>> >>> My name is Pooja Sharma, I'm from New Delhi. Working as Lead into >>> Financial Closing and Reporting with a Gurgaon based MNC. >>> Apart from my work, I like to travel, enjoy most forms of music, playing >>> Table Tennis, Gardening. >>> Excel plays major supportive role in a
Re: $$Excel-Macros$$ Edit Cell
Thanks Lovely members. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 8:01 PM, dguillett1 wrote: > Unlock all you want to allow > lock that one > protect sheet > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Deba Ranjan > *Sent:* Friday, June 08, 2012 9:07 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Edit Cell > > Dear > > Its is possible to Lock a particular cell only, I mean user cant > able to edit this cell only, rest they can able to edit. Even the E3 cell > should not be able to edit, Rest can be edit. Please see the attached. > thank you. > > > Thanks & Regards, > *Deba Ranjan P* > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Edit Cell
Yes, Yes, its superb working thanks for the guides...Tnks Hilary & Noorain and Rest of this members. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:52 PM, hilary lomotey wrote: > select all the cells, press ctrl +1 go to the protection tab, uncheck the > lock button, click ok, and then select the cell you want to lock and click > on ctrl +1 go to protection tab and check lock. click ok, go to review > ribbon and click on protect , ok, you shd be fine > > > On Fri, Jun 8, 2012 at 2:17 PM, NOORAIN ANSARI > wrote: > >> Hi Deba, >> >> Please check cell no. E3 in Sheet1, It is working fine with me. >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> On Fri, Jun 8, 2012 at 7:43 PM, Deba Ranjan wrote: >> >>> Sir, >>> >>> The file you have attached is the same that i have attached. Please >>> kindly check. Thanks for the same. >>> >>> >>> Thanks & Regards, >>> *Deba Ranjan P* >>> >>> >>> >>> >>> >>> On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI >> > wrote: >>> >>>> Dear Deba, >>>> >>>> Please see attached sheet, >>>> >>>> If you have any query, Please reply >>>> >>>> >>>> On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: >>>> >>>>> Dear >>>>> >>>>> Its is possible to Lock a particular cell only, I mean user >>>>> cant able to edit this cell only, rest they can able to edit. Even the E3 >>>>> cell should not be able to edit, Rest can be edit. Please see the >>>>> attached. >>>>> thank you. >>>>> >>>>> >>>>> Thanks & Regards, >>>>> *Deba Ranjan P* >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> >>>>> >>>>> -- >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> To unsubscribe, send a blank email to >>>>> excel-macros+unsubscr...@googlegroups.com >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> ---
Re: $$Excel-Macros$$ Edit Cell
Thanks , It is possible for A2:A7 range including with E3, i mean for E3, its fine, It s possible for A2 to A7 also the same lock. Please sir, Explain in details how you did !!! Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:47 PM, NOORAIN ANSARI wrote: > Hi Deba, > > Please check cell no. E3 in Sheet1, It is working fine with me. > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > On Fri, Jun 8, 2012 at 7:43 PM, Deba Ranjan wrote: > >> Sir, >> >>The file you have attached is the same that i have attached. Please >> kindly check. Thanks for the same. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI >> wrote: >> >>> Dear Deba, >>> >>> Please see attached sheet, >>> >>> If you have any query, Please reply >>> >>> >>> On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: >>> >>>> Dear >>>> >>>> Its is possible to Lock a particular cell only, I mean user >>>> cant able to edit this cell only, rest they can able to edit. Even the E3 >>>> cell should not be able to edit, Rest can be edit. Please see the attached. >>>> thank you. >>>> >>>> >>>> Thanks & Regards, >>>> *Deba Ranjan P* >>>> >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> To unsubscribe, send a blank email to >>>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> >>> >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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. >> >>
Re: $$Excel-Macros$$ Edit Cell
Sir, The file you have attached is the same that i have attached. Please kindly check. Thanks for the same. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI wrote: > Dear Deba, > > Please see attached sheet, > > If you have any query, Please reply > > > On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan wrote: > >> Dear >> >> Its is possible to Lock a particular cell only, I mean user cant >> able to edit this cell only, rest they can able to edit. Even the E3 cell >> should not be able to edit, Rest can be edit. Please see the attached. >> thank you. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Edit Cell
Dear Its is possible to Lock a particular cell only, I mean user cant able to edit this cell only, rest they can able to edit. Even the E3 cell should not be able to edit, Rest can be edit. Please see the attached. thank you. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com EDIT CELL.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Clock Chart (Excellent)
Thanks Bhai. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 6:32 PM, NOORAIN ANSARI wrote: > See attachment > > > On Fri, Jun 8, 2012 at 6:30 PM, Deba Ranjan wrote: > >> i am sorry sir, i can't get you please. >> >> >> On Fri, Jun 8, 2012 at 6:29 PM, NOORAIN ANSARI >> wrote: >> >>> Dear Deba, >>> >>> Please check here.. >>> >>> >>> >>> >>> On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan wrote: >>> >>>> Its a awesome design. Can you please tell me , in the sheet, we >>>> are unable to view the sheets, i mean, Even we insert sheet, we are unable >>>> to see the sheet. Please explain me on this. Its make me very interesting >>>> parts. !! >>>> >>>> >>>> >>>> Thanks & Regards, >>>> *Deba Ranjan P* >>>> >>>> >>>> >>>> >>>> >>>> On Thu, Jun 7, 2012 at 6:05 PM, hilary lomotey wrote: >>>> >>>>> i like this, thanks >>>>> >>>>> >>>>> On Thu, Jun 7, 2012 at 11:52 AM, NOORAIN ANSARI < >>>>> noorain.ans...@gmail.com> wrote: >>>>> >>>>>> Thanks Nikhil. >>>>>> >>>>>> >>>>>> On Thu, Jun 7, 2012 at 7:53 AM, Nikhil Shah >>>>>> wrote: >>>>>> >>>>>>> Hi Noorain , >>>>>>> >>>>>>> Thanks for sending excellent Chart File.. >>>>>>> >>>>>>> Nikhil >>>>>>> >>>>>>> >>>>>>> On Thu, Jun 7, 2012 at 12:00 AM, NOORAIN ANSARI < >>>>>>> noorain.ans...@gmail.com> wrote: >>>>>>> >>>>>>>> Dear Group, >>>>>>>> >>>>>>>> Please find attached Clock Chart. >>>>>>>> >>>>>>>> -- >>>>>>>> Thanks & regards, >>>>>>>> Noorain Ansari >>>>>>>> www.noorainansari.com >>>>>>>> www.excelmacroworld.blogspot.com >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>>>> >>>>>>>> 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) Cross-promotion of, or links to, forums competitive to this >>>>>>>> forum in signatures are prohibited. >>>>>>>> >>>>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>>>> Forum owners and members are not responsible for any loss. >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>>> >>>>>>>> To unsubscribe, send a blank email to >>>>>>>> excel-macros+unsubscr...@googlegroups.com >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>>> >>>>>>> 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 pos
Re: $$Excel-Macros$$ Clock Chart (Excellent)
i am sorry sir, i can't get you please. On Fri, Jun 8, 2012 at 6:29 PM, NOORAIN ANSARI wrote: > Dear Deba, > > Please check here.. > > > > > On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan wrote: > >> Its a awesome design. Can you please tell me , in the sheet, we are >> unable to view the sheets, i mean, Even we insert sheet, we are unable to >> see the sheet. Please explain me on this. Its make me very interesting >> parts. !! >> >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Thu, Jun 7, 2012 at 6:05 PM, hilary lomotey wrote: >> >>> i like this, thanks >>> >>> >>> On Thu, Jun 7, 2012 at 11:52 AM, NOORAIN ANSARI < >>> noorain.ans...@gmail.com> wrote: >>> >>>> Thanks Nikhil. >>>> >>>> >>>> On Thu, Jun 7, 2012 at 7:53 AM, Nikhil Shah wrote: >>>> >>>>> Hi Noorain , >>>>> >>>>> Thanks for sending excellent Chart File.. >>>>> >>>>> Nikhil >>>>> >>>>> >>>>> On Thu, Jun 7, 2012 at 12:00 AM, NOORAIN ANSARI < >>>>> noorain.ans...@gmail.com> wrote: >>>>> >>>>>> Dear Group, >>>>>> >>>>>> Please find attached Clock Chart. >>>>>> >>>>>> -- >>>>>> Thanks & regards, >>>>>> Noorain Ansari >>>>>> www.noorainansari.com >>>>>> www.excelmacroworld.blogspot.com >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>> >>>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>>> in signatures are prohibited. >>>>>> >>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>> Forum owners and members are not responsible for any loss. >>>>>> >>>>>> >>>>>> -- >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> >>>>>> To unsubscribe, send a blank email to >>>>>> excel-macros+unsubscr...@googlegroups.com >>>>> >>>>> >>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> >>>>> >>>>> -- >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> To unsubscribe, send a blank email to >>>>> excel-macros+unsubscr...@googlegroups.com &
Re: $$Excel-Macros$$ Clock Chart (Excellent)
Thanks you Dear Anil. thanks. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 5:48 PM, Anil Gawli wrote: > Dear Deba > > Goto Options, Advanced and there u'll find Show Sheet Tabs checkbox option > Regards > Gawli Anil > > On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan wrote: > >> Its a awesome design. Can you please tell me , in the sheet, we are >> unable to view the sheets, i mean, Even we insert sheet, we are unable to >> see the sheet. Please explain me on this. Its make me very interesting >> parts. !! >> >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Thu, Jun 7, 2012 at 6:05 PM, hilary lomotey wrote: >> >>> i like this, thanks >>> >>> >>> On Thu, Jun 7, 2012 at 11:52 AM, NOORAIN ANSARI < >>> noorain.ans...@gmail.com> wrote: >>> >>>> Thanks Nikhil. >>>> >>>> >>>> On Thu, Jun 7, 2012 at 7:53 AM, Nikhil Shah wrote: >>>> >>>>> Hi Noorain , >>>>> >>>>> Thanks for sending excellent Chart File.. >>>>> >>>>> Nikhil >>>>> >>>>> >>>>> On Thu, Jun 7, 2012 at 12:00 AM, NOORAIN ANSARI < >>>>> noorain.ans...@gmail.com> wrote: >>>>> >>>>>> Dear Group, >>>>>> >>>>>> Please find attached Clock Chart. >>>>>> >>>>>> -- >>>>>> Thanks & regards, >>>>>> Noorain Ansari >>>>>> www.noorainansari.com >>>>>> www.excelmacroworld.blogspot.com >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>> >>>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>>> in signatures are prohibited. >>>>>> >>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>> Forum owners and members are not responsible for any loss. >>>>>> >>>>>> >>>>>> -- >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> >>>>>> To unsubscribe, send a blank email to >>>>>> excel-macros+unsubscr...@googlegroups.com >>>>> >>>>> >>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> >>>>> >>>>> -- >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>>
Re: $$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....
i agree with Mangesh. its seems very critical abuse word. Thanks & Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 4:50 PM, Mangesh Dayne wrote: > What do u say so... > It shouldn't happen > > > On Fri, Jun 8, 2012 at 4:49 PM, Viktorija Zukauskiene < > vzukauskien...@gmail.com> wrote: > >> fuck off, and never sand that forrever ok? >> >> >> 2012/6/8 Mangesh Dayne >> >>> Hi Friends, >>> >>> >>> I have to add combo box in a sheet that will contain all sheets name and >>> when i select the any sheet name in combo box, it will activate in the >>> workbook, means I can able to see the contents of sheet simply by selecting >>> the sheet from combo box list. Moreover, combo box should automatically >>> update the sheet name, means if i deleted any sheet from workbook the entry >>> from the combo box should also be deleted. >>> >>> Thanks a lot. >>> >>> Please help >>> >>> >>> >>> Mangesh >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Clock Chart (Excellent)
Its a awesome design. Can you please tell me , in the sheet, we are unable to view the sheets, i mean, Even we insert sheet, we are unable to see the sheet. Please explain me on this. Its make me very interesting parts. !! Thanks & Regards, *Deba Ranjan P* On Thu, Jun 7, 2012 at 6:05 PM, hilary lomotey wrote: > i like this, thanks > > > On Thu, Jun 7, 2012 at 11:52 AM, NOORAIN ANSARI > wrote: > >> Thanks Nikhil. >> >> >> On Thu, Jun 7, 2012 at 7:53 AM, Nikhil Shah wrote: >> >>> Hi Noorain , >>> >>> Thanks for sending excellent Chart File.. >>> >>> Nikhil >>> >>> >>> On Thu, Jun 7, 2012 at 12:00 AM, NOORAIN ANSARI < >>> noorain.ans...@gmail.com> wrote: >>> >>>> Dear Group, >>>> >>>> Please find attached Clock Chart. >>>> >>>> -- >>>> Thanks & regards, >>>> Noorain Ansari >>>> www.noorainansari.com >>>> www.excelmacroworld.blogspot.com >>>> >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> To unsubscribe, send a blank email to >>>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -
Re: $$Excel-Macros$$ Date format calculation
Thanks its working...thank you very much.
Thanks & Regards,
*Deba Ranjan P*
On Tue, Jun 5, 2012 at 7:11 AM, David Grugeon wrote:
> You may need a formula like
> =LEFT(A1,FIND(":",A1)-1)/24+MID(A1,FIND(":",A1)+1,FIND(":",A1,FIND(":",A1)+1)-(FIND(":",A1)+1))/1440+MID(A1,FIND(":",A1,FIND(":",A1)+1)+1,99)/86400
>
> This will convert your pseudo time values to date/time values. Then you
> can do further processing on them.
>
> On 4 June 2012 23:52, Rajan_Verma wrote:
>
>> Hi Deba
>>
>> ** **
>>
>> I think when you will enter valid time .. your formula is giving correct
>> results
>>
>> ** **
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan
>> *Sent:* 04 June 2012 6:48
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Date format calculation
>>
>> ** **
>>
>> Sir, i mean the times are like wise:
>>
>> hour, minute, second
>>
>> It can be 2000 hours
>> can be 300 mins
>> can be 200 seconds...
>>
>>
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>> ** **
>>
>>
>>
>>
>>
>> On Mon, Jun 4, 2012 at 6:29 PM, Rajan_Verma
>> wrote:
>>
>> But how can second be 64?
>>
>>
>>
>> * *****
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan
>> *Sent:* 04 June 2012 9:27
>>
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Date format calculation
>>
>>
>>
>> Yes...exactly.
>>
>>
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>>
>> ** **
>>
>> On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma
>> wrote:
>>
>> Hi
>>
>> What do you mean by this Login time : “879:55:64” is it 879 Hour 55
>> Minute and 64 Seconds??
>>
>>
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan
>> *Sent:* 02 June 2012 12:39
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Date format calculation
>>
>>
>>
>>
>> Dear Experts,
>>
>> i have again got confusion in date and time format calculation,
>> Please see the attached file, i have elaborate the details in the sheet.
>> Please help in calculating the problem.
>>
>>
>>
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formul
Re: $$Excel-Macros$$ Date format calculation
Sir, i mean the times are like wise: hour, minute, second It can be 2000 hours can be 300 mins can be 200 seconds... Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 6:29 PM, Rajan_Verma wrote: > But how can second be 64? > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 04 June 2012 9:27 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Date format calculation > > ** ** > > Yes...exactly. > > > > > Thanks & Regards, > *Deba Ranjan P* > > ** ** > > > > > > On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma > wrote: > > Hi > > What do you mean by this Login time : “879:55:64” is it 879 Hour 55 > Minute and 64 Seconds?? > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 02 June 2012 12:39 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Date format calculation > > > > > Dear Experts, > > i have again got confusion in date and time format calculation, Please > see the attached file, i have elaborate the details in the sheet. Please > help in calculating the problem. > > > > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to >
Re: $$Excel-Macros$$ Date format calculation
Dear Asa, Can you please explain in the sheet itself. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 1:22 PM, Asa Rossoff wrote: > Hi Deba, > > ** ** > > *For the Login Time column,* the reason SUM is not working properly is > that many of the login times are being interpreted as text instead of as > [h]:mm:ss entries. > > **1) **For the login time column with a custom format: > > [h]:mm:ss > > or the corresponding preset "Time" format: > > 37:30:55 > > **2) **Then, only enter valid times. Your problem entries all have > minutes or seconds > 59, and Excel knows that this could not indicate time > properly, so treats it as text. Correct the following entries: > > 879:55:64 > > 899:54:78 > > 98:54:87 > > 87:54:78 > > 198:89:55 > > **3) **Optionally remove cell justification. You have the cells > left-justifed. If you remove justification, correct times will be > right-justified, and incorrect ones will be interpreted as text and > therefore left-justified. This helps in noticing a problem early on. > > **4) **Get rid of the TEXT function in your total formula (the cell > format takes care of formatting), and simply use: > > =SUM(B2:B8) > > ** ** > > *For the Total login cell* in the summary area (F3), simply refer to the > total in B9 directly: > > =B9 > > ** ** > > *For the No of days cell* (F4): > > **a. **If you need the number of 24-hour periods for the Total login > time use: > > =B9 > > and format the cell as a number (it will default to time format). The > result will be in terms of days, since that is how Excel stores dates and > times. > > **b. **If you need the number of periods of length "1 day hour" (the > number in F1), use: > > =B9*24/F1 > > (and format the cell as a number) > > ** ** > > *For the Login time for 1 day… cell* (F5), I don't really understand the > formula or what you want, but perhaps the formula is correct and you just > need to format the result for time: > > [h]:mm:ss > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* Saturday, June 02, 2012 12:09 AM > > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Date format calculation > > ** ** > > > Dear Experts, > > i have again got confusion in date and time format calculation, Please > see the attached file, i have elaborate the details in the sheet. Please > help in calculating the problem. > > > > > > Thanks & Regards, > *Deba Ranjan P* > > ** ** > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ---
Re: $$Excel-Macros$$ Date format calculation
Please have a look on this Dear Experts. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 9:27 AM, Deba Ranjan wrote: > Yes...exactly. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma wrote: > >> Hi >> >> What do you mean by this Login time : “879:55:64” is it 879 Hour 55 >> Minute and 64 Seconds?? >> >> ** ** >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan >> *Sent:* 02 June 2012 12:39 >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Date format calculation >> >> ** ** >> >> >> Dear Experts, >> >> i have again got confusion in date and time format calculation, >> Please see the attached file, i have elaborate the details in the sheet. >> Please help in calculating the problem. >> >> >> >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> ** ** >> >> ** ** >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> > > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Date format calculation
Yes...exactly. Thanks & Regards, *Deba Ranjan P* On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma wrote: > Hi > > What do you mean by this Login time : “879:55:64” is it 879 Hour 55 > Minute and 64 Seconds?? > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 02 June 2012 12:39 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Date format calculation > > ** ** > > > Dear Experts, > > i have again got confusion in date and time format calculation, Please > see the attached file, i have elaborate the details in the sheet. Please > help in calculating the problem. > > > > > > Thanks & Regards, > *Deba Ranjan P* > > ** ** > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
Congratulations Rajan , Awesome Job Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 8:03 AM, xlstime wrote: > Congratulations Rajan > > On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Rajan Verma has been selected as 'Most Helpful Member' for the month of >> May'2012 >> He has posted 147 posts in May 2012 and helped many people through his >> expertise. >> >> I truly appreciate his consistency and commitment to group. He is really >> doing great job God bless you :) >> >> Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel >> enthusiasts voluntarily !! Keep it up !! >> Trust me, It requires big heart to help others voluntarily and thanks to >> everyone who is supporting this forum. >> >> Keep posting. >> >> Regards >> Ayush Jain >> Group Manager >> Microsoft MVP >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > -- > . > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Date format calculation
Dear Experts, i have again got confusion in date and time format calculation, Please see the attached file, i have elaborate the details in the sheet. Please help in calculating the problem. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com date format.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm
Dear Rajan, thats a very great vb code that you have shared to us, Thank you ver much. can you please tell me, if i want to send more then 1 person, what i need to do. i have to insert comma after every mail ID ? Thanks & Regards, *Deba Ranjan P* On Wed, May 30, 2012 at 9:13 PM, Rajan_Verma wrote: > Hi Deba, > > ** ** > > See the attached Unprotected Version > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 30 May 2012 9:56 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm > > ** ** > > Sir, i dont have any tool for breaking password. If you have any set up > you can let me know, or else, Please share the file without password. thank > you Rajan Sir. > > > > > Thanks & Regards, > *Deba Ranjan P* > > ** ** > > > > > > On Tue, May 29, 2012 at 6:05 PM, Rajan_Verma > wrote: > > > > Sorry I forget that password L if you have any tool to break the > password will be good for you J > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 29 May 2012 10:11 > > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm > > > > Dear Rajan, > >The file that you have shared is quite awesome. Can you please share us > the coding too as you have protect the code with password. i Think it will > be a great contribution form you side to the fellow members in this forum. > Great job. thanks for sharing such experience. > > > > Thanks & Regards, > *Deba Ranjan P* > > > > ** ** > > On Mon, May 28, 2012 at 7:48 PM, Rajan_Verma > wrote: > > Just give the front end. > how you want to attached the file.. where you will put the Email ID and so > on > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *t vinay > *Sent:* 28 May 2012 7:47 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm > > > > Hi Rajan, > > > > this is excellent, can you help with the code that you have used. as my > requirement is on the same line. > > On 17 May 2012 18:44, Rajan_Verma wrote: > > Try My Excel Outlook J > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Renukachari Kasee > *Sent:* 17 May 2012 5:24 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm > > > > Dear experts > > > > Excel macro for sendin outlook emails from Specific Templet With > Attachments formats of .PDF & .htm > > > > Thanks in Advance > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > >
Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm
Sir, i dont have any tool for breaking password. If you have any set up you can let me know, or else, Please share the file without password. thank you Rajan Sir. Thanks & Regards, *Deba Ranjan P* On Tue, May 29, 2012 at 6:05 PM, Rajan_Verma wrote: > ** ** > > Sorry I forget that password L if you have any tool to break the > password will be good for you J > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 29 May 2012 10:11 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm > > ** ** > > Dear Rajan, > >The file that you have shared is quite awesome. Can you please share us > the coding too as you have protect the code with password. i Think it will > be a great contribution form you side to the fellow members in this forum. > Great job. thanks for sharing such experience. > > > > > > Thanks & Regards, > *Deba Ranjan P* > > ** ** > > > > > > On Mon, May 28, 2012 at 7:48 PM, Rajan_Verma > wrote: > > Just give the front end. > how you want to attached the file.. where you will put the Email ID and so > on > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *t vinay > *Sent:* 28 May 2012 7:47 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm > > > > Hi Rajan, > > > > this is excellent, can you help with the code that you have used. as my > requirement is on the same line. > > On 17 May 2012 18:44, Rajan_Verma wrote: > > Try My Excel Outlook J > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Renukachari Kasee > *Sent:* 17 May 2012 5:24 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm > > > > Dear experts > > > > Excel macro for sendin outlook emails from Specific Templet With > Attachments formats of .PDF & .htm > > > > Thanks in Advance > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > --
Re: $$Excel-Macros$$ MACRO
Noorain Sir, Can you please send me the file too in my mail ID, the file that you share with Mangesh. mail:- drdeva...@gmail.com Thanks & Regards, *Deba Ranjan P* On Wed, May 30, 2012 at 8:25 AM, NOORAIN ANSARI wrote: > Hi Joseph,aruna,lupinskip and anjali, > > I have send VBA Ebook 2007(O'Rellay) on your email ID. > > Pls check and confirm. > > -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> To unsubscribe, send a blank email to >>>> excel-macros+unsubscr...@googlegroups.com >>>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> -- >> >> >> >> >> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> >> >> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> >> >> >> > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell
Great expertise Noorain sir,
. can we create formula without using vb macors for this
extractions ?
Thanks & Regards,
*Deba Ranjan P*
On Tue, May 29, 2012 at 11:09 AM, Ashish Bhalara
wrote:
> Its a great macro Noorainji, Thanks.
>
> Ashish Bhalara
>
>
> On Tue, May 29, 2012 at 10:59 AM, NOORAIN ANSARI > wrote:
>
>> Dear Deba,
>>
>> Please try it
>>
>> For Number
>> *Function Only_Number(rng As Range)
>> Dim i As Integer
>> For i = 1 To Len(rng)
>> If IsNumeric(Mid(rng, i, 1)) Then
>> Only_Number = Only_Number & Mid(rng, i, 1)
>> End If
>> Next i
>> End Function
>> *
>> For Alpha
>> *Function Only_Alpha(rng As Range)
>> Dim i As Integer
>> For i = 1 To Len(rng)
>> If Asc(Mid(VBA.UCase(rng), i, 1)) >= 65 And Asc(Mid(UCase(rng), i, 1)) <=
>> 90 Then
>> Only_Alpha = Only_Alpha & Mid(rng, i, 1)
>> End If
>> Next i
>> End Function
>> *
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Tue, May 29, 2012 at 10:36 AM, Deba Ranjan wrote:
>>
>>> Dear experts,
>>>
>>> its a awesome expertise work. Now - Can we extract only words and
>>> numbers separately from Alphanumeric, alphanumericalpha, Numericalpha, or
>>> numericalphanumeric.
>>>
>>> eg.
>>>
>>> MOHANAN157896
>>>
>>> RAJU78785545GAYATRI
>>>
>>> 787984544RAJANANA
>>>
>>> 879445JOCKER789
>>>
>>>
>>> thanks...
>>>
>>>
>>>
>>> Thanks & Regards,
>>> *Deba Ranjan P*
>>>
>>>
>>>
>>>
>>>
>>> On Mon, May 28, 2012 at 7:12 PM, Rajan_Verma
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> ** **
>>>>
>>>> If your data in Alphanumeric value in *A1* then use it in *B1*
>>>>
>>>> ** **
>>>>
>>>> *
>>>> =IFERROR(SUM(INT(MID(A1,LARGE(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))*ROW(INDIRECT("1:"&LEN(A1))),ROW(INDIRECT("1:"&SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),1)*10^ROW(INDIRECT("1:"&SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1/10,"")
>>>> *
>>>>
>>>> ** **
>>>>
>>>> * *
>>>>
>>>> * *
>>>>
>>>> *Regards*
>>>>
>>>> *Rajan verma*
>>>>
>>>> *+91 7838100659 [IM-Gtalk]*
>>>>
>>>> ** **
>>>>
>>>> *From:* excel-macros@googlegroups.com [mailto:
>>>> excel-macros@googlegroups.com] *On Behalf Of *vishal angre
>>>> *Sent:* 28 May 2012 4:52
>>>> *To:* excel-macros@googlegroups.com
>>>> *Cc:* noorain.ans...@gmail.com
>>>> *Subject:* Re: $$Excel-Macros$$ How to collect only numeric value from
>>>> a particular cell
>>>>
>>>> ** **
>>>>
>>>>
>>>>
>>>> Function removetext(c As String)
>>>> Dim String1 As String
>>>> Dim i As Integer
>>>> String1 = ""
>>>> For i = 1 To Len(c)
>>>> If IsNumeric(Mid(c, i, 1)) Then
>>>> String1 = String1 & Mid(c, i, 1)
>>>> End If
>>>> Next
>>>> removetext = String1
>>>>
>>>> End Function
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD <
>>>> lakshman_...@yahoo.com> wrote:
>>>>
>>>> How to collect only numeric value from a particular cell
>>>>
>>>>
>>>>
>>>> 1462NIRM
>>>>
>>>> 1462
>>>>
>>>> 1464NIRM
>>>>
>>>> 1464
>>>>
>>>> 1465NIRM
>>>>
>>>> 1465
>>>>
>>>> 1404--BL
>>>>
>>>> 1404
>>>>
>>>
Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell
Dear experts,
its a awesome expertise work. Now - Can we extract only words and
numbers separately from Alphanumeric, alphanumericalpha, Numericalpha, or
numericalphanumeric.
eg.
MOHANAN157896
RAJU78785545GAYATRI
787984544RAJANANA
879445JOCKER789
thanks...
Thanks & Regards,
*Deba Ranjan P*
On Mon, May 28, 2012 at 7:12 PM, Rajan_Verma wrote:
> Hi,
>
> ** **
>
> If your data in Alphanumeric value in *A1* then use it in *B1*
>
> ** **
>
> *
> =IFERROR(SUM(INT(MID(A1,LARGE(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))*ROW(INDIRECT("1:"&LEN(A1))),ROW(INDIRECT("1:"&SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),1)*10^ROW(INDIRECT("1:"&SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1/10,"")
> *
>
> ** **
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *vishal angre
> *Sent:* 28 May 2012 4:52
> *To:* excel-macros@googlegroups.com
> *Cc:* noorain.ans...@gmail.com
> *Subject:* Re: $$Excel-Macros$$ How to collect only numeric value from a
> particular cell
>
> ** **
>
>
>
> Function removetext(c As String)
> Dim String1 As String
> Dim i As Integer
> String1 = ""
> For i = 1 To Len(c)
> If IsNumeric(Mid(c, i, 1)) Then
> String1 = String1 & Mid(c, i, 1)
> End If
> Next
> removetext = String1
>
> End Function
>
>
>
>
>
>
>
>
>
>
>
> On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD
> wrote:
>
> How to collect only numeric value from a particular cell
>
>
>
> 1462NIRM
>
> 1462
>
> 1464NIRM
>
> 1464
>
> 1465NIRM
>
> 1465
>
> 1404--BL
>
> 1404
>
> 1031Infr
>
> 1031
>
> 8020LOKN
>
> 8020
>
> 202D.B.
>
> 202
>
> 922Parmi
>
> 922
>
> 5071RIFA
>
> 5071
>
> 1040Harj
>
> 1040
>
> 5078Harj
>
> 5078
>
> 1471Raj
>
> 1471
>
> 1571Raj
>
> 1571
>
> 414Ruchi
>
> 414
>
> 2084AJAY
>
> 2084
>
>
>
> Regards
>
> LAKSHMAN
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> With Regards,
> *Vishal K. Angre*
> E-mail : visha...@gmail.com
> vishal.k.an...@gmail.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm
Dear Rajan, The file that you have shared is quite awesome. Can you please share us the coding too as you have protect the code with password. i Think it will be a great contribution form you side to the fellow members in this forum. Great job. thanks for sharing such experience. Thanks & Regards, *Deba Ranjan P* On Mon, May 28, 2012 at 7:48 PM, Rajan_Verma wrote: > Just give the front end. > how you want to attached the file.. where you will put the Email ID and so > on > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *t vinay > *Sent:* 28 May 2012 7:47 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm > > ** ** > > Hi Rajan, > > ** ** > > this is excellent, can you help with the code that you have used. as my > requirement is on the same line. > > On 17 May 2012 18:44, Rajan_Verma wrote: > > Try My Excel Outlook J > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Renukachari Kasee > *Sent:* 17 May 2012 5:24 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm > > > > Dear experts > > > > Excel macro for sendin outlook emails from Specific Templet With > Attachments formats of .PDF & .htm > > > > Thanks in Advance > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > > > > > ** ** > > -- > > Regards, > > > > Vinay. T > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > >
Re: $$Excel-Macros$$ Time Mean calculation
Thanks. Thanks & Regards, *Deba Ranjan P* On Fri, May 25, 2012 at 4:37 PM, NOORAIN ANSARI wrote: > Deba, I am sending Userform Query ASAP. > > > On Fri, May 25, 2012 at 4:36 PM, Deba Ranjan wrote: > >> Thank you very much Noorain sir,Its absolutely working. >> >>-- what about the userform that i posted ? >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> >> On Fri, May 25, 2012 at 4:30 PM, NOORAIN ANSARI > > wrote: >> >>> Dear Deba, >>> >>> Please see attached workbook... >>> >>> -- >>> Thanks & regards, >>> Noorain Ansari >>> www.noorainansari.com >>> www.excelmacroworld.blogspot.com >>> >>> On Fri, May 25, 2012 at 3:59 PM, Deba Ranjan wrote: >>> >>>> Dear Experts, >>>> >>>>i have some doubt in mean time difference calculation. i have >>>> provided my query in attached worksheet. Please open the sheet, i have got >>>> some error and i marked it as red color. Thank you. >>>> >>>> >>>> Thanks & Regards, >>>> *Deba Ranjan P* >>>> >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> To unsubscribe, send a blank email to >>>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> >>> >>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook.
Re: $$Excel-Macros$$ Time Mean calculation
Thank you very much Noorain sir,Its absolutely working. -- what about the userform that i posted ? Thanks & Regards, *Deba Ranjan P* On Fri, May 25, 2012 at 4:30 PM, NOORAIN ANSARI wrote: > Dear Deba, > > Please see attached workbook... > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Fri, May 25, 2012 at 3:59 PM, Deba Ranjan wrote: > >> Dear Experts, >> >>i have some doubt in mean time difference calculation. i have provided >> my query in attached worksheet. Please open the sheet, i have got some >> error and i marked it as red color. Thank you. >> >> >> Thanks & Regards, >> *Deba Ranjan P* >> >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Time Mean calculation
Dear Experts, i have some doubt in mean time difference calculation. i have provided my query in attached worksheet. Please open the sheet, i have got some error and i marked it as red color. Thank you. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Time calculation.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Automatic token numbers
Thanks . Thanks & Regards, *Deba Ranjan P* On Wed, May 23, 2012 at 5:05 PM, NOORAIN ANSARI wrote: > *=IF(B3<>"","LD000"&SUBTOTAL(3,$B$3:B3),"")* -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Automatic token numbers
*Dear Anil and Experts, The formula you have given was absolutely correct. Thanks once again for the same. Thank you very very much.* Thanks & Regards, Deba Ranjan P On Tue, May 22, 2012 at 3:53 PM, hilary lomotey wrote: > Just add =if(b3<>"","LD000","")&if(b3<>"",counta(b$3:b3),"") > > > On Tue, May 22, 2012 at 10:10 AM, Deba Ranjan wrote: > >> * >> *Hi Anil Sir, >> >> Thats fine working, but i need in this look:- LD0001, LD0002, >> LD0003so on. Can you please do on this !! actually your attached file >> is fine working in serial numbers. Please i want the serial in LD0001, >> LD0002so on. Please and thanks Anil sir, and other experts. >> >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> >> >> >> On Tue, May 22, 2012 at 2:54 PM, Anil Gawli wrote: >> >>> See the attached Sheet. >>> >>> >>> On Tue, May 22, 2012 at 12:32 PM, Deba Ranjan wrote: >>> >>>> *Dear Experts and Sir, >>>> >>>> >>>> *While on the data entry form in excel, for tracing data in future, i >>>> am using token numbers. So while filling the data of any person, i use to >>>> fill token number manually, eg. LD0001, LD0002, LD0003, and so on...Can >>>> we make by VBA code for automatic token number ?. >>>> >>>>Eg. i am filling in the data entry form. >>>> >>>> First person:- devanand >>>> Mobile:- 124568755 >>>> Town name:- delhi >>>> Token number:- *LD0001* >>>> >>>>If i give summit/ add button, the first person will be added on the >>>> sheet or traced. If i give another person summit there the token number >>>> should automatically come as *LD0002, *and so on >>>> >>>> Can you please help me on this experts. Thank you. >>>> >>>> >>>> Thanks & Regards, >>>> Deba Ranjan P >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> To unsubscribe, send a blank email to >>>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >>> >>> -- >>> Thanks & Regards, >>> Gawli Anil Narayan >>> Software Developer, >>> Abacus Software Services Pvt Ltd >>> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macro
Re: $$Excel-Macros$$ Automatic token numbers
* *Hi Anil Sir, Thats fine working, but i need in this look:- LD0001, LD0002, LD0003so on. Can you please do on this !! actually your attached file is fine working in serial numbers. Please i want the serial in LD0001, LD0002so on. Please and thanks Anil sir, and other experts. Thanks & Regards, Deba Ranjan P On Tue, May 22, 2012 at 2:54 PM, Anil Gawli wrote: > See the attached Sheet. > > > On Tue, May 22, 2012 at 12:32 PM, Deba Ranjan wrote: > >> *Dear Experts and Sir, >> >> >> *While on the data entry form in excel, for tracing data in future, i am >> using token numbers. So while filling the data of any person, i use to fill >> token number manually, eg. LD0001, LD0002, LD0003, and so on...Can we >> make by VBA code for automatic token number ?. >> >>Eg. i am filling in the data entry form. >> >> First person:- devanand >> Mobile:- 124568755 >> Town name:- delhi >> Token number:- *LD0001* >> >>If i give summit/ add button, the first person will be added on the >> sheet or traced. If i give another person summit there the token number >> should automatically come as *LD0002, *and so on >> >> Can you please help me on this experts. Thank you. >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com > > > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Form tracker and new base-1
*Hi Anil and experts, Yes it working good. very very very thank you. you all are genius. i am feeling very guilty that i am unable to create such things (marcos coding). i have tried to learn form various website and books, but i am unable to code my self. i think i very fool on this. Please suggest me how to create own and learn. i think i want a huge advice form the experts. i am very shy on this regards that i am unable to learn on this concerns. if i look all the experts template and coding solved. i am very regretted. Please experts help me. i will be grateful to your kind advice and suggestions. * Thanks & Regards, Deba Ranjan P On Mon, May 21, 2012 at 11:37 AM, Anil Gawli wrote: > > See the attached File > On Mon, May 21, 2012 at 10:46 AM, Deba Ranjan wrote: > >> *Hi experts, >> >> Please find the attached file. There you will find that *Bé Trần Văn >> sir has done his best to solved my problem. Thank you very much Bé Trần >> Văn sir. BUt my tracker is still unsolved. Please see the attached file and >> click the Tracker button. You will find my query. >> >> >> Thank you experts. >> >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> >> >> >> On Sat, May 19, 2012 at 7:38 PM, Bé Trần Văn >> wrote: >> >>> >>> >>> 2012/5/19 Deba Ranjan >>> >>>> * >>>> *Hi Experts, the password for Up_validation forM (vba) is - *9815* >>>> >>>> * >>>> Hi Anil and experts, >>>> >>>> The attached file by Anil sir is properly working in Windows 7 for >>>> only the customer not the Customer number, perhaps, i am using windows xp, >>>> so might not work. Please check it and let me know. Please see the attached >>>> file of my error reflected.* >>>> >>>> >>>> Thanks in advance. >>>> >>>> Thanks & Regards, >>>> Deba Ranjan P >>>> >>>> >>>> >>>> -- Forwarded message -- >>>> From: Deba Ranjan >>>> Date: Sat, May 19, 2012 at 2:48 PM >>>> Subject: $$Excel-Macros$$ Form tracker and new base-1 >>>> To: excel-macros@googlegroups.com >>>> >>>> >>>> *Hi Anil and experts, >>>> >>>> The attached file by Anil sir is properly working in Windows 7 for >>>> only the customer not the Customer number, perhaps, i am using windows xp, >>>> so might not work. Please check it and let me know. Please see the attached >>>> file of my error reflected.* >>>> >>>> >>>> Thanks & Regards, >>>> Deba Ranjan P >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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. >>>>
Re: $$Excel-Macros$$ Form tracker and new base
Dear sir, Can you please explain how to assigned ? Note:-- And in the combox, if i click then nothing is drop down. Please check it. Please create a new button to show the UserForm1, so that it will better understand and show. Please if you don't mind, Thank you once again. Thanks & Regards, Deba Ranjan P On Fri, May 18, 2012 at 5:48 PM, Anil Gawli wrote: > It might possible that the macro will not assigned to it > kindly assigned to it and run it. > updated file is attached .FYI > > On Fri, May 18, 2012 at 5:43 PM, Deba Ranjan wrote: > >> *Dear Anil, >> Thank you very much for your effort on this. Thats good >> but can you please send me the file once again that is working in your >> system please. Please before attachment please check the file once again >> and please do let me know the button where i need to click. Thank you so >> much so much Anil and all the experts. >> * >> >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> >> >> >> On Fri, May 18, 2012 at 3:23 PM, Anil Gawli wrote: >> >>> At my end it is working fine. >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> On Fri, May 18, 2012 at 3:00 PM, Deba Ranjan wrote: >>> >>>> *Dear Anil Sir, >>>> >>>> The file that you have share is not at all working. Please check >>>> from your end. and on clicking the Traced data button The UserfForm1 >>>> should show and in userfrom customer data or name list should validate, on >>>> selecting the customer name the database of that particular customer should >>>> reflect on the form itself. I think you have got my point !. Please try >>>> sir, >>>> thanks >>>> * >>>> >>>> >>>> Thanks & Regards, >>>> Deba Ranjan P >>>> >>>> >>>> >>>> >>>> On Fri, May 18, 2012 at 2:32 PM, Anil Gawli >>>> wrote: >>>> >>>>> Latest file Attached >>>>> >>>>> >>>>> On Fri, May 18, 2012 at 9:54 AM, Deba Ranjan wrote: >>>>> >>>>>> *Dear Expert, >>>>>> >>>>>> Please anyone help me on my query, the query is in the attached >>>>>> file. i have been looking on this and trying for past couple of days >>>>>> back. >>>>>> thank you experts. >>>>>> >>>>>> * >>>>>> >>>>>> >>>>>> >>>>>> Thanks & Regards, >>>>>> Deba Ranjan P >>>>>> >>>>>> >>>>>> >>>>>> -- Forwarded message -- >>>>>> From: Deba Ranjan >>>>>> Date: Wed, May 16, 2012 at 12:24 PM >>>>>> Subject: Re: $$Excel-Macros$$ Form tracker and new base >>>>>> To: excel-macros@googlegroups.com >>>>>> >>>>>> >>>>>> *Hi Anil, >>>>>> >>>>>> It was a awesome attempt, and done it, thanks for the same. But i >>>>>> have some again query, Please find the attached file, i have explained it >>>>>> clearly, i have added one more button, please find that. i want seems to >>>>>> be >>>>>> like search engine in the second form. >>>>>> >>>>>> thank you all the experts. >>>>>> * >>>>>> >>>>>> >>>>>> >>>>>> Thanks & Regards, >>>>>> Deba Ranjan P >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Wed, May 16, 2012 at 11:41 AM, Anil Gawli < >>>>>> gawlianil8...@gmail.com> wrote: >>>>>> >>>>>>> >>>>>>> >>>>>>> On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote: >>>>>>> >>>>>>>> *Dear Experts, Waiting for the revert with solution. Thanks >>>>>>>> * >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Thanks & Regards, >>>>>>>> Deba Ranjan P >>>>>>>> >>>>>>>>
Re: $$Excel-Macros$$ Form tracker and new base
*Dear Anil, Thank you very much for your effort on this. Thats good but can you please send me the file once again that is working in your system please. Please before attachment please check the file once again and please do let me know the button where i need to click. Thank you so much so much Anil and all the experts. * Thanks & Regards, Deba Ranjan P On Fri, May 18, 2012 at 3:23 PM, Anil Gawli wrote: > At my end it is working fine. > > > > > > > > > > On Fri, May 18, 2012 at 3:00 PM, Deba Ranjan wrote: > >> *Dear Anil Sir, >> >> The file that you have share is not at all working. Please check from >> your end. and on clicking the Traced data button The UserfForm1 should >> show and in userfrom customer data or name list should validate, on >> selecting the customer name the database of that particular customer should >> reflect on the form itself. I think you have got my point !. Please try >> sir, >> thanks >> * >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> **** >> >> >> On Fri, May 18, 2012 at 2:32 PM, Anil Gawli wrote: >> >>> Latest file Attached >>> >>> >>> On Fri, May 18, 2012 at 9:54 AM, Deba Ranjan wrote: >>> >>>> *Dear Expert, >>>> >>>> Please anyone help me on my query, the query is in the attached >>>> file. i have been looking on this and trying for past couple of days back. >>>> thank you experts. >>>> >>>> * >>>> >>>> >>>> >>>> Thanks & Regards, >>>> Deba Ranjan P >>>> >>>> >>>> >>>> -- Forwarded message -- >>>> From: Deba Ranjan >>>> Date: Wed, May 16, 2012 at 12:24 PM >>>> Subject: Re: $$Excel-Macros$$ Form tracker and new base >>>> To: excel-macros@googlegroups.com >>>> >>>> >>>> *Hi Anil, >>>> >>>> It was a awesome attempt, and done it, thanks for the same. But i >>>> have some again query, Please find the attached file, i have explained it >>>> clearly, i have added one more button, please find that. i want seems to be >>>> like search engine in the second form. >>>> >>>> thank you all the experts. >>>> * >>>> >>>> >>>> >>>> Thanks & Regards, >>>> Deba Ranjan P >>>> >>>> >>>> >>>> >>>> On Wed, May 16, 2012 at 11:41 AM, Anil Gawli >>>> wrote: >>>> >>>>> >>>>> >>>>> On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote: >>>>> >>>>>> *Dear Experts, Waiting for the revert with solution. Thanks >>>>>> * >>>>>> >>>>>> >>>>>> >>>>>> Thanks & Regards, >>>>>> Deba Ranjan P >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- Forwarded message -- >>>>>> From: Deba Ranjan >>>>>> Date: Tue, May 15, 2012 at 10:22 AM >>>>>> Subject: $$Excel-Macros$$ Form tracker and new base >>>>>> To: excel-macros@googlegroups.com >>>>>> >>>>>> >>>>>> *Hi Experts, >>>>>> >>>>>>Very good morning, Dear groups and experts, i have some data base >>>>>> which need to be created in userform, i have explained in the attached >>>>>> file. Please help me sort out this problem. Thanks in advance. >>>>>> * >>>>>> >>>>>> >>>>>> Thanks & Regards,* >>>>>> * >>>>>> >>>>>> *Deba Ranjan P*** >>>>>> >>>>>> >>>>>> -- >>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>> >>>>>> 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 pos
Re: $$Excel-Macros$$ Form tracker and new base
*Dear Anil Sir, The file that you have share is not at all working. Please check from your end. and on clicking the Traced data button The UserfForm1 should show and in userfrom customer data or name list should validate, on selecting the customer name the database of that particular customer should reflect on the form itself. I think you have got my point !. Please try sir, thanks * Thanks & Regards, Deba Ranjan P On Fri, May 18, 2012 at 2:32 PM, Anil Gawli wrote: > Latest file Attached > > > On Fri, May 18, 2012 at 9:54 AM, Deba Ranjan wrote: > >> *Dear Expert, >> >> Please anyone help me on my query, the query is in the attached >> file. i have been looking on this and trying for past couple of days back. >> thank you experts. >> >> * >> >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> >> >> -- Forwarded message -- >> From: Deba Ranjan >> Date: Wed, May 16, 2012 at 12:24 PM >> Subject: Re: $$Excel-Macros$$ Form tracker and new base >> To: excel-macros@googlegroups.com >> >> >> *Hi Anil, >> >> It was a awesome attempt, and done it, thanks for the same. But i have >> some again query, Please find the attached file, i have explained it >> clearly, i have added one more button, please find that. i want seems to be >> like search engine in the second form. >> >> thank you all the experts. >> * >> >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> **** >> >> >> On Wed, May 16, 2012 at 11:41 AM, Anil Gawli wrote: >> >>> >>> >>> On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote: >>> >>>> *Dear Experts, Waiting for the revert with solution. Thanks >>>> * >>>> >>>> >>>> >>>> Thanks & Regards, >>>> Deba Ranjan P >>>> >>>> >>>> >>>> >>>> -- Forwarded message -- >>>> From: Deba Ranjan >>>> Date: Tue, May 15, 2012 at 10:22 AM >>>> Subject: $$Excel-Macros$$ Form tracker and new base >>>> To: excel-macros@googlegroups.com >>>> >>>> >>>> *Hi Experts, >>>> >>>>Very good morning, Dear groups and experts, i have some data base >>>> which need to be created in userform, i have explained in the attached >>>> file. Please help me sort out this problem. Thanks in advance. >>>> * >>>> >>>> >>>> Thanks & Regards,* >>>> * >>>> >>>> *Deba Ranjan P*** >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums
Fwd: $$Excel-Macros$$ Form tracker and new base
*Dear Expert, Please anyone help me on my query, the query is in the attached file. i have been looking on this and trying for past couple of days back. thank you experts. * Thanks & Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan Date: Wed, May 16, 2012 at 12:24 PM Subject: Re: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com *Hi Anil, It was a awesome attempt, and done it, thanks for the same. But i have some again query, Please find the attached file, i have explained it clearly, i have added one more button, please find that. i want seems to be like search engine in the second form. thank you all the experts. * Thanks & Regards, Deba Ranjan P On Wed, May 16, 2012 at 11:41 AM, Anil Gawli wrote: > > > On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote: > >> *Dear Experts, Waiting for the revert with solution. Thanks >> * >> >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> >> >> >> -- Forwarded message -- >> From: Deba Ranjan >> Date: Tue, May 15, 2012 at 10:22 AM >> Subject: $$Excel-Macros$$ Form tracker and new base >> To: excel-macros@googlegroups.com >> >> >> *Hi Experts, >> >>Very good morning, Dear groups and experts, i have some data base >> which need to be created in userform, i have explained in the attached >> file. Please help me sort out this problem. Thanks in advance. >> * >> >> >> Thanks & Regards,* >> * >> >> *Deba Ranjan P*** >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com up_validation_form.xlsm Description: Binary data
Re: $$Excel-Macros$$ Form tracker and new base
*Dear Anil, Thank you so so much for that. any way when you get time please do it. But the attached file that you have send is not at all working properly for customer name too. please find it. * Thanks & Regards, Deba Ranjan P On Wed, May 16, 2012 at 3:51 PM, Anil Gawli wrote: > Hi Deba > It is working with Customer Name. But i'm sorry it is not working with > Mobile no. > for that i have to do some R&D in Net I''ll do it afterwards. Ok. > > Here is the attached File. > Regards > Anil Gawli > > On Wed, May 16, 2012 at 1:21 PM, Deba Ranjan wrote: > >> *Hi Anil, >> >> It was a awesome attempt, and done it, thanks for the same. But i have >> some again query, Please find the attached file, i have explained it >> clearly, i have added one more button, please find that. i want seems to be >> like search engine in the second form. >> >> thank you all the experts. >> * >> >> Thanks & Regards, >> Deba Ranjan P >> >> >> >> -- Forwarded message -- >> From: Deba Ranjan >> Date: Wed, May 16, 2012 at 12:24 PM >> Subject: Re: $$Excel-Macros$$ Form tracker and new base >> To: excel-macros@googlegroups.com >> >> >> *Hi Anil, >> >> It was a awesome attempt, and done it, thanks for the same. But i have >> some again query, Please find the attached file, i have explained it >> clearly, i have added one more button, please find that. i want seems to be >> like search engine in the second form. >> >> thank you all the experts. >> * >> >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> >> >> >> On Wed, May 16, 2012 at 11:41 AM, Anil Gawli wrote: >> >>> >>> >>> On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote: >>> >>>> *Dear Experts, Waiting for the revert with solution. Thanks >>>> * >>>> >>>> >>>> >>>> Thanks & Regards, >>>> Deba Ranjan P >>>> >>>> >>>> >>>> >>>> -- Forwarded message -- >>>> From: Deba Ranjan >>>> Date: Tue, May 15, 2012 at 10:22 AM >>>> Subject: $$Excel-Macros$$ Form tracker and new base >>>> To: excel-macros@googlegroups.com >>>> >>>> >>>> *Hi Experts, >>>> >>>>Very good morning, Dear groups and experts, i have some data base >>>> which need to be created in userform, i have explained in the attached >>>> file. Please help me sort out this problem. Thanks in advance. >>>> * >>>> >>>> >>>> Thanks & Regards,* >>>> * >>>> >>>> *Deba Ranjan P*** >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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. >>>> >>
Fwd: $$Excel-Macros$$ Form tracker and new base
*Hi Anil, It was a awesome attempt, and done it, thanks for the same. But i have some again query, Please find the attached file, i have explained it clearly, i have added one more button, please find that. i want seems to be like search engine in the second form. thank you all the experts. * Thanks & Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan Date: Wed, May 16, 2012 at 12:24 PM Subject: Re: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com *Hi Anil, It was a awesome attempt, and done it, thanks for the same. But i have some again query, Please find the attached file, i have explained it clearly, i have added one more button, please find that. i want seems to be like search engine in the second form. thank you all the experts. * Thanks & Regards, Deba Ranjan P On Wed, May 16, 2012 at 11:41 AM, Anil Gawli wrote: > > > On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote: > >> *Dear Experts, Waiting for the revert with solution. Thanks >> * >> >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> >> >> >> -- Forwarded message -- >> From: Deba Ranjan >> Date: Tue, May 15, 2012 at 10:22 AM >> Subject: $$Excel-Macros$$ Form tracker and new base >> To: excel-macros@googlegroups.com >> >> >> *Hi Experts, >> >>Very good morning, Dear groups and experts, i have some data base >> which need to be created in userform, i have explained in the attached >> file. Please help me sort out this problem. Thanks in advance. >> * >> >> >> Thanks & Regards,* >> * >> >> *Deba Ranjan P*** >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com up_validation_form.xlsm Description: Binary data
Re: $$Excel-Macros$$ Form tracker and new base
*Hi Anil, It was a awesome attempt, and done it, thanks for the same. But i have some again query, Please find the attached file, i have explained it clearly, i have added one more button, please find that. i want seems to be like search engine in the second form. thank you all the experts. * Thanks & Regards, Deba Ranjan P On Wed, May 16, 2012 at 11:41 AM, Anil Gawli wrote: > > > On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote: > >> *Dear Experts, Waiting for the revert with solution. Thanks >> * >> >> >> >> Thanks & Regards, >> Deba Ranjan P >> >> **** >> >> >> -- Forwarded message -- >> From: Deba Ranjan >> Date: Tue, May 15, 2012 at 10:22 AM >> Subject: $$Excel-Macros$$ Form tracker and new base >> To: excel-macros@googlegroups.com >> >> >> *Hi Experts, >> >>Very good morning, Dear groups and experts, i have some data base >> which need to be created in userform, i have explained in the attached >> file. Please help me sort out this problem. Thanks in advance. >> * >> >> >> Thanks & Regards,* >> * >> >> *Deba Ranjan P*** >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com up_validation_form.xlsm Description: Binary data
Fwd: $$Excel-Macros$$ Form tracker and new base
*Dear Experts, Waiting for the revert with solution. Thanks * Thanks & Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan Date: Tue, May 15, 2012 at 10:22 AM Subject: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com *Hi Experts, Very good morning, Dear groups and experts, i have some data base which need to be created in userform, i have explained in the attached file. Please help me sort out this problem. Thanks in advance. * Thanks & Regards,* * *Deba Ranjan P*** -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com validation form.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Form tracker and new base
*Hi Experts, Very good morning, Dear groups and experts, i have some data base which need to be created in userform, i have explained in the attached file. Please help me sort out this problem. Thanks in advance. * Thanks & Regards,* * *Deba Ranjan P*** -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com validation form.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Office stock
Hi Smitha,
Please try this too, its good working. below>>!!
*
=IF(R[-4]C="","",VLOOKUP(R[-4]C,'Stock n cnsmpn-May 2012'!C[-2]:C[2],5,0))
*
Thanks & Regards,*
*
*Deba Ranjan P***
On Thu, May 10, 2012 at 7:54 AM, NOORAIN ANSARI wrote:
> Hi Smitha,
>
> Please try it..
>
> =INDEX('Stock n cnsmpn-May 2012'!$E:$E,MATCH(Dashboard!C2,'Stock n
> cnsmpn-May 2012'!$A:$A,0))
>
> and see attached sheet.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Thu, May 10, 2012 at 7:13 AM, Smitha S R wrote:
>
>> Hi
>>
>> PFA the stock statement where I need help in the Dashboard. If I select,
>> the item I need the relevant closing stock in the next cell.
>> My formula is not working. Please help.
>>
>> Thanks
>> Smitha
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
--
FORUM RULES (986+ members already BANNED for violation)
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Graph formatting condition
*Thank you so much *Don Guillett. very thanks. Thanks & Regards,* * *Deba Ranjan P*** On Wed, May 9, 2012 at 7:41 PM, dguillett1 wrote: > Modified graph . You can make other changes to graph > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Deba Ranjan > *Sent:* Wednesday, May 09, 2012 7:11 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Graph formatting condition > > *Hi expert, > > >I have a query, Please find the attachment and help me out this > concern. I need graph format condition apply. thanks all in advance. > * > > > Thanks & Regards,* > * > > *Deba Ranjan P*** > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
*Congrats Rajan Shahab, And Thanks every member of Excel forum who have devoted their times in analytical for solving problem and vice versa. * Thanks & Regards,* * *Deba Ranjan P*** On Fri, May 4, 2012 at 2:45 PM, Ankit Agrawal wrote: > Congratulation Rajan and other excel's mentors. > > Regards, > Ankit > > > On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Rajan Verma has been selected as 'Most Helpful Member' for the month of >> April'2012 >> He has posted 185 posts in April 2012 and helped many people through his >> expertise. He has been consistent contributor to this excel forum and has >> acheived this recognition many times. >> >> Thanks to Don, Noorain, Asa, Maries, and other folks for helping excel >> enthusiasts voluntarily !! Keep it up !! >> >> Keep posting. >> >> Regards >> Ayush Jain >> Group Manager >> Microsoft MVP >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days
*Hi *Vijay, You can you try formula, it will help you out.:- For Date diffrence:- =DATEDIF(A2,(B2),"md") For Month diffrence :- =DATEDIF(A2,(B2),"ym") For Year diffrence :- =DATEDIF(A2,(B2),"y") Thanks & Regards,* * *Deba Ranjan P*** On Fri, May 4, 2012 at 12:39 PM, Vijayendra Rao wrote: > Dear All, > > > > I need date formula for finding how many days and months between two > different dates. Request you to resolve my query. I have attached is the > same file. > > > > Regards, > > Vijayendra > > 94491 67631 > > > > -- > ಧನ್ಯವಾದಗಳು, > ವಿಜಯೇಂದ್ರ, > ೯೪೪೯೧ ೬೭೬೩೧ > > Regards, > Vijayendra > 94491 67631 > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Time calculation sheet
*Hi Experts, I have attached the file which i am unable to calculate the time sheet. please help me out to sort out. thanks in advance. * Thanks & Regards,* * *Deba Ranjan P*** -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com time sheet cal.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Macro coding
*Thanks.. i will try to find out myself . Thanks once again. * Thanks & Regards,* * *Deba Ranjan P*** On Sat, Apr 28, 2012 at 5:42 PM, Rajan_Verma wrote: > These Codes are written by a Human not by machine .. you need to learn how > to write the Computer instruction, you can download books from internet and > can take help of group and forum to build up your programming skills. > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* Apr/Sat/2012 04:11 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Macro coding > > ** ** > > *Hi sir, > > See the below coding, you will find that there are so many steps and so > on. Can we run like so in the macros, if so please tell me the procedure to > that. > * > eg:- > > Sub Main() > ' Inserts random numbers on the active worksheet > Dim Counter As Integer > Dim RowMax As Integer, ColMax As Integer > Dim r As Integer, c As Integer > Dim PctDone As Single > > If TypeName(ActiveSheet) <> "Worksheet" Then Exit Sub > Cells.Clear > Application.ScreenUpdating = False > Counter = 1 > RowMax = 100 > ColMax = 25 > For r = 1 To RowMax > For c = 1 To ColMax > Cells(r, c) = Int(Rnd * 1000) > Counter = Counter + 1 > Next c > PctDone = Counter / (RowMax * ColMax) > With UserForm1 > .FrameProgress.Caption = Format(PctDone, "0%") > .LabelProgress.Width = PctDone * (.FrameProgress.Width - 10) > End With > ' The DoEvents statement is responsible for the form updating > DoEvents > Next r > Unload UserForm1 > End Sub > > > > > > Thanks & Regards, > > *Deba Ranjan P* > > ** ** > > ** ** > > ** ** > > On Sat, Apr 28, 2012 at 3:52 PM, Sam Mathai Chacko > wrote: > > What do you mean by appropriate code? > Regards, > Sam**** > > ** ** > > On Sat, Apr 28, 2012 at 3:42 PM, Deba Ranjan wrote:* > *** > > *Hi sir, > >I tried many times but the coding never comes, i mean the appropriate > coding never comes. kindly sort out. > * > > ** ** > > > > Thanks & Regards, > > *Deba Ranjan P* > > ** ** > > ** ** > > ** ** > > On Sat, Apr 28, 2012 at 2:17 PM, Sam Mathai Chacko > wrote: > > You can record macros in Excel. To know how to record macros, just do a > google search. > > REgards, > Sam Mathai Chack > > ** ** > > On Sat, Apr 28, 2012 at 1:42 PM, Deba Ranjan wrote:* > *** > > *Hi Experts, > > Is there any trick or any software to create macros coding. i have seen > many from the experts that they easily run the macros with the coding. > Please do let me the prevailing coding how to write the coding. > * > >Thanks in advance. Hope you all help me out for the coding. > > > > Thanks & Regards, > > *Deba Ranjan P* > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > > > > > -- > Sam Mathai Chacko > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-pro
