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=166626683530877&set=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 > Totals<http://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: > ...more<http://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: > > ...more<http://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: > ...more<http://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 > ...more<http://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 > ...more<http://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/AAAAAAAAAEI/-7Q6ckNslx8/s1600/Excel+Menu.jpg > > > > > On Thursday, 19 September 2013 16:08:24 UTC+1, Dave Tomlinson wrote: > > ' > ...more<http://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 > ...more<http://groups.google.com/group/excel-macros/msg/3bd39b2f7bf77bf7> > > Back to top. <#141387c6e1c89611_digest_top> > > Auto copy to MS excel clipboard on click of radio > button<http://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 > ...more<http://groups.google.com/group/excel-macros/msg/7d7195399ce7c70a> > > Back to top. <#141387c6e1c89611_digest_top> > > Formula: > Count<http://groups.google.com/group/excel-macros/t/1a4ed7cefef5227c> > > "Ravinder" <ravinderexcelgr...@gmail.com> Sep 19 12:08PM +0530 > > 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: > ...more<http://groups.google.com/group/excel-macros/msg/b73fd84c52dc84fe> > > Back to top. <#141387c6e1c89611_digest_top> > > > Chandra Shekar <chandrashekarb....@gmail.com> Sep 19 01:24PM +0530 > > Hello, > > Thank a lot its working fine. > > Regards, > > Chandra > > ...more<http://groups.google.com/group/excel-macros/msg/14290f4cf4ee5db> > > Back to top. <#141387c6e1c89611_digest_top> > > > Excel Beginner <excelbegin...@gmail.com> Sep 20 12:28AM +0530 > > 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, > ...more<http://groups.google.com/group/excel-macros/msg/5e93ae205317ea19> > > Back to top. <#141387c6e1c89611_digest_top> > > Pie chart<http://groups.google.com/group/excel-macros/t/55a5d9de25add033> > > joseph camill <joseph.cam...@gmail.com> Sep 19 11:16PM +0530 > > 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 > ...more<http://groups.google.com/group/excel-macros/msg/fcbfe7d4bd275690> > > Back to top. <#141387c6e1c89611_digest_top> > > RecordSet ADO get the 20th > record<http://groups.google.com/group/excel-macros/t/217ad534ed34ca0e> > > Anoop K Sharma <aks.sharm...@gmail.com> Sep 19 08:40AM +0530 > > 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, > ...more<http://groups.google.com/group/excel-macros/msg/a5c7a818aab9b7a1> > > Back to top. <#141387c6e1c89611_digest_top> > > > Michael Pablo <skypablo...@gmail.com> Sep 19 10:10AM -0700 > > 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 > ...more<http://groups.google.com/group/excel-macros/msg/30a5f3527a3597aa> > > Back to top. <#141387c6e1c89611_digest_top> > > External Query not brining in all > data<http://groups.google.com/group/excel-macros/t/6db0aa4cb8418d2e> > > Richard <richard.m...@gmail.com> Sep 19 09:12AM -0700 > > 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. > ...more<http://groups.google.com/group/excel-macros/msg/9a75669256def8fb> > > Back to top. <#141387c6e1c89611_digest_top> > > > https://www.facebook.com/photo.php?fbid=166626683530877&set=a.122721837921362.1073741826.12270861125<http://groups.google.com/group/excel-macros/t/36285133e9abe581> > > sainath mora <sainath.m...@gmail.com> Sep 19 04:40AM -0700 > > > > https://www.facebook.com/photo.php?fbid=166626683530877&set=a.122721837921362.1073741826.122708611256018&type=1&theater > ...more<http://groups.google.com/group/excel-macros/msg/ae9fca547500c229> > > Back to top. <#141387c6e1c89611_digest_top> > > Need experts help > ***URGENT***<http://groups.google.com/group/excel-macros/t/f5b1d5fcb52392aa> > > "Ravinder" <ravinderexcelgr...@gmail.com> Sep 19 11:46AM +0530 > > Use "On Error Resume Next" on the top or pfa > > > > Note; change path as per ur requirement. > > > > From: excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] > On Behalf Of Indrajit > ...more<http://groups.google.com/group/excel-macros/msg/84ab22d9ad2e3e8d> > > Back to top. <#141387c6e1c89611_digest_top> > > > "अनिल नारायण गवली " <gawlianil8...@gmail.com> Sep 19 11:55AM +0530 > > 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 > ...more<http://groups.google.com/group/excel-macros/msg/a88e6e6480c82191> > > Back to top. <#141387c6e1c89611_digest_top> > > > "अनिल नारायण गवली " <gawlianil8...@gmail.com> Sep 19 12:23PM +0530 > > Dear Indrajit, > > See the attached workbook. > > Warm Regards, > Gawli Anil > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > > On Thu, Sep 19, 2013 at > ...more<http://groups.google.com/group/excel-macros/msg/eef7735bd7cf8134> > > Back to top. <#141387c6e1c89611_digest_top> > > > "Indrajit $nai" <talk2indra...@gmail.com> Sep 19 12:48PM +0530 > > 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 > ...more<http://groups.google.com/group/excel-macros/msg/1eaf252e2c47e1ba> > > Back to top. <#141387c6e1c89611_digest_top> > > > "Ravinder" <ravinderexcelgr...@gmail.com> Sep 19 12:53PM +0530 > > 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 > ...more<http://groups.google.com/group/excel-macros/msg/7450b1c05ab82533> > > Back to top. <#141387c6e1c89611_digest_top> > > > "Indrajit $nai" <talk2indra...@gmail.com> Sep 19 01:54PM +0530 > > 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 > ...more<http://groups.google.com/group/excel-macros/msg/42fe1a84a4685bad> > > Back to top. <#141387c6e1c89611_digest_top> > > Stock prices data fetching through > VBA<http://groups.google.com/group/excel-macros/t/52d1541cd2e98e1f> > > "P.VIJAYKUMAR" <vijay.4...@gmail.com> Sep 19 12:57PM +0530 > > 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 > ...more<http://groups.google.com/group/excel-macros/msg/75f18fc6bbb17ed> > > Back to top. <#141387c6e1c89611_digest_top> > > > "P.VIJAYKUMAR" <vijay.4...@gmail.com> Sep 19 01:22PM +0530 > > 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 > ...more<http://groups.google.com/group/excel-macros/msg/618e14bef8834dda> > > Back to top. <#141387c6e1c89611_digest_top> > > > Murali <oncemore2...@gmail.com> Sep 19 01:27PM +0530 > > Respected vijay, > > Thank you very much for the support, > > i have tried with indian codes only, unfortunately its not working... > > > > > ...more<http://groups.google.com/group/excel-macros/msg/d98b0832a66b7bd6> > > Back to top. <#141387c6e1c89611_digest_top> > > grouping data of range > boundaries...<http://groups.google.com/group/excel-macros/t/351f9a3c9b0889bc> > > Murali prasad <oncemore2...@gmail.com> Sep 19 12:09AM -0700 > > 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.. > ...more<http://groups.google.com/group/excel-macros/msg/53f8ef7e467378ac> > > Back to top. <#141387c6e1c89611_digest_top> > > Set range and action according to sheet > name<http://groups.google.com/group/excel-macros/t/2c03339e3bc52afa> > > "अनिल नारायण गवली " <gawlianil8...@gmail.com> Sep 19 11:29AM +0530 > > Dear Melimob, > > Pl share a workbook with us. > > Warm Regards, > Gawli Anil > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > > ...more<http://groups.google.com/group/excel-macros/msg/628303f960acd554> > > Back to top. <#141387c6e1c89611_digest_top> > > File Saving > Restriction<http://groups.google.com/group/excel-macros/t/b872bd4a39da5e8a> > > pankajinfo <pankaji...@gmail.com> Sep 19 09:14AM +0530 > > Dear All, > > As you all know if a .xlsm or .xlsb file is saved under .xlsx or > non-macro > enabled file extension then in those files macros does not work or > visible. > So i want to make a restriction in > ...more<http://groups.google.com/group/excel-macros/msg/af01409fecc8a5b3> > > Back to top. <#141387c6e1c89611_digest_top> > > -- > 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.
