Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.
please add me 8308800600 On Mon, Aug 8, 2016 at 9:43 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > please add the my number 9811503853 > > On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: >> >> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you >> wants to join. >> >> Add me in WhatsApp and Msg me to - 9500087194 >> >> Regards, >> Prabhu.R >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Query on Extract word
This will work =IFERROR(IFERROR(MID(A2,FIND("MOC",A2,8),7),UPPER(MID(A2,FIND("moc",A2,7),8))),UPPER(MID(A2,FIND("Moc",A2,7),8))) However may of the cases it is written like MOC 9 or MOC - 08 hence some garbage is appearing. you can remove by text to coloumn command. Prashant On Wed, May 20, 2015 at 10:37 AM, Kal xcel wrote: > Dear Experts, > > Please help. Query is in the attached sheet. > > -- > *Kalyan Chattopadhyay* > > > *Executive Corporate MIS* > > *Joy Cosmetics* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Help Required
pls check On Wed, May 20, 2015 at 2:58 PM, Neeraj wrote: > Dear Experts, > > > > Kindly find the sheet and do the needful formula > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book71_1.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Re: Help needed
Dear Kumar, Deciding min Max level based on 3 month data is bit unscientific,you need to have at least 6 months data. Based on data provided by you, I have answered your queries. As mentioned by you GEOFORCE is external warehouse. It is not clear if the stock at other location is replenished from GEOFORCE,.Hence i have given two pivots and minitab box plot analysis. Hope this will solve your query. Prashant Pednekar. On Wed, Apr 15, 2015 at 10:50 PM, kumar wrote: > Hi, > > Any one looked at it? > > On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote: >> >> Hi, >> >> Just want to solve the questions with analysis. >> please find the enclosed attachment and answer the question. I also >> trying to solve. But needed Gurus help. >> >> Thanks >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample data for Analyst_pp.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Re: Need macro help
Dear Mandeep, This was wonderful file. I used it for one of my project. However required one improvement. Tried to see the code, but it is lock hence. need your guidance. - I need to select entire data in sheet. currently it is not taking data after black rows. - The color and formating becomes default of current sheet. Will great help if you can support Prashant. On Fri, Mar 6, 2015 at 11:28 AM, Mandeep Baluja wrote: > Dear Check this file ;) > > Regards, > Mandeep > > > > > On Thursday, March 5, 2015 at 8:39:29 PM UTC+5:30, Prabhu Pinky wrote: >> >> Hi experts, >> I have around 10-15 excel file in a folder and updated every week. >> I need macro in master file which will open each file from folder and >> copy in master file. >> >> Please help me on this. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Happy New 2015
Dear All Happy new Year to you all. Lets keep journey of collective knowledge addition. Prashant On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi wrote: > Joyous January –Fabulous February > > Magical March –Adorable April > > Magnificent May –Jolly June > > Jubilant July –Awesome August > > ScintillatingSeptember –Outstanding October > > Naughty November –Dazzling December > > This is how I sincerely wish your New Year to be! > > Yu Year – Happy Year.. > > A Very Happy New Year 2015! To all group members. > > Cheers!! > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Fwd: $$Excel-Macros$$ MS Excel 2003 to 2010
Good morning all. Sorry ! I did not used *Please help.* in my earlier mail. Request you to help me. Thanks Prashant. -- Forwarded message -- From: Prashant Pednekar Date: Mon, Oct 14, 2013 at 3:21 PM Subject: $$Excel-Macros$$ MS Excel 2003 to 2010 To: excel-macros@googlegroups.com Dear friends We are migrating from MS Excel 2003 to Excel 2010 Dose any one of you has Menu and commond by command comparion in both version.s i.e. 2003 2010 Data > Validation ??? Else is anyone has related material. Regards Prashant -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ MS Excel 2003 to 2010
Dear friends We are migrating from MS Excel 2003 to Excel 2010 Dose any one of you has Menu and commond by command comparion in both version.s i.e. 2003 2010 Data > Validation ??? Else is anyone has related material. Regards Prashant -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?
Dear Chaya The solution from Ashish (using offset command) has lesser effort than using macro. I suggest to use the same for your multiple entries. using macro is possible in 2008 . no issue. For your information. you have to use Ctrl+ shift + A at first column of each row required. Regards Prashant. On Tue, Aug 20, 2013 at 10:30 AM, Chaya Cooper wrote: > Ashish, > > That's exactly what I needed :-D > > Would you mind showing me how to use it? > > - Chaya > > > On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote: > >> Hi try the attachment . see if it helps >> >> >> >> >> On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar wrote: >> >>> Hi Chaya, Prabhu, >>> >>> Done with a simple macro. >>> >>> Use Control + Shift + A at particular cell where you want to transpose. >>> >>> This you have to to for every entry. >>> >>> In case you want it for mulitiple entries there shall be different macro >>> required. >>> >>> While running this macro, Check your macro security setting. I guess it >>> it is "High to Very high" Change it to Medium. >>> >>> Regards >>> Prashant >>> >>> >>> On Tue, Aug 20, 2013 at 6: >>> 15 AM, Chaya Cooper wrote: >>> >>>> Thanks for clarifying :-) >>>> >>>> Here's a sample file with 2 sheets, one with the original (unedited) >>>> data, and one with the data in the correct format :-) >>>> >>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/**discussexcel<https://www.facebook.com/discussexcel> >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to excel-macros...@**googlegroups.com. >>>> To post to this group, send email to excel-...@googlegroups.com. >>>> >>>> Visit this group at >>>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros> >>>> . >>>> For more options, visit >>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>> . >>>> >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/**discussexcel<https://www.facebook.com/discussexcel> >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it,
Re: $$Excel-Macros$$ Unlock Cells on Condations
Dear Dave, and other friends. I am using belwo code for locking rows. It is not working. Can you let me know where i am going wrong. my date value is in first column. Private Sub Worksheet_Activate() ActiveSheet.Unprotect Rows("5:1200").Locked = True With Range("A5:A1500") Set r = .Find(Date, LookIn:=xlFormulas, lookat:=xlWhole) If Not r Is Nothing Then Rows(r.Row).Locked = False End With ActiveSheet.Protect End Sub Regards Prashant On Wed, Jan 20, 2010 at 5:12 AM, Selva wrote: > Hi, > > I need some assistance in unlocking a range of cells based on date > conditions > > For example, B1:B32 has dates for the month and based on today's date, > it should unlock the entire column to allow the user to enter the > data. > > It should not allow the user to enter data for yesterday or > tomorrow... > > Cell should be open only for today's date. > > Thanks for your help. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes > about the learning and support from the group.Let friends and co-workers > know they can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Want to convert on Text in each cell to rows
Hi all I want to convert on Text in each cell to rows ? In each Cell has 50 + numbers one below one. e.g. 09:51:18 09:51:31 09:52:04 There are five such columns. Can any one help me to convert to rows? Regards. prashant -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: merging worksheet.
Hi all received the macro on below link..giving this for your referance. http://www.mrexcel.com/archive/VBA/17846.html Posted by Damon Ostrander on January 25, 2002 3:03 PM Hi SLP, Here's a little macro that makes merging sheets easy. Just select the sheets you want merged making sure the active sheet (visible one) is the one you want to merge to. The rows from all the other selected sheets will be copied to end of the active sheet in left-to-right order of worksheet tabs. It allows you to declare a number of header lines (NHR value) so that you don't copy the worksheet's headers to the first sheet. This macro should be put into a macro module. If you don't know how to install/run a macro, just follow up and I'll give you instructions. Damon Sub MergeSheets() ' Merges data from all the selected worksheets onto the end of the ' active worksheet. Const NHR = 1 'Number of header rows to not copy from each MWS Dim MWS As Worksheet 'Worksheet to be merged Dim AWS As Worksheet 'Worksheet to which the data are transferred Dim FAR As Long 'First available row on AWS Dim LR As Long 'Last row on the MWS sheets Set AWS = ActiveSheet For Each MWS In ActiveWindow.SelectedSheets If Not MWS Is AWS Then FAR = AWS.UsedRange.Cells(AWS.UsedRange.Cells.Count).Row + 1 LR = MWS.UsedRange.Cells(MWS.UsedRange.Cells.Count).Row MWS.Range(MWS.Rows(NHR + 1), MWS.Rows(LR)).Copy AWS.Rows(FAR) End If Next MWS End Sub On Sat, Jun 5, 2010 at 10:57 PM, Prashant Pednekar wrote: > Dear Experts. > > I have a eight workbooks of telephone billing statement which are > converted from pdf file to excel. Each workbook contain 135 > worksheets. Each sheet contain the data like Date/Time, Number, > Destination, Duration, Call charges. in two table. The useful data of > each worksheet is from Cell A14 to Cell M74. > > My requirement is merge data from all worksheets on worksheet > ascendingly i.e from sheet 1 data to sheet 135. I am confidant that > this can be solved using macro. I request your help to guide me for > the logic. > > Regards. > > Prashant. > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ merging worksheet.
Dear Experts. I have a eight workbooks of telephone billing statement which are converted from pdf file to excel. Each workbook contain 135 worksheets. Each sheet contain the data like Date/Time, Number, Destination, Duration, Call charges. in two table. The useful data of each worksheet is from Cell A14 to Cell M74. My requirement is merge data from all worksheets on worksheet ascendingly i.e from sheet 1 data to sheet 135. I am confidant that this can be solved using macro. I request your help to guide me for the logic. Regards. Prashant. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re:Re: Excel Ppt Interface... Please help..Help.
On Fri, Mar 26, 2010 at 3:24 PM, Prashant Pednekar wrote: > On Thu, Mar 25, 2010 at 2:32 PM, Prashant Pednekar > wrote: >> Dear All, >> >> I am having presentation (PPT) of 3 slide. Each slide contains one excel >> sheet. >> The last slide will have sum of values of Sheet 1 to 2 (i.e. Slide 1 &2 ). >> >> The original file is having some inportant data hence I am attaching the >> representative file. >> >> My question. >> 1. How to relate each Excel sheet in each sheet ot last sheet. >> 2. I use Excel in each file because of validations in some cells. Is is >> possible make validation & Calculations in PPT. >> >> Regards >> >> Prashant. >> -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
$$Excel-Macros$$ Re: Excel Ppt Interface... Please help..
On Thu, Mar 25, 2010 at 2:32 PM, Prashant Pednekar wrote: > Dear All, > > I am having presentation (PPT) of 3 slide. Each slide contains one excel > sheet. > The last slide will have sum of values of Sheet 1 to 2 (i.e. Slide 1 &2 ). > > The original file is having some inportant data hence I am attaching the > representative file. > > My question. > 1. How to relate each Excel sheet in each sheet ot last sheet. > 2. I use Excel in each file because of validations in some cells. Is is > possible make validation & Calculations in PPT. > > Regards > > Prashant. > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > To unsubscribe from this group, send email to > excel-macros+unsubscribegooglegroups.com or reply to this email with the > words "REMOVE ME" as the subject. > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
$$Excel-Macros$$ pop up calender in excel cell
HI Dose any one have pop up calender in excel cell. Regards, Prashant. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Filter problem
Dear Sathish & Harmeet Thanks for clarificaiton. Regards. On Wed, Sep 9, 2009 at 2:32 AM, Harmeet Singh wrote: > Hi Prashant, Unfortunately, excel can show you first 100 unique entries > only in auto filter (It is hard coded in Excel) > > Workaround can be pivot table. > > > > On Tue, Sep 8, 2009 at 11:56 AM, Prashant Pednekar > wrote: > >> Dear all >> >> Thanks for the knowlege enrichment of excel by you all... >> >> I am facing problem with Filter. While filtering data I am not able to see >> the data after specific cell. >> See the filter range.bmp. >> In the file i am not able to see the rows after value 3264.( see Book >> master 2. worksheet in filter problem file) >> >> But If I am using custom filter for values above 3260 and the rows all >> rows after 3260 can be views.( see Book master 3. worksheet in filter >> problem file) >> >> My problem How I can see the values after 3264 in book master 2 worksheet >> ? >> >> >> Thanks for your time . >> >> Waiting for your reply. >> >> Prashant. >> >> >> > > > -- > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Cell Validation - Conditional
On Tue, Apr 14, 2009 at 12:24 PM, Suryaprasad.bv wrote: > Prashant, > > Can you post me a sample file so that i can help you out > > Cheers > Surya > > > > On Tue, Apr 14, 2009 at 12:16 PM, Prashant Pednekar > wrote: > >> Hi All >> >> here my doubt is >> The Validation is not having constraint, >> i.e. afte entering one product and specification, if i am again changing >> the product.the specifition remain same? >> >> Eg. >> Product 2 Specification 6 >> >> how can we resolve this ? >> >> Regards. >> Prashant. >> On Wed, Apr 8, 2009 at 11:33 PM, Harmeet Singh >> wrote: >> >>> Plz find attached file. >>> >>> >>> >>> >>> On Wed, Apr 8, 2009 at 4:10 PM, SANDEEP wrote: >>> >>>> >>>> Dear All, >>>> I require a macro for Cell Validation and drop down list - for 2nd >>>> column as described below >>>> >>>> 1st column contains the list of Items(Product Names) for which i have >>>> given a Validation and cell drop down >>>> 2nd column - I want the validation and cell drop down to contain only >>>> the specification for the product selected in the First Column. For >>>> example >>>> if i select the product Bottle Oval in 1st column - in the second column >>>> drop down i should get only the specification available for Bottle Oval >>>> such >>>> as 5 ml; 10 ml; 50 ml. >>>> >>>> the list of Product and Specification master available is as follows >>>> >>>>Product 1 >>>> >>>> Specification 1 >>>> >>>> Product 1 >>>> >>>> Specification 4 >>>> >>>> Product 1 >>>> >>>> Specification 6 >>>> >>>> Product 1 >>>> >>>> Specification 10 >>>> >>>> Product 2 >>>> >>>> Specification 4 >>>> >>>> Product 2 >>>> >>>> Specification 10 >>>> >>>> Product 3 >>>> >>>> Specification 1 >>>> >>>> Product 3 >>>> >>>> Specification 2 >>>> >>>> Product 3 >>>> >>>> Specification 3 >>>> >>>> Product 3 >>>> >>>> Specification 4 >>>> >>>> Product 3 >>>> >>>> Specification 5 >>>> >>>> Product 3 >>>> >>>> Specification 6 >>>> >>>> Regards, >>>> Sandeep >>>> >>>> >>>> >>>> >>> >>> >>> -- >>> Thanks & Regards, >>> >>> Harmeet Singh >>> >>> >>> >> >> >> > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- sandy.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Cell Validation - Conditional
Hi All here my doubt is The Validation is not having constraint, i.e. afte entering one product and specification, if i am again changing the product.the specifition remain same? Eg. Product 2 Specification 6 how can we resolve this ? Regards. Prashant. On Wed, Apr 8, 2009 at 11:33 PM, Harmeet Singh wrote: > Plz find attached file. > > > > > On Wed, Apr 8, 2009 at 4:10 PM, SANDEEP wrote: > >> >> Dear All, >> I require a macro for Cell Validation and drop down list - for 2nd >> column as described below >> >> 1st column contains the list of Items(Product Names) for which i have >> given a Validation and cell drop down >> 2nd column - I want the validation and cell drop down to contain only the >> specification for the product selected in the First Column. For example if >> i select the product Bottle Oval in 1st column - in the second column drop >> down i should get only the specification available for Bottle Oval such as 5 >> ml; 10 ml; 50 ml. >> >> the list of Product and Specification master available is as follows >> >>Product 1 >> >> Specification 1 >> >> Product 1 >> >> Specification 4 >> >> Product 1 >> >> Specification 6 >> >> Product 1 >> >> Specification 10 >> >> Product 2 >> >> Specification 4 >> >> Product 2 >> >> Specification 10 >> >> Product 3 >> >> Specification 1 >> >> Product 3 >> >> Specification 2 >> >> Product 3 >> >> Specification 3 >> >> Product 3 >> >> Specification 4 >> >> Product 3 >> >> Specification 5 >> >> Product 3 >> >> Specification 6 >> >> Regards, >> Sandeep >> >> >> >> > > > -- > Thanks & Regards, > > Harmeet Singh > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---