Re: $$Excel-Macros$$ Set range and action according to sheet name
Dear Melimob, Pl share a workbook with us. Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 18, 2013 at 12:29 AM, Melimob melissasobrien...@gmail.com wrote: 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: Turn off any filters Number column A from 1 to 1000 (starting in A14) Drags formula from K14-O14 down to last row of data shown in column A 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. -- 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$$ Need experts help ***URGENT***
Dear Indrajit Workbooks.Open fil,,false Try using above code . Pl reply Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai talk2indra...@gmail.com wrote: Hi Experts, I am facing some problem with this macro file, actually the macro is running pretty well, but need some changes on it, which I am not able to do, kindly try to sort out the below requirements: 1. Suppose I have too many files with the same column headers (like the master file) in a particular folder, but I just want to copy the data from Cell A3:L3 (from each files) and paste it in the master tracker (PFA). 2. If the some of the slave files are in read-only mode, still the master fill will be able to copy and paste the data from all the slave files. Thanks in advance for your kind support. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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.
RE: $$Excel-Macros$$ Formula: Count
PFA OR USE =SUM((C2=IF(FREQUENCY(MATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0),M ATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0))0,$A$2:$A$15))*1) WITH CSE From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Wednesday, September 18, 2013 4:13 PM To: excel-macros@googlegroups.com Cc: ashish koul Subject: Re: $$Excel-Macros$$ Formula: Count Hello, Thanks for your replies. Formulas are working for one set of data but its not working for other criterias I have attached new excel could you please check it. Ashish - I am trying to get count of unique records based on multi conditions where I know what is Condition1 but I will be not knowing what would be condition2. Thanks, Chandra On Wed, Sep 18, 2013 at 12:30 PM, Ravinder ravinderexcelgr...@gmail.com wrote: =SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,), ),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),)),1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Tuesday, September 17, 2013 6:00 PM To: excel-macros@googlegroups.com Subject: $$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. -- 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. 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
$$Excel-Macros$$ grouping data of range boundaries...
Hi Experts Hope you all doing good... i need help on summing the data for the grouped range boundaries file attached for the easy reference... thanking you... 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. grouped data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need experts help ***URGENT***
Both of you are simply AWESOME!!! Just need a small change, I actually want consolidate a particular range from the salve files, like from A3:L3, not the whole file, actually it's consolidating the whole file! Guys can you do some changes on it, and revert me the same. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, I am facing some problem with this macro file, actually the macro is running pretty well, but need some changes on it, which I am not able to do, kindly try to sort out the below requirements: 1. Suppose I have too many files with the same column headers (like the master file) in a particular folder, but I just want to copy the data from Cell A3:L3 (from each files) and paste it in the master tracker (PFA). 2. If the some of the slave files are in read-only mode, still the master fill will be able to copy and paste the data from all the slave files. Thanks in advance for your kind support. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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.
Re: $$Excel-Macros$$ Stock prices data fetching through VBA
Respected Murali, Just try the Indian comapnies tickers in place of foreign companies or there may be a different URL for Indian companies in Yahoo finance.Have you checked that aspect also?As I am a novice or rookie in VBA ,I cannot help you in that angle.Our experts may be of your help and there are may sites also that meet your requirement. Regards, Vijaykumar On Thu, Sep 19, 2013 at 12:57 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Murali, To fetch Indian stocks you need indian companies indexes that is like IBM for IBM etc.Please find the atthment to get indian stock quotes. Regards, Vijaykumar -- P.VIJAY KUMAR -- 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
Hello, Thank a lot its working fine. Regards, Chandra On Thu, Sep 19, 2013 at 12:08 PM, Ravinder ravinderexcelgr...@gmail.comwrote: PFA OR USE =SUM((C2=IF(FREQUENCY(MATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0),MATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0))0,$A$2:$A$15))*1) WITH CSE ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Wednesday, September 18, 2013 4:13 PM *To:* excel-macros@googlegroups.com *Cc:* ashish koul *Subject:* Re: $$Excel-Macros$$ Formula: Count ** ** Hello, Thanks for your replies. Formulas are working for one set of data but its not working for other criterias I have attached new excel could you please check it. *Ashish - *I am trying to get count of unique records based on multi conditions where I know what is Condition1 but I will be not knowing what would be condition2. Thanks, Chandra On Wed, Sep 18, 2013 at 12:30 PM, Ravinder ravinderexcelgr...@gmail.com wrote: =SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),)),1)) *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Tuesday, September 17, 2013 6:00 PM *To:* excel-macros@googlegroups.com *Subject:* $$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. -- 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
Re: $$Excel-Macros$$ Stock prices data fetching through VBA
Respected vijay, Thank you very much for the support, i have tried with indian codes only, unfortunately its not working... On Thu, Sep 19, 2013 at 1:22 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Murali, Just try the Indian comapnies tickers in place of foreign companies or there may be a different URL for Indian companies in Yahoo finance.Have you checked that aspect also?As I am a novice or rookie in VBA ,I cannot help you in that angle.Our experts may be of your help and there are may sites also that meet your requirement. Regards, Vijaykumar On Thu, Sep 19, 2013 at 12:57 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Murali, To fetch Indian stocks you need indian companies indexes that is like IBM for IBM etc.Please find the atthment to get indian stock quotes. Regards, Vijaykumar -- P.VIJAY KUMAR -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/UtFUHNLpjh8/unsubscribe. To unsubscribe from this group and all its topics, 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.
Re: $$Excel-Macros$$ Need experts help ***URGENT***
Thanks a lot bro. :D It works like a charm. :D -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Sep 19, 2013 at 12:53 PM, Ravinder ravinderexcelgr...@gmail.comwrote: Pfa….. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, September 19, 2013 12:49 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need experts help ***URGENT*** ** ** Both of you are simply AWESOME!!! ** ** Just need a small change, I actually want consolidate a particular range from the salve files, like from A3:L3, not the whole file, actually it's consolidating the whole file! ** ** Guys can you do some changes on it, and revert me the same. ** ** Thanks in advance. ** ** -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. ** ** ** ** ** ** On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai talk2indra...@gmail.com wrote: Hi Experts, ** ** I am facing some problem with this macro file, actually the macro is running pretty well, but need some changes on it, which I am not able to do, kindly try to sort out the below requirements: ** ** 1. Suppose I have too many files with the same column headers (like the master file) in a particular folder, but I just want to copy the data from Cell A3:L3 (from each files) and paste it in the master tracker (PFA). ** ** 2. If the some of the slave files are in read-only mode, still the master fill will be able to copy and paste the data from all the slave files. ** ** Thanks in advance for your kind support. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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
$$Excel-Macros$$ https://www.facebook.com/photo.php?fbid=166626683530877set=a.122721837921362.1073741826.12270861125
https://www.facebook.com/photo.php?fbid=166626683530877set=a.122721837921362.1073741826.122708611256018type=1theater -- 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$$ External Query not brining in all data
I have created an MS Query using our SQL database. One of the fields, which is a varchar(max) field, will not pull over. Any suggestions would be greatly appreciated. Thanks in Advance. Rich -- 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$$ Pie chart
Hi, I have a two slice pie chart and the first slice should face to the right centre horizontally. Can you provide a macro for this. Thanks for your help in advance. Regards, Joseph -- 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$$ Can I add a bespoke menu in Excel 2013?
I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke menu to do most of the work through macros. In 2013 the Menu appears as an Add-in with the subitems expandable beneath it. I woud like to get back to having a bespoke menu but having the individual macros a add-ins would be acceptable. Below is my code for creating the menu and sub-items. Can someone tell me how to change this to achieve my end please? DaveT In Sunny South Yorkshire Sub SetupMenus() 'ADD MENUS to the worksheet menu bar. 'We also need to attach macros to each of the menu options by using the OnAction argument. MenuBars(xlWorksheet).Menus.Add Caption:= ClubName, Before:=9 MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Download, Before:=1, OnAction:=NewDownload MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Month, Before:=1, OnAction:=NewMonth MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Member Extract, Before:=1, OnAction:=MemberExtract MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Share, Before:=1, OnAction:=NewShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Add to Holding, OnAction:=InsertShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=About this Workbook, OnAction:=About ' MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=-, Before:=Print End Sub -- 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$$ Auto copy to MS excel clipboard on click of radio button
Hi Sire, Need your help, I googled a lot for this but couldn't find a solution. Scenario is: I have my data say in cell starting from C3, under header C2. I want to just copy the content of cells having values not blank cells using radio button=COPY. Cahce is: Range is not constant, it varies on input data. So, some times range can be C3:C30 or C3:C200 etc. The idea is to copy the content to clipboard and paste it elsewhere on click of button. Please suggest 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.
RE: $$Excel-Macros$$ Formula: Count
Hi Chandra Sekar , Use the below formula. =ROUNDUP(SUM(1/COUNTIF(B2:B15,B2:B15)*IF(A2:A15=C2,1,0)),0) with ctrl+shift+enter. Regards, Excel Beginner From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Thursday, September 19, 2013 1:24 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula: Count Hello, Thank a lot its working fine. Regards, Chandra On Thu, Sep 19, 2013 at 12:08 PM, Ravinder ravinderexcelgr...@gmail.com wrote: PFA OR USE =SUM((C2=IF(FREQUENCY(MATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0),M ATCH($A$2:$A$15$B$2:$B$15,$A$2:$A$15$B$2:$B$15,0))0,$A$2:$A$15))*1) WITH CSE From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Wednesday, September 18, 2013 4:13 PM To: excel-macros@googlegroups.com Cc: ashish koul Subject: Re: $$Excel-Macros$$ Formula: Count Hello, Thanks for your replies. Formulas are working for one set of data but its not working for other criterias I have attached new excel could you please check it. Ashish - I am trying to get count of unique records based on multi conditions where I know what is Condition1 but I will be not knowing what would be condition2. Thanks, Chandra On Wed, Sep 18, 2013 at 12:30 PM, Ravinder ravinderexcelgr...@gmail.com wrote: =SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,), ),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),)),1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Tuesday, September 17, 2013 6:00 PM To: excel-macros@googlegroups.com Subject: $$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. -- 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. 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
Re: $$Excel-Macros$$ RecordSet ADO get the 20th record
Hi Enrique, I've attempted this Query but I didn't get results. They return this advertence, saying that I need to use the clausule EXISTS. SELECT TOP 1 * FROM MIDASQ12013 WHERE MIDASQ12013.PAIS EXISTS (SELECT TOP 20 MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11, Sum(MIDASQ12013.EUR_2012) AS KEUR12, Sum(MIDASQ12013.EUR_2013) AS KEUR13, Sum(MIDASQ12013.UN_2008) AS KUN08, Sum(MIDASQ12013.UN_2009) AS KUN09, Sum(MIDASQ12013.UN_2010) AS KUN10, Sum(MIDASQ12013.UN_2011) AS KUN11, Sum(MIDASQ12013.UN_2012) AS KUN12, Sum(MIDASQ12013.UN_2013) AS KUN13 FROM MIDASQ12013 GROUP BY MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD HAVING (((MIDASQ12013.PAIS)=BRAZIL RETAIL)) ORDER BY Sum(MIDASQ12013.EUR_2013)) ORDER BY MIDASQ12013.COUNTRY DESC; Thanks, *Michael* Em quinta-feira, 19 de setembro de 2013 00h10min28s UTC-3, Enrique Martin escreveu: I hope the below one works good to you... pls check SELECT TOP 1 * FROM MIDASQ12013 WHERE MIDASQ12013.COUNTRY IN (SELECT TOP 20 MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11, Sum(MIDASQ12013.EUR_2012) AS KEUR12, Sum(MIDASQ12013.EUR_2013) AS KEUR13, Sum(MIDASQ12013.UN_2008) AS KUN08, Sum(MIDASQ12013.UN_2009) AS KUN09, Sum(MIDASQ12013.UN_2010) AS KUN10, Sum(MIDASQ12013.UN_2011) AS KUN11, Sum(MIDASQ12013.UN_2012) AS KUN12, Sum(MIDASQ12013.UN_2013) AS KUN13 FROM MIDASQ12013 GROUP BY MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD HAVING (((MIDASQ12013.PAIS)=brazil retail)) ORDER BY Sum(MIDASQ12013.EUR_2013)) ORDER BY MIDASQ12013.COUNTRY DESC; On Thu, Sep 19, 2013 at 12:12 AM, Michael Pablo skypa...@gmail.comjavascript: wrote: Hello Enrique Martin, I have been attempted this query: SELECT MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11, Sum(MIDASQ12013.EUR_2012) AS KEUR12, Sum(MIDASQ12013.EUR_2013) AS KEUR13, Sum(MIDASQ12013.UN_2008) AS KUN08, Sum(MIDASQ12013.UN_2009) AS KUN09, Sum(MIDASQ12013.UN_2010) AS KUN10, Sum(MIDASQ12013.UN_2011) AS KUN11, Sum(MIDASQ12013.UN_2012) AS KUN12, Sum(MIDASQ12013.UN_2013) AS KUN13 FROM MIDASQ12013 GROUP BY MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD HAVING (((MIDASQ12013.PAIS)=brazil retail)) ORDER BY Sum(MIDASQ12013.EUR_2013) DESC Ok, I am not experienced about ADO or DAO and how to utilize one or other. But in this case ADO can account this query? Because maybe this can be a barrier about execute this query in my VBA code. Thanks and Regards, *Michael* Em segunda-feira, 16 de setembro de 2013 22h44min29s UTC-3, Enrique Martin escreveu: Make a query as Select Top 20 From your table name in case you need a 20th record without changing your records order. but if you want the 20th record after sorting your data in ascending order then make following query Select Top 20 From your table name order by your sort column In case you need the 20th record after sorting data in descending order then use the following one Select Top 20 From your table name order by your sort column DESC In case you want to call any of these queries by ADO then create queryDef object. On Mon, Sep 16, 2013 at 7:33 PM, Michael Pablo skypa...@gmail.comwrote: Hello Everbody! I would like to ask help with this duty, I don't Know how to get the 20th records from a record set. I tried with the While Clausule but I fail. And I don't Know if you can help me about that too because it is more a doubt SQL, where I divide by 1000 the registers but I aways get a Error, I don't Know Why because in access the Query works perfectly. Best Regards, *Michael* -- 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. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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
$$Excel-Macros$$ Re: Pivot Table - Cumlative Totals
Thanks for the link but I do not think this will work for me, do you have any other suggestions? On Thursday, September 19, 2013 9:04:58 PM UTC+1, Brett Manning wrote: Hello, Hope everyone is well. I think I have a really simple question but I am struggling! I am looking for a cumlative total across columns, please see example data below: Basically I want the first column in the Pivot table to be the Opening value then the next column to take the opening and add today's entries to provide a cumlative balance. Excel Data Name TypeOpeningMovement 1 Movement 2 My AccountBalance 100.00 100.00 100.00 Dave's Account Balance200.00 -100.00 100.00 I would like the Pivot table to display the Opening in the first value column in the pivot table as 100.00 for my account and 200.00 for Dave's account. The 2nd Column for Movement 1 should display 200.00 for My Account (Opening + Movement) and Movement 2 should total 300.00 (Opening + Movement 1 + Movement 2 / or a cumlative running total. Please can offer me some advice, I am sure this is really simple I just cannot work it out. Thanks, Brett -- 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: Pivot Table - Cumlative Totals
Hi Brett, Hope this link will solve your problem. http://www.contextures.com/xlPivot14.html#percent On Thursday, 19 September 2013 15:04:58 UTC-5, Brett Manning wrote: Hello, Hope everyone is well. I think I have a really simple question but I am struggling! I am looking for a cumlative total across columns, please see example data below: Basically I want the first column in the Pivot table to be the Opening value then the next column to take the opening and add today's entries to provide a cumlative balance. Excel Data Name TypeOpeningMovement 1 Movement 2 My AccountBalance 100.00 100.00 100.00 Dave's Account Balance200.00 -100.00 100.00 I would like the Pivot table to display the Opening in the first value column in the pivot table as 100.00 for my account and 200.00 for Dave's account. The 2nd Column for Movement 1 should display 200.00 for My Account (Opening + Movement) and Movement 2 should total 300.00 (Opening + Movement 1 + Movement 2 / or a cumlative running total. Please can offer me some advice, I am sure this is really simple I just cannot work it out. Thanks, Brett -- 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$$ Pivot Table - Cumlative Totals
Hello, Hope everyone is well. I think I have a really simple question but I am struggling! I am looking for a cumlative total across columns, please see example data below: Basically I want the first column in the Pivot table to be the Opening value then the next column to take the opening and add today's entries to provide a cumlative balance. Excel Data Name TypeOpeningMovement 1 Movement 2 My AccountBalance 100.00 100.00 100.00 Dave's Account Balance200.00 -100.00 100.00 I would like the Pivot table to display the Opening in the first value column in the pivot table as 100.00 for my account and 200.00 for Dave's account. The 2nd Column for Movement 1 should display 200.00 for My Account (Opening + Movement) and Movement 2 should total 300.00 (Opening + Movement 1 + Movement 2 / or a cumlative running total. Please can offer me some advice, I am sure this is really simple I just cannot work it out. Thanks, Brett -- 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: Can I add a bespoke menu in Excel 2013?
https://lh6.googleusercontent.com/-L9K0zTBg2rE/UjtYTXMt16I/AEI/-7Q6ckNslx8/s1600/Excel+Menu.jpg On Thursday, 19 September 2013 16:08:24 UTC+1, Dave Tomlinson wrote: I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke menu to do most of the work through macros. In 2013 the Menu appears as an Add-in with the subitems expandable beneath it. I woud like to get back to having a bespoke menu but having the individual macros a add-ins would be acceptable. Below is my code for creating the menu and sub-items. Can someone tell me how to change this to achieve my end please? DaveT In Sunny South Yorkshire Sub SetupMenus() 'ADD MENUS to the worksheet menu bar. 'We also need to attach macros to each of the menu options by using the OnAction argument. MenuBars(xlWorksheet).Menus.Add Caption:= ClubName, Before:=9 MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Download, Before:=1, OnAction:=NewDownload MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Month, Before:=1, OnAction:=NewMonth MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Member Extract, Before:=1, OnAction:=MemberExtract MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Share, Before:=1, OnAction:=NewShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Add to Holding, OnAction:=InsertShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=About this Workbook, OnAction:=About ' MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=-, Before:=Print End Sub On Thursday, 19 September 2013 16:08:24 UTC+1, Dave Tomlinson wrote: I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke menu to do most of the work through macros. In 2013 the Menu appears as an Add-in with the subitems expandable beneath it. I woud like to get back to having a bespoke menu but having the individual macros a add-ins would be acceptable. Below is my code for creating the menu and sub-items. Can someone tell me how to change this to achieve my end please? DaveT In Sunny South Yorkshire Sub SetupMenus() 'ADD MENUS to the worksheet menu bar. 'We also need to attach macros to each of the menu options by using the OnAction argument. MenuBars(xlWorksheet).Menus.Add Caption:= ClubName, Before:=9 MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Download, Before:=1, OnAction:=NewDownload MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Month, Before:=1, OnAction:=NewMonth MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Member Extract, Before:=1, OnAction:=MemberExtract MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Share, Before:=1, OnAction:=NewShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Add to Holding, OnAction:=InsertShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=About this Workbook, OnAction:=About ' MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=-, Before:=Print End Sub On Thursday, 19 September 2013 16:08:24 UTC+1, Dave Tomlinson wrote: I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke menu to do most of the work through macros. In 2013 the Menu appears as an Add-in with the subitems expandable beneath it. I woud like to get back to having a bespoke menu but having the individual macros a add-ins would be acceptable. Below is my code for creating the menu and sub-items. Can someone tell me how to change this to achieve my end please? DaveT In Sunny South Yorkshire Sub SetupMenus() 'ADD MENUS to the worksheet menu bar. 'We also need to attach macros to each of the menu options by using the OnAction argument. MenuBars(xlWorksheet).Menus.Add Caption:= ClubName, Before:=9 MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Download, Before:=1, OnAction:=NewDownload MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Month, Before:=1, OnAction:=NewMonth MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Member Extract, Before:=1, OnAction:=MemberExtract MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Share, Before:=1, OnAction:=NewShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Add to Holding, OnAction:=InsertShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=About this Workbook, OnAction:=About ' MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=-, Before:=Print End Sub On Thursday, 19 September 2013 16:08:24 UTC+1, Dave Tomlinson wrote: I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke menu to do most of the work through macros. In 2013 the Menu appears as an Add-in with the subitems expandable beneath it. I woud like to get back to having
Re: $$Excel-Macros$$ Can I add a bespoke menu in Excel 2013?
Hi Dave, Since many of us have switched to Excel 2007 or above, it would be nice if you can attach a picture of this bespoke menu, and then try to relate to what you are expecting in your new version of Excel. Regards, Sam Mathai Chacko On Thu, Sep 19, 2013 at 8:38 PM, Dave Tomlinson dave.t...@gmail.com wrote: I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke menu to do most of the work through macros. In 2013 the Menu appears as an Add-in with the subitems expandable beneath it. I woud like to get back to having a bespoke menu but having the individual macros a add-ins would be acceptable. Below is my code for creating the menu and sub-items. Can someone tell me how to change this to achieve my end please? DaveT In Sunny South Yorkshire Sub SetupMenus() 'ADD MENUS to the worksheet menu bar. 'We also need to attach macros to each of the menu options by using the OnAction argument. MenuBars(xlWorksheet).Menus.Add Caption:= ClubName, Before:=9 MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Download, Before:=1, OnAction:=NewDownload MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Month, Before:=1, OnAction:=NewMonth MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Member Extract, Before:=1, OnAction:=MemberExtract MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=New Share, Before:=1, OnAction:=NewShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=Add to Holding, OnAction:=InsertShare MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=About this Workbook, OnAction:=About ' MenuBars(xlWorksheet).Menus(ClubName).MenuItems.Add Caption:=-, Before:=Print End Sub -- 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. -- Sam Mathai Chacko -- 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: Can I add a bespoke menu in Excel 2013?
Sorry about the multiple pastes. In my original message I should have said In Excel 2013 I get the Dad's Running menu on the add-ins bar. The pull down brings up the sub menu which I have pasted to the right. This is from another of my spreadsheets so the captions and Macro names are different. What I would like is for the sub menu to appear instead of Dad's Running. -- 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$$ Abridged summary of excel-macros@googlegroups.com - 28 Messages in 13 Topics
Gud mornig excel expert, Can I am join this group. On Sep 19, 2013 11:09 PM, excel-macros@googlegroups.com wrote: Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics - Pivot Table - Cumlative Totals #141387c6e1c89611_group_thread_0 [3 Updates] - Can I add a bespoke menu in Excel 2013?#141387c6e1c89611_group_thread_1[4 Updates] - Auto copy to MS excel clipboard on click of radio button#141387c6e1c89611_group_thread_2[1 Update] - Formula: Count #141387c6e1c89611_group_thread_3 [3 Updates] - Pie chart #141387c6e1c89611_group_thread_4 [1 Update] - RecordSet ADO get the 20th record #141387c6e1c89611_group_thread_5[2 Updates] - External Query not brining in all data#141387c6e1c89611_group_thread_6[1 Update] - https://www.facebook.com/photo.php?fbid=166626683530877set=a.122721837921362.1073741826.12270861125#141387c6e1c89611_group_thread_7[1 Update] - Need experts help ***URGENT*** #141387c6e1c89611_group_thread_8 [6 Updates] - Stock prices data fetching through VBA#141387c6e1c89611_group_thread_9[3 Updates] - grouping data of range boundaries...#141387c6e1c89611_group_thread_10[1 Update] - Set range and action according to sheet name#141387c6e1c89611_group_thread_11[1 Update] - File Saving Restriction #141387c6e1c89611_group_thread_12 [1 Update] Pivot Table - Cumlative Totalshttp://groups.google.com/group/excel-macros/t/df37c41c312d9011 Brett Manning brettmannin...@gmail.com Sep 19 01:04PM -0700 Hello, Hope everyone is well. I think I have a really simple question but I am struggling! I am looking for a cumlative total across columns, please see example data below: ...morehttp://groups.google.com/group/excel-macros/msg/6d2427f38437f72c Back to top. #141387c6e1c89611_digest_top Bv Dileep bvdil...@gmail.com Sep 19 01:25PM -0700 Hi Brett, Hope this link will solve your problem. http://www.contextures.com/xlPivot14.html#percent On Thursday, 19 September 2013 15:04:58 UTC-5, Brett Manning wrote: ...morehttp://groups.google.com/group/excel-macros/msg/e1bdf4ab02c5c7e8 Back to top. #141387c6e1c89611_digest_top Brett Manning brettmannin...@gmail.com Sep 19 01:29PM -0700 Thanks for the link but I do not think this will work for me, do you have any other suggestions? On Thursday, September 19, 2013 9:04:58 PM UTC+1, Brett Manning wrote: ...morehttp://groups.google.com/group/excel-macros/msg/dfade55e4c618e98 Back to top. #141387c6e1c89611_digest_top Can I add a bespoke menu in Excel 2013?http://groups.google.com/group/excel-macros/t/39492ebe38e8c021 Dave Tomlinson dave.t...@gmail.com Sep 19 08:08AM -0700 I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke menu to do most of the work through macros. In 2013 the Menu appears as an Add-in with the subitems expandable ...morehttp://groups.google.com/group/excel-macros/msg/67a92a292d1291d2 Back to top. #141387c6e1c89611_digest_top Sam Mathai Chacko samde...@gmail.com Sep 20 12:23AM +0530 Hi Dave, Since many of us have switched to Excel 2007 or above, it would be nice if you can attach a picture of this bespoke menu, and then try to relate to what you are expecting in your new ...morehttp://groups.google.com/group/excel-macros/msg/1114e27772ced009 Back to top. #141387c6e1c89611_digest_top Dave Tomlinson dave.t...@gmail.com Sep 19 01:04PM -0700 https://lh6.googleusercontent.com/-L9K0zTBg2rE/UjtYTXMt16I/AEI/-7Q6ckNslx8/s1600/Excel+Menu.jpg On Thursday, 19 September 2013 16:08:24 UTC+1, Dave Tomlinson wrote: ' ...morehttp://groups.google.com/group/excel-macros/msg/5a70bc0f81d7d005 Back to top. #141387c6e1c89611_digest_top Dave Tomlinson dave.t...@gmail.com Sep 19 01:12PM -0700 Sorry about the multiple pastes. In my original message I should have said In Excel 2013 I get the Dad's Running menu on the add-ins bar. The pull down brings up the sub menu ...morehttp://groups.google.com/group/excel-macros/msg/3bd39b2f7bf77bf7 Back to top. #141387c6e1c89611_digest_top Auto copy to MS excel clipboard on click of radio buttonhttp://groups.google.com/group/excel-macros/t/50bb91b942d7e12b Raajesh rajeshwebsp...@gmail.com Sep 19 12:35PM -0700 Hi Sire, Need your help, I googled a lot for this but couldn't find a solution. Scenario is: I have my data say in cell starting from C3, under header C2. I want to just copy the content of ...morehttp://groups.google.com/group/excel-macros/msg/7d7195399ce7c70a Back to top. #141387c6e1c89611_digest_top Formula: Counthttp://groups.google.com/group/excel-macros/t/1a4ed7cefef5227c Ravinder ravinderexcelgr...@gmail.com Sep 19 12:08PM +0530 PFA OR USE
$$Excel-Macros$$ Re: Stock prices data fetching through VBA
All websites will get Indian companies stock prices data from nseindia.com and bseindia.com. If you want to get stock quotes of indian companies based on stock code you can get that data directly from the above websites sites, instead of depending on third party sites. Regards, Kishan Reddy K On Tuesday, September 17, 2013 12:28:53 PM UTC+5:30, Murali prasad wrote: 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.
Re: $$Excel-Macros$$ RecordSet ADO get the 20th record
can you share your access database? On Thu, Sep 19, 2013 at 10:40 PM, Michael Pablo skypablo...@gmail.comwrote: Hi Enrique, I've attempted this Query but I didn't get results. They return this advertence, saying that I need to use the clausule EXISTS. SELECT TOP 1 * FROM MIDASQ12013 WHERE MIDASQ12013.PAIS EXISTS (SELECT TOP 20 MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11, Sum(MIDASQ12013.EUR_2012) AS KEUR12, Sum(MIDASQ12013.EUR_2013) AS KEUR13, Sum(MIDASQ12013.UN_2008) AS KUN08, Sum(MIDASQ12013.UN_2009) AS KUN09, Sum(MIDASQ12013.UN_2010) AS KUN10, Sum(MIDASQ12013.UN_2011) AS KUN11, Sum(MIDASQ12013.UN_2012) AS KUN12, Sum(MIDASQ12013.UN_2013) AS KUN13 FROM MIDASQ12013 GROUP BY MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD HAVING (((MIDASQ12013.PAIS)=BRAZIL RETAIL)) ORDER BY Sum(MIDASQ12013.EUR_2013)) ORDER BY MIDASQ12013.COUNTRY DESC; Thanks, *Michael* Em quinta-feira, 19 de setembro de 2013 00h10min28s UTC-3, Enrique Martin escreveu: I hope the below one works good to you... pls check SELECT TOP 1 * FROM MIDASQ12013 WHERE MIDASQ12013.COUNTRY IN (SELECT TOP 20 MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11, Sum(MIDASQ12013.EUR_2012) AS KEUR12, Sum(MIDASQ12013.EUR_2013) AS KEUR13, Sum(MIDASQ12013.UN_2008) AS KUN08, Sum(MIDASQ12013.UN_2009) AS KUN09, Sum(MIDASQ12013.UN_2010) AS KUN10, Sum(MIDASQ12013.UN_2011) AS KUN11, Sum(MIDASQ12013.UN_2012) AS KUN12, Sum(MIDASQ12013.UN_2013) AS KUN13 FROM MIDASQ12013 GROUP BY MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD HAVING (((MIDASQ12013.PAIS)=brazil retail)) ORDER BY Sum(MIDASQ12013.EUR_2013)) ORDER BY MIDASQ12013.COUNTRY DESC; On Thu, Sep 19, 2013 at 12:12 AM, Michael Pablo skypa...@gmail.comwrote: Hello Enrique Martin, I have been attempted this query: SELECT MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11, Sum(MIDASQ12013.EUR_2012) AS KEUR12, Sum(MIDASQ12013.EUR_2013) AS KEUR13, Sum(MIDASQ12013.UN_2008) AS KUN08, Sum(MIDASQ12013.UN_2009) AS KUN09, Sum(MIDASQ12013.UN_2010) AS KUN10, Sum(MIDASQ12013.UN_2011) AS KUN11, Sum(MIDASQ12013.UN_2012) AS KUN12, Sum(MIDASQ12013.UN_2013) AS KUN13 FROM MIDASQ12013 GROUP BY MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD HAVING (((MIDASQ12013.PAIS)=brazil retail)) ORDER BY Sum(MIDASQ12013.EUR_2013) DESC Ok, I am not experienced about ADO or DAO and how to utilize one or other. But in this case ADO can account this query? Because maybe this can be a barrier about execute this query in my VBA code. Thanks and Regards, *Michael* Em segunda-feira, 16 de setembro de 2013 22h44min29s UTC-3, Enrique Martin escreveu: Make a query as Select Top 20 From your table name in case you need a 20th record without changing your records order. but if you want the 20th record after sorting your data in ascending order then make following query Select Top 20 From your table name order by your sort column In case you need the 20th record after sorting data in descending order then use the following one Select Top 20 From your table name order by your sort column DESC In case you want to call any of these queries by ADO then create queryDef object. On Mon, Sep 16, 2013 at 7:33 PM, Michael Pablo skypa...@gmail.comwrote: Hello Everbody! I would like to ask help with this duty, I don't Know how to get the 20th records from a record set. I tried with the While Clausule but I fail. And I don't Know if you can help me about that too because it is more a doubt SQL, where I divide by 1000 the registers but I aways get a Error, I don't Know Why because in access the Query works perfectly. Best Regards, *Michael* -- 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/**discu**ssexcelhttps://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
Re: $$Excel-Macros$$ Pivot Table - Cumlative Totals
Please do share your file. On Fri, Sep 20, 2013 at 1:34 AM, Brett Manning brettmannin...@gmail.comwrote: Hello, Hope everyone is well. I think I have a really simple question but I am struggling! I am looking for a cumlative total across columns, please see example data below: Basically I want the first column in the Pivot table to be the Opening value then the next column to take the opening and add today's entries to provide a cumlative balance. Excel Data Name TypeOpeningMovement 1 Movement 2 My AccountBalance 100.00 100.00 100.00 Dave's Account Balance200.00 -100.00 100.00 I would like the Pivot table to display the Opening in the first value column in the pivot table as 100.00 for my account and 200.00 for Dave's account. The 2nd Column for Movement 1 should display 200.00 for My Account (Opening + Movement) and Movement 2 should total 300.00 (Opening + Movement 1 + Movement 2 / or a cumlative running total. Please can offer me some advice, I am sure this is really simple I just cannot work it out. Thanks, Brett -- 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.
Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK
i am not able to do it. will you please send me file after removing password from workbook. On Wednesday, September 18, 2013 12:01:06 PM UTC+5:30, ravinder negi wrote: Try this code… Sub unprotecsheet() Dim wb As Workbook Dim sh As Worksheet Set wb = ThisWorkbook For Each sh In wb.Sheets sh.Unprotect AAABAABABBAR Next End Sub *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Prabhakar S H *Sent:* Wednesday, September 18, 2013 11:46 AM *To:* excel-...@googlegroups.com javascript: *Subject:* $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK Dear Team, Pls help me to unprotect entire excel work book. Also tell me the procedure i want to learn. Rgds, Prabhakar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . 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.
Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK
Dear Vijay, I am not able to do it. plese send me file after releasing password. On Wednesday, September 18, 2013 12:21:19 PM UTC+5:30, vijay wrote: Respected Prabhakar, Install and use the attached add-in to unprotect the workbook. Regards, VIJAYKUMAR On Wed, Sep 18, 2013 at 12:01 PM, Ravinder ravindere...@gmail.comjavascript: wrote: Try this code… ** ** ** ** Sub unprotecsheet() Dim wb As Workbook Dim sh As Worksheet Set wb = ThisWorkbook ** ** For Each sh In wb.Sheets sh.Unprotect AAABAABABBAR ** ** Next ** ** ** ** End Sub ** ** *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Prabhakar S H *Sent:* Wednesday, September 18, 2013 11:46 AM *To:* excel-...@googlegroups.com javascript: *Subject:* $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK ** ** Dear Team, Pls help me to unprotect entire excel work book. Also tell me the procedure i want to learn. Rgds, Prabhakar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- P.VIJAY KUMAR -- 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$$ External Query not brining in all data
Hi Richard, Your query is not clear enough. Varchar is a reserved word for sql. are you using max function for getting maximum value of a column? If possible, please share your file.. Regards, Anoop Sr. Developer On Thu, Sep 19, 2013 at 9:42 PM, Richard richard.m...@gmail.com wrote: I have created an MS Query using our SQL database. One of the fields, which is a varchar(max) field, will not pull over. Any suggestions would be greatly appreciated. Thanks in Advance. Rich -- 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.