Sent via BlackBerry by AT&T -----Original Message----- From: excel-macros+nore...@googlegroups.com Sender: excel-macros@googlegroups.com Date: Wed, 06 Oct 2010 23:25:47 To: Digest Recipients<excel-macros+dig...@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 13 Messages in 9 Topics
============================================================================= Today's Topic Summary ============================================================================= Group: excel-macros@googlegroups.com Url: http://groups.google.com/group/excel-macros/topics - write to end of page to foot total [2 Updates] http://groups.google.com/group/excel-macros/t/af1efff8ba9dd99 - Importing data into excel [2 Updates] http://groups.google.com/group/excel-macros/t/982329427c0b7078 - Excel Advance Formula Reference Guide [1 Update] http://groups.google.com/group/excel-macros/t/6c0e401747f6288 - Ayush Jain – Microsoft MVP 2010 [3 Updates] http://groups.google.com/group/excel-macros/t/d30bf270a8fb6de - VBA Passward [1 Update] http://groups.google.com/group/excel-macros/t/d966560d5afd13c2 - Top Poster of the month(Sep10) :- Dilip Pandey and Paul Schreiner [1 Update] http://groups.google.com/group/excel-macros/t/34dc87fbb07b1c3d - pipe (|) delimited text file filtered country wise [1 Update] http://groups.google.com/group/excel-macros/t/ead8278ecc60402d - I need a balancing formula. Help pls. [1 Update] http://groups.google.com/group/excel-macros/t/8b51e8c88984c218 - A help which will be most appreciated. [1 Update] http://groups.google.com/group/excel-macros/t/673ad540f8186754 ============================================================================= Topic: write to end of page to foot total Url: http://groups.google.com/group/excel-macros/t/af1efff8ba9dd99 ============================================================================= ---------- 1 of 2 ---------- From: fill brain <fillbr...@gmail.com> Date: Oct 06 08:04AM -0700 Url: http://groups.google.com/group/excel-macros/msg/adfe57fc7942b26d Hi Genius of Excel , I have a list and that list have more or less 10.000 rows data and 5 columns.. that list headers are, 1- ID 2- Name 3- Surname 4 - Total Dept 5 - Current Month Payment and i have to print that list but i have to add to foot total of page's foot and i have to show up of following page , preceding pages foot total.. How can i do it? ---------- 2 of 2 ---------- From: "P.VIJAYKUMAR" <vijay.4...@gmail.com> Date: Oct 06 10:24PM +0530 Url: http://groups.google.com/group/excel-macros/msg/a49bcd772c0f9c0a Hello, You can link the total of the first page to the following page by keeping = and selecting the previous page total to next page opening balance total. this is Explained by the attached sheet. Regards, VIJAY KUMAR ============================================================================= Topic: Importing data into excel Url: http://groups.google.com/group/excel-macros/t/982329427c0b7078 ============================================================================= ---------- 1 of 2 ---------- From: Deepak Rai <daksh1...@gmail.com> Date: Oct 06 12:12AM +0530 Url: http://groups.google.com/group/excel-macros/msg/aed3d682a7a5dc52 Hi Peter, Sure soon I will send you that consolidation macro. Regards, Deepak Rai -- Regards, Deepak Rai ---------- 2 of 2 ---------- From: Peter Konijn <peter....@gmail.com> Date: Oct 06 05:38PM +0200 Url: http://groups.google.com/group/excel-macros/msg/64031c13b450ca6c Hi Deepak Perhaps you can try it on two trial files I enclosed with this email. Kind regards Peter 2010/10/5 Deepak Rai <daksh1...@gmail.com> ============================================================================= Topic: Excel Advance Formula Reference Guide Url: http://groups.google.com/group/excel-macros/t/6c0e401747f6288 ============================================================================= ---------- 1 of 1 ---------- From: عمر <omar27...@gmail.com> Date: Oct 06 03:54PM +0200 Url: http://groups.google.com/group/excel-macros/msg/9bc4075cff036c2f It makes excel stop working From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Deepak Rai Sent: Tuesday, October 05, 2010 9:07 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Excel Advance Formula Reference Guide Hi All, I would like to share the attached "Excel Advance Formula Reference Guide" with all the group members. This will help all the learners to learn the power of Excel Formulas. Note: Please enable the macro for using this file. Hope this will help you all. Enjoy your learning... :) -- Regards, Deepak Rai -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall <http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts ============================================================================= Topic: Ayush Jain – Microsoft MVP 2010 Url: http://groups.google.com/group/excel-macros/t/d30bf270a8fb6de ============================================================================= ---------- 1 of 3 ---------- From: Dilip Pandey <dilipan...@gmail.com> Date: Oct 06 06:47PM +0530 Url: http://groups.google.com/group/excel-macros/msg/433c41d0300b7d8d Well deserved. . . Heartiest congratulations. Keep up the good show :) My best wishes to you. Best Regards, DILIPandey > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- Sent from my mobile device Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India ---------- 2 of 3 ---------- From: Yogesh Kudva <yogeshku...@gmail.com> Date: Oct 06 06:27AM -0700 Url: http://groups.google.com/group/excel-macros/msg/9d31d6c556e9125c Hi Ayush, Heartiest Congratulations!!!! Regards, Yogesh Kudva ---------- 3 of 3 ---------- From: NOORAIN ANSARI <noorain.ans...@gmail.com> Date: Oct 06 06:39AM -0700 Url: http://groups.google.com/group/excel-macros/msg/1955ba0bebeec684 Dear Ayush, You really deserve for this great achievment. Pls accept my hearty Congratulations. Noorain Ansari -- Thanks & regards, Noorain Ansari ============================================================================= Topic: VBA Passward Url: http://groups.google.com/group/excel-macros/t/d966560d5afd13c2 ============================================================================= ---------- 1 of 1 ---------- From: Jacob <app...@gmail.com> Date: Oct 06 06:19AM -0700 Url: http://groups.google.com/group/excel-macros/msg/3bd8242f9ff82464 Push Alt + F11 to open VBE in VBE go to Tools -> VBA Project Properties -> Click on the Protection tab -> Enter password twice. Click the box "Lock project for viewing" if you don't want someone to see your code. Click ok. Save the workbook and close out. The next you come back in the VBA Project is locked/Password Protected. Jacob ============================================================================= Topic: Top Poster of the month(Sep10) :- Dilip Pandey and Paul Schreiner Url: http://groups.google.com/group/excel-macros/t/34dc87fbb07b1c3d ============================================================================= ---------- 1 of 1 ---------- From: Dilip Pandey <dilipan...@gmail.com> Date: Oct 06 06:39PM +0530 Url: http://groups.google.com/group/excel-macros/msg/814a093b6c30ac99 Hey Ayush, Many Thanks to you n "Group" . . . . :) Warmest Regards, DILIPandey > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- Sent from my mobile device Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India ============================================================================= Topic: pipe (|) delimited text file filtered country wise Url: http://groups.google.com/group/excel-macros/t/ead8278ecc60402d ============================================================================= ---------- 1 of 1 ---------- From: Paul Schreiner <schreiner_p...@att.net> Date: Oct 06 06:07AM -0700 Url: http://groups.google.com/group/excel-macros/msg/d745e6f1f3d08167 You may have to modify the fields of this, but try: Option Explicit Public Const ForReading = 1, ForWriting = 2, ForAppending = 8 Sub Split_File() Dim fso, fIN, fOUT, R, C, RowCnt Dim InFile, Outfile, tStr, tPath Dim strArray Set fso = CreateObject("Scripting.FileSystemObject") tPath = "C:\temp\vba\testing\" InFile = "DataFile.txt" If (fso.fileexists(tPath & InFile)) Then Set fIN = fso.OpenTextFile(tPath & InFile, ForReading) Do While Not fIN.atendofstream tStr = fIN.readline strArray = Split(tStr, "|") Outfile = strArray(10) & ".txt" Set fOUT = fso.OpenTextFile(tPath & Outfile, ForAppending, True) fOUT.WriteLine tStr fOUT.Close Loop fIN.Close Else MsgBox "Does not exist:" & Chr(13) & tPath & InFile End If MsgBox "Finished" End Sub Paul >To: excel-macros@googlegroups.com >Sent: Wed, October 6, 2010 7:34:34 AM >Subject: Re: $$Excel-Macros$$ pipe (|) delimited text file filtered country wise ============================================================================= Topic: I need a balancing formula. Help pls. Url: http://groups.google.com/group/excel-macros/t/8b51e8c88984c218 ============================================================================= ---------- 1 of 1 ---------- From: eDo <edioquin...@gmail.com> Date: Oct 05 02:09PM -0700 Url: http://groups.google.com/group/excel-macros/msg/81ddcfb8722f8691 I need a formula than can balance input data automatically. Ive been working on this for quite sometime but unfortunately I cannot seem to crack the secret. Let say for exampe I have 5 Teams, Team A has 4 members, Team B has 5 members, Team C has 6 members, Team D has 7 members and Team E has 9 members. Now what I need is to add this 5 Teams together and divide it into two groups of teams without dividing the members in each team. so basically I will have the result of Team E grouping with Team C , Team E has 9 members plus Team C has 6 members so that would be a total of 15 members, The other group of teams would be Team A, Team B and Team D adding their members, 4 plus 5 plus 7 would be a total of 16 members. So basically this is were i need to get. A formula that can automaticaly sort out the best possible combination of teams for each group. For anyone that can help me, Thanks! ============================================================================= Topic: A help which will be most appreciated. Url: http://groups.google.com/group/excel-macros/t/673ad540f8186754 ============================================================================= ---------- 1 of 1 ---------- From: hemant shah <hemanthin...@gmail.com> Date: Oct 05 03:40PM -0500 Url: http://groups.google.com/group/excel-macros/msg/6280fc5bf959e158 Hi, Can you please help me on my query. I have mentioned every thing in attached sheet. Regards, Hemant Shah -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
