RE: $$Excel-Macros$$ Stock prices data fetching through VBA
PLS PROVIDE LINK OF THAT WEBSITE. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Murali prasad Sent: Tuesday, September 17, 2013 12:29 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Stock prices data fetching through VBA im trying to get the prices data from chartsapi.finance.yahoo.com to excel... by giving the inputs like -- scrip name, date from, date to, time frame, by which the url is developed based on inputs and get data to excel... output as below: date--time--open price--high price--low price--close price--volume. thanks regards, murali -- 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$$ Splitting single browser is possible ?
Hey Guys Does splitting of single window is possible on IE through VB programming ? Regards Abhidha -- 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$$ Splitting single browser is possible ?
Can u explain the requirement in details with image of screen if possible Sent on my BlackBerry® from Vodafone -Original Message- From: Abhidha Dixit abhidha.di...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 17 Sep 2013 13:10:57 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Splitting single browser is possible ? Hey Guys Does splitting of single window is possible on IE through VB programming ? Regards Abhidha -- 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$$ Formula: Count
Hello, I need formula to count no of points based on condtion please find attached file. Thanks, Chandra -- 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. MultiCount.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need Formula
try d3 = =LEFT(B3,3) e3 = =LEFT(RIGHT(B3,LEN(B3)-FIND(,,B3)-1),3) see if it helps On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Experts, Please find the attached file, please revert with appropriate formula for my requirement Thanks 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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$$ Copy Past Macro help
try this see if it helps Sub replace_tracker() Dim i As Long, j As Long For i = 2 To Sheets(Tracker).Range(a65356).End(xlUp).Row With Application.WorksheetFunction If .CountIf(Sheets(Daily Report).Range(a:a), Sheets(Tracker).Range(a i).Value) = 1 Then j = .Match(Sheets(Tracker).Range(a i).Value, Sheets(Daily Report).Range(a:a), 0) Sheets(Tracker).Range(d i).Value = Sheets(Daily Report).Range(b j) Sheets(Tracker).Range(e i).Value = Sheets(Daily Report).Range(c j) Sheets(Tracker).Range(f i).Value = Sheets(Daily Report).Range(d j) Sheets(Tracker).Range(g i).Value = Sheets(Daily Report).Range(e j) End If End With Next End Sub On Mon, Sep 16, 2013 at 11:56 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Yes On 16 Sep 2013 20:12, ashish koul koul.ash...@gmail.com wrote: do u want to replace the exiting info on Tracker from Daily Report tab On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Hi, I am really new in macro, can you please help me in attached excel as well L I tired the same principle which you sent me last time. I have my entire report in tracker file which I send to team and they sent me update daily in Daily report sheet. But they only work on few line items Now I want to update my tracker sheet based on Sr. no. Currently I check serial number and manually copy past all corresponding fields from daily report. -- Regards, Shraddha Malvankar On Sat, Sep 14, 2013 at 11:21 AM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Genius man……. Thank you very much for help…This is exactly what I wanted….. Really appreciated your help. Regards, Shraddha On Sat, Sep 14, 2013 at 7:26 AM, ashish koul koul.ash...@gmail.comwrote: try this see if it works Sub send_venddetails() Dim i As Long Dim flname As String Dim objOL As Object Dim wkb As Workbook Set objOL = CreateObject(Outlook.Application) For i = 2 To Sheets(data).Range(a65356).End(xlUp).Row With Sheets(Verification) 'clear exisitng if required .Range(a4).Value = .Range(g4).Value = .Range(a6).Value = .Range(g6).Value = .Range(a8).Value = .Range(g8).Value = .Range(a10).Value = .Range(g10).Value = .Range(a12).Value = 'add new .Range(a4).Value = Sheets(data).Range(b i).Value .Range(g4).Value = Sheets(data).Range(a i).Value .Range(a6).Value = Sheets(data).Range(c i).Value .Range(g6).Value = Sheets(data).Range(d i).Value .Range(a8).Value = Sheets(data).Range(e i).Value .Range(g8).Value = Sheets(data).Range(f i).Value .Range(a10).Value = Sheets(data).Range(g i).Value .Range(g10).Value = Sheets(data).Range(h i).Value .Range(a12).Value = Sheets(data).Range(i i).Value End With 'send email now Sheets(Verification).Copy flname = VBA.Environ(temp) \ VBA.Format(VBA.Now, dd_mmm__hh_mm_ss) .xlsx Set wkb = ActiveWorkbook wkb.SaveAs flname Set olMail = objOL.CreateItem(olMailItem) With olMail .To = Sheets(Verification).Range(a12) .Subject = Verification .Attachments.Add flname .Body = Please verfiyy-- .display End With wkb.Close Kill flname Set olMail = Nothing Next Set olApp = Nothing End Sub On Fri, Sep 13, 2013 at 11:56 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Outlook. Regards, Shraddha On Friday, 13 September 2013 22:10:58 UTC+4, ashish wrote: Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -- *From: * shraddha malvankar shraddha...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 13 Sep 2013 10:57:37 -0700 (PDT) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *$$Excel-Macros$$ Copy Past Macro help Hi, Need help in macro for attached file. I have one excel sheet where as I have around 500 vendors and I need to send mail to each vendor as per their email id but after filling up their respective data in verification sheet. I would like to auto populate the filed from data sheet to Verification sheet. This should happen for each line in data sheet. After which data sheet should get deleted and file should get saved by Vendor Name If possible this file should get sent to each vendor as per their email id Really appreciation your help. Thanks in advance. -- 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/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.
Re: $$Excel-Macros$$ Formula: Count
xy1? what does this mean do you want to count RS with point 1 and so on Regards Ashish On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, I need formula to count no of points based on condtion please find attached file. Thanks, Chandra -- 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. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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$$ Splitting single browser is possible ?
I dont have any idea about this . Try this addon Iesplit 2.1 http://www.softpedia.com/get/Internet/Other-Internet-Related/IE-Split.shtml Regards Ashish On Tue, Sep 17, 2013 at 3:40 PM, Abhidha Dixit abhidha.di...@gmail.comwrote: Hi Ashish the reqirement is attached as Bing And yahoo is on the same window in half partition Regards Abhidha On Tue, Sep 17, 2013 at 1:10 PM, Abhidha Dixit abhidha.di...@gmail.comwrote: Hey Guys Does splitting of single window is possible on IE through VB programming ? Regards Abhidha -- 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. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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$$ Check Box In Excel
Hi Friends, In Excel 2010, I would like to create a list of name in Sheet 1 and residing to that names I need check boxes; If i click any check box the name residing to it should go to the list in Sheet 2. How is it possible to create a Excel sheet using the above information. With Hope And Regards, Rejeeb -- 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$$ Check Box In Excel
Can u share a sample file On Tue, Sep 17, 2013 at 10:05 PM, Rejeeb Abdulrahiman rejeeb@gmail.comwrote: Hi Friends, In Excel 2010, I would like to create a list of name in Sheet 1 and residing to that names I need check boxes; If i click any check box the name residing to it should go to the list in Sheet 2. How is it possible to create a Excel sheet using the above information. With Hope And Regards, Rejeeb -- 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. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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$$ Re: macro for required data please find the attachment once
Dear Experts thanks alot Hi *De Premor / Enrique Martin** ** *thanks for giving this macro this would be save my time alot and alot thanks On Tuesday, 17 September 2013 01:46:47 UTC+5:30, renuka chari wrote: Dear experts. please solve my query its very very urgent macro for required data please find the attachment once thanks *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* * * *P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources.* -- 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$$ Copy Past Macro help
Hi Ashish, Its working perfectly. Thank you very much for all the help :-) Regards, Shraddha On Tue, Sep 17, 2013 at 7:12 PM, ashish koul koul.ash...@gmail.com wrote: try this see if it helps Sub replace_tracker() Dim i As Long, j As Long For i = 2 To Sheets(Tracker).Range(a65356).End(xlUp).Row With Application.WorksheetFunction If .CountIf(Sheets(Daily Report).Range(a:a), Sheets(Tracker).Range(a i).Value) = 1 Then j = .Match(Sheets(Tracker).Range(a i).Value, Sheets(Daily Report).Range(a:a), 0) Sheets(Tracker).Range(d i).Value = Sheets(Daily Report).Range(b j) Sheets(Tracker).Range(e i).Value = Sheets(Daily Report).Range(c j) Sheets(Tracker).Range(f i).Value = Sheets(Daily Report).Range(d j) Sheets(Tracker).Range(g i).Value = Sheets(Daily Report).Range(e j) End If End With Next End Sub On Mon, Sep 16, 2013 at 11:56 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Yes On 16 Sep 2013 20:12, ashish koul koul.ash...@gmail.com wrote: do u want to replace the exiting info on Tracker from Daily Report tab On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Hi, I am really new in macro, can you please help me in attached excel as well L I tired the same principle which you sent me last time. I have my entire report in tracker file which I send to team and they sent me update daily in Daily report sheet. But they only work on few line items Now I want to update my tracker sheet based on Sr. no. Currently I check serial number and manually copy past all corresponding fields from daily report. -- Regards, Shraddha Malvankar On Sat, Sep 14, 2013 at 11:21 AM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Genius man……. Thank you very much for help…This is exactly what I wanted….. Really appreciated your help. Regards, Shraddha On Sat, Sep 14, 2013 at 7:26 AM, ashish koul koul.ash...@gmail.comwrote: try this see if it works Sub send_venddetails() Dim i As Long Dim flname As String Dim objOL As Object Dim wkb As Workbook Set objOL = CreateObject(Outlook.Application) For i = 2 To Sheets(data).Range(a65356).End(xlUp).Row With Sheets(Verification) 'clear exisitng if required .Range(a4).Value = .Range(g4).Value = .Range(a6).Value = .Range(g6).Value = .Range(a8).Value = .Range(g8).Value = .Range(a10).Value = .Range(g10).Value = .Range(a12).Value = 'add new .Range(a4).Value = Sheets(data).Range(b i).Value .Range(g4).Value = Sheets(data).Range(a i).Value .Range(a6).Value = Sheets(data).Range(c i).Value .Range(g6).Value = Sheets(data).Range(d i).Value .Range(a8).Value = Sheets(data).Range(e i).Value .Range(g8).Value = Sheets(data).Range(f i).Value .Range(a10).Value = Sheets(data).Range(g i).Value .Range(g10).Value = Sheets(data).Range(h i).Value .Range(a12).Value = Sheets(data).Range(i i).Value End With 'send email now Sheets(Verification).Copy flname = VBA.Environ(temp) \ VBA.Format(VBA.Now, dd_mmm__hh_mm_ss) .xlsx Set wkb = ActiveWorkbook wkb.SaveAs flname Set olMail = objOL.CreateItem(olMailItem) With olMail .To = Sheets(Verification).Range(a12) .Subject = Verification .Attachments.Add flname .Body = Please verfiyy-- .display End With wkb.Close Kill flname Set olMail = Nothing Next Set olApp = Nothing End Sub On Fri, Sep 13, 2013 at 11:56 PM, shraddha malvankar shraddhamalvan...@gmail.com wrote: Outlook. Regards, Shraddha On Friday, 13 September 2013 22:10:58 UTC+4, ashish wrote: Hi R u using lotus notes or outlook for sending emails Regards Ashish Sent on my BlackBerry® from Vodafone -- *From: * shraddha malvankar shraddha...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 13 Sep 2013 10:57:37 -0700 (PDT) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *$$Excel-Macros$$ Copy Past Macro help Hi, Need help in macro for attached file. I have one excel sheet where as I have around 500 vendors and I need to send mail to each vendor as per their email id but after filling up their respective data in verification sheet. I would like to auto populate the filed from data sheet to Verification sheet. This should happen for each line in data sheet. After which data sheet should get deleted and file should get saved by Vendor Name If possible this file should get sent to each vendor as per their email id Really appreciation your help. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
$$Excel-Macros$$ Set range and action according to sheet name
Hi all I am new to this group so I hope someone can kindly assist.. To say I am a novice in macros is an understatement so please forgive my ignorance.. I tried to solve this but do not have the knowledge to do so and therefore appreciate your help... Currently my Macro should: 1. Turn off any filters 2. Number column A from 1 to 1000 (starting in A14) 3. Drags formula from K14-O14 down to last row of data shown in column A 4. then puts cursor in last empty cell in column B ready for user to enter data On point 3 - I want the range to be K14-O14 if active worksheet equals EXCHANGES but if its on the VALUATIONS tab the autofill range should be L14-P14..there are other sheets where the range changes also but if I at least have the format I can add those in. I have found bits and pieces of macros on the internet and put them together so please excuse if my macro below is not the most effective for my needs but here it is in it's current state: Here is my macro: Sub AddNewEntry() 'TURNS OFF FILTER IF FINDS ONE ON Dim wks As Worksheet ActiveSheet.Select For Each wks In ActiveWorkbook.Worksheets If ActiveSheet.AutoFilterMode Then ActiveSheet.Range(b13).AutoFilter End If Next wks 'Numbers column A from 1 to 1000 so that formulas drag down to end Range(A14).Select ActiveCell.FormulaR1C1 = 1 Range(A15).Select ActiveCell.FormulaR1C1 = 2 Range(A14:A15).Select Selection.AutoFill Destination:=Range(A14:A1013) 'drags formulas based on last entry in column A Dim LR As Long LR = Range(A2000).End(xlUp).Row Range(K14:O14).AutoFill Destination:=Range(K14:O LR) 'Find the last used row in a Column: column B in this example Dim FirstBlankCell As Range Set FirstBlankCell = Range(B Rows.Count).End(xlUp).Offset(1, 0) FirstBlankCell.Activate Dim LastRow As Long Dim NextRow As Long With ActiveSheet LastRow = .Cells(.Rows.Count, B).End(xlUp).Row End With NextRow = LastRow + 1 End Sub Many thanks in advance! -- 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$$ Attrition template
Hi, I am looking for some attrition calculator spreadsheet. I am working on creating the attrition calculation which calculates attrition “Tenure wise, Process Wise, Location Wise, Leaving reasons, Day/night” etc… Need your support on that. Any template will help a lot. Regards, Sushil -- 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$$ How to capture Frame Click Event when click on the actual frame of a Frame?
I created a UserForm. The form has several frames (for VB folks, VBA frames are called groups in VB for some reason). I created a sub routine: Private Sub fraMyFrame_Click() DoStuff End Sub If I click *inside* the frame then the click event is triggered and DoStuff runs. In a seemingly bizarre irony, if I click the actual frame itself (the caption or the border lines) it doesn't fire the event!! That makes NO sense. How can it be that clicking the frame of a Frame doesn't trigger the Frame's click event??!! BTW, I have a sub routine for the UserForm_Click event, but clicking the Frame's actual frame doesn't fire that off either. Does anyone know of a work around to it? 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/groups/opt_out.
$$Excel-Macros$$ Need help in forecast
Hi Experts, i have historical pattern of last few month daywise daily offered. is there possible to calculate the next month overall volume by using excel. if anyone have this kind of template please share. Thanks 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Formula: Count
Check the Attachment... On Tue, Sep 17, 2013 at 8:45 PM, ashish koul koul.ash...@gmail.com wrote: xy1? what does this mean do you want to count RS with point 1 and so on Regards Ashish On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, I need formula to count no of points based on condtion please find attached file. Thanks, Chandra -- 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. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- 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. Copy of MultiCount.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need help in forecast
Hi Prabhu, I can help you if you can share data with me... On Wednesday, September 18, 2013 8:59:41 AM UTC+5:30, prabhupink80 wrote: Hi Experts, i have historical pattern of last few month daywise daily offered. is there possible to calculate the next month overall volume by using excel. if anyone have this kind of template please share. Thanks 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ VBA Break Links in powerpoint Chart Object
Hi Expert, Any idea how to break the links in chart object in powerpoint through VBA code. -- Thanks regards Satheeshkumar -- 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$$ Formula: Count
Hi, Another way!! =SUM((E$1=$B$2:$B$10)*($C2=$A$2:$A$10)) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anoop K Sharma Sent: Wednesday, September 18, 2013 10:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula: Count Check the Attachment... On Tue, Sep 17, 2013 at 8:45 PM, ashish koul koul.ash...@gmail.com mailto:koul.ash...@gmail.com wrote: xy1? what does this mean do you want to count RS with point 1 and so on Regards Ashish On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar chandrashekarb@gmail.com mailto:chandrashekarb@gmail.com wrote: Hello, I need formula to count no of points based on condtion please find attached file. Thanks, Chandra -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com mailto: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. -- Regards Ashish Koul Visit My Excel Blog http://www.excelvbamacros.com/ Like Us on Facebook http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com mailto: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. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- 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 mailto:excel-macros+unsubscr...@googlegroups.com . To post to this group, send email to