$$Excel-Macros$$ Single Pivot from More than one worksheet
Hi, any body help me , for prepare single pivot from more than one worksheet. regrds deepak -- -- 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/discussexcel
$$Excel-Macros$$ Unprotect Sheet in Excel 2007
Dear All, I want any VBA code or some tool to Unprotect Sheet in Excel 2007 I forgot the password.. *Best Regards,* *Venkat* * * * * -- -- 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/discussexcel
Re: $$Excel-Macros$$ solution to put data automtically
Please help me out. Regards, Subhash Yadav On Wed, Jun 22, 2011 at 2:11 PM, Subhash Yadav scy2...@gmail.com wrote: No, this is daily entry sheet for fuel issued to equipments. This will continue for years. Regards, Subhash Yadav On Wed, Jun 22, 2011 at 6:16 AM, ashish koul koul.ash...@gmail.comwrote: @ICWAI Help - subhash has already attached the file. please check the mail trail @subash - is there any fixed range where u will be adding the data if so then you can easily use vlookup or add any new col and start marking new values add with any text then you can use the lookp to get the value On Tue, Jun 21, 2011 at 3:39 PM, ICWAI Help icwai.answ...@gmail.comwrote: HI Ashish , could you please attached the sheet with below formula how it works. Thansk, Rakesh. On Tue, Jun 21, 2011 at 8:35 AM, Subhash Yadav scy2...@gmail.comwrote: Thanks a lot my friend On Wed, Jun 8, 2011 at 10:01 PM, ashish koul koul.ash...@gmail.comwrote: issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0) reading =INDEX(F:F,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0) On Wed, Jun 8, 2011 at 7:03 PM, Subhash Yadav scy2...@gmail.comwrote: Dear friends, I am having one sheet containing data for fuel issue. I want, if i put any asset code previous issue and previous reading should come from the latest present issue and present reading of same asset. In the attached sheet yellow cell date should come in yellow cell and magenta cell data should come in magenta cell. Please help me out. -- Subhash Chand Yadav -- -- 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/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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/discussexcel -- Subhash Chand Yadav -- -- 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/discussexcel -- -- 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/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 @
Re: $$Excel-Macros$$ Solution required for preparing Schedule
Please help me out. On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav scy2...@gmail.com wrote: Dear Experts, Please refer my attached file for which i want solution. My queries are: 1. In the type column - Value is previous type+50. but if the values are 300,550,800,1050,1300,1550 etc this start again from 50. 750 should be 250. 1000, 2000, 3000 should remain same. 2. Which ever cell is blank in the Carried out HMR / KMR the adjacent (earlier) two cell data should come in next months MS-1 Type and Due HMR / KMR against every asset code. Thank in advance to you. -- Subhash Chand Yadav -- -- 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/discussexcel -- Subhash Chand Yadav -- -- 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/discussexcel
Re: $$Excel-Macros$$ Unprotect Sheet in Excel 2007
Dear Venkat., Please find use below VBA code to Unprotect sheet in EXCEL 2007 Procedure : Press alt+F11 Insert-Module then Paste below code Press-F5 to run Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) Chr(j) Chr(k) _ Chr(l) Chr(m) Chr(i1) Chr(i2) Chr(i3) _ Chr(i4) Chr(i5) Chr(i6) Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox One usable password is Chr(i) Chr(j) _ Chr(k) Chr(l) Chr(m) Chr(i1) Chr(i2) _ Chr(i3) Chr(i4) Chr(i5) Chr(i6) Chr(n) ActiveWorkbook.Sheets(1).Select Range(a1).FormulaR1C1 = Chr(i) Chr(j) _ Chr(k) Chr(l) Chr(m) Chr(i1) Chr(i2) _ Chr(i3) Chr(i4) Chr(i5) Chr(i6) Chr(n) Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub -- Thanks regards, Noorain Ansari On Tue, Jun 28, 2011 at 11:07 AM, Venkatesan c venkat1@gmail.comwrote: Dear All, I want any VBA code or some tool to Unprotect Sheet in Excel 2007 I forgot the password.. *Best Regards,* *Venkat* * * * * -- -- 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/discussexcel -- -- 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/discussexcel
$$Excel-Macros$$ !!!Jobs!!!
*For Internal Use of Employer (Please don't delete or modify while replying to this email)* Monster Resume ID: 26603422 Personal Folder ID: 9960481 * *POSITION: MIS Executive (2 Positions) Location: Noida Objective- The executive assistant is responsible for providing MIS support to establish accuracy, continuity, and availability of information Key Responsibilities Creating and maintaining reports in Excel that allows the company to get information on daily business activities. Preparation of monthly Performance Status Reports to Senior Management Collate Analyze and Present company performance details quarterly and half yearly. Provide information to management and meet weekly to ensure consistency in data and information across the company. Creating MIS/ Dashboard report and presenting it to the concern Department. Make company performance reports and analyzing them from company prospect. Design reporting formats to provide accurate information in a clear and concise manner. Day-to-Day Analysis of MIS Reports Essential Skills; Strong MS Excel and MS Office required. Relevant experience will be an added advantage. SALARY: As per Industry Standard. P.S: This is a mass mailer. Kindly ignore the mail if this does not suite your current requirement or profile. If you wish to apply for the position, kindly forward me your updated resume with the following details. Current CTC: Expected CTC: Notice Period: Warm Regards, Abhijeet Shevde I Recruitment Associate I NetChanakya People Solutions I 402, Dheeraj Swapna, Pali Naka, Bandra(W), Mumbai 400050 | INDIA | Ph: +91-22-67151010 | Mob: +91-08898362979 | abhijeet.she...@netchanakya.com| www.netchanakya.com | -- Thanks regards, Noorain Ansari -- -- 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/discussexcel
Re: $$Excel-Macros$$ Unprotect Sheet in Excel 2007
Dear Noorain, Working Thank u So much... *Best Regards,* *Venkat* On Tue, Jun 28, 2011 at 12:33 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Venkat., Please find use below VBA code to Unprotect sheet in EXCEL 2007 Procedure : Press alt+F11 Insert-Module then Paste below code Press-F5 to run Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) Chr(j) Chr(k) _ Chr(l) Chr(m) Chr(i1) Chr(i2) Chr(i3) _ Chr(i4) Chr(i5) Chr(i6) Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox One usable password is Chr(i) Chr(j) _ Chr(k) Chr(l) Chr(m) Chr(i1) Chr(i2) _ Chr(i3) Chr(i4) Chr(i5) Chr(i6) Chr(n) ActiveWorkbook.Sheets(1).Select Range(a1).FormulaR1C1 = Chr(i) Chr(j) _ Chr(k) Chr(l) Chr(m) Chr(i1) Chr(i2) _ Chr(i3) Chr(i4) Chr(i5) Chr(i6) Chr(n) Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub -- Thanks regards, Noorain Ansari On Tue, Jun 28, 2011 at 11:07 AM, Venkatesan c venkat1@gmail.comwrote: Dear All, I want any VBA code or some tool to Unprotect Sheet in Excel 2007 I forgot the password.. *Best Regards,* *Venkat* * * * * -- -- 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/discussexcel -- * * * * * * -- -- 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/discussexcel
Re: $$Excel-Macros$$ Solution required for preparing Schedule
try this. use this UDF for the type columns. Pass the Previous Type value into the function Public Function CalculateType(Rng As Range) If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value = 1050 Or Rng.Value = 1300 Or Rng.Value = 1550 Then CalculateType = 50 ElseIf Rng.Value = 750 Then CalculateType = 250 ElseIf Rng.Value = 1000 Or Rng.Value = 2000 Or Rng.Value = 3000 Then CalculateType = Rng.Value End If End Function On Tue, Jun 28, 2011 at 11:34 AM, Subhash Yadav scy2...@gmail.com wrote: Please help me out. On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav scy2...@gmail.com wrote: Dear Experts, Please refer my attached file for which i want solution. My queries are: 1. In the type column - Value is previous type+50. but if the values are 300,550,800,1050,1300,1550 etc this start again from 50. 750 should be 250. 1000, 2000, 3000 should remain same. 2. Which ever cell is blank in the Carried out HMR / KMR the adjacent (earlier) two cell data should come in next months MS-1 Type and Due HMR / KMR against every asset code. Thank in advance to you. -- Subhash Chand Yadav -- -- 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/discussexcel -- Subhash Chand Yadav -- -- 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/discussexcel -- Regards Vasant skype Id: vasantjob vasant...@gmail.com -- -- 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/discussexcel
Re: $$Excel-Macros$$ Solution required for preparing Schedule
Sorry...correction. use this. Public Function CalculateType(Rng As Range) If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value = 1050 Or Rng.Value = 1300 Or Rng.Value = 1550 Then CalculateType = 50 ElseIf Rng.Value = 750 Then CalculateType = 250 ElseIf Rng.Value = 1000 Or Rng.Value = 2000 Or Rng.Value = 3000 Then CalculateType = Rng.Value Else CalculateType = Rng.Value + 50 End If End Function On Tue, Jun 28, 2011 at 2:01 PM, Vasant vasant...@gmail.com wrote: try this. use this UDF for the type columns. Pass the Previous Type value into the function Public Function CalculateType(Rng As Range) If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value = 1050 Or Rng.Value = 1300 Or Rng.Value = 1550 Then CalculateType = 50 ElseIf Rng.Value = 750 Then CalculateType = 250 ElseIf Rng.Value = 1000 Or Rng.Value = 2000 Or Rng.Value = 3000 Then CalculateType = Rng.Value End If End Function On Tue, Jun 28, 2011 at 11:34 AM, Subhash Yadav scy2...@gmail.com wrote: Please help me out. On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav scy2...@gmail.com wrote: Dear Experts, Please refer my attached file for which i want solution. My queries are: 1. In the type column - Value is previous type+50. but if the values are 300,550,800,1050,1300,1550 etc this start again from 50. 750 should be 250. 1000, 2000, 3000 should remain same. 2. Which ever cell is blank in the Carried out HMR / KMR the adjacent (earlier) two cell data should come in next months MS-1 Type and Due HMR / KMR against every asset code. Thank in advance to you. -- Subhash Chand Yadav -- -- 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/discussexcel -- Subhash Chand Yadav -- -- 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/discussexcel -- Regards Vasant skype Id: vasantjob vasant...@gmail.com -- Regards Vasant skype Id: vasantjob vasant...@gmail.com -- -- 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/discussexcel
$$Excel-Macros$$ Check this site to test your Excel Knowledge
http://www.skills-assessment.net/home/frmindex.aspx Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 -- -- 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/discussexcel
RE: $$Excel-Macros$$ Send email to individual receiptant of Pivot Table data
Try the following macro : Sub Test() Dim rgRange As Range, Dict As Object, dblSum As Double Dim strRecip As String With Sheets(Sheet1) Set Dict = CreateObject(Scripting.Dictionary) Set rgRange = .Range(.[A2], .Cells(.Rows.Count, 1).End(xlUp)) For Each c In rgRange If Not Dict.exists(c.Value) Then Dict.Add c.Value, c.Value End If Next c For Each Item In Dict.items .[H:H].ClearContents .[J:L].ClearContents .[H1] = [A1] .[J1:L1].Value = [A1:C1].Value .[H2] = Item Set rgRange = .Range(.[A1], .Cells(.Rows.Count, 1).End(xlUp)) rgRange.Resize(, 3).AdvancedFilter xlFilterCopy, .[H1:H2], Range(J1:L1) strRecip = .[L2] dblSum = Application.Sum(.[K:K]) .Cells(.Rows.Count, K).End(xlUp).Offset(1) = dblSum .Cells(.Rows.Count, J).End(xlUp).Offset(1) = Total .Range(.[J1], .Cells(.Rows.Count, K).End(xlUp)).Copy Workbooks.Add 1 ActiveSheet.Paste ActiveWorkbook.SaveAs ActiveWorkbook.Path \ Item .xls ActiveWorkbook.SendMail strRecip, Subject Next Item End With End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Rajat Kapoor Envoyé : lundi 27 juin 2011 21:01 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Send email to individual receiptant of Pivot Table data Suppose there are fields like: Name, Commision, Email Id etc in Sheet1 Now Data contained is given below Name CommissionEmail ABC 1000 a...@abc.com DEF500d...@abc.com ABC 700 a...@abc.com ABC800 a...@abc.com DEF500d...@abc.com Now I can used either Pivot Table or AutoSum to get total of ABC DEF. But I want a macro should be created according to which email should be send to ABC and DEF containing there data only along with Subtotal or Total. This is just a example. Record can be easily more than 1000 and it is not possible to send email manually. It should be send automatically to each receiptant . -- -- 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/discussexcel -- -- 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/discussexcel
$$Excel-Macros$$ Question on VBA
Hi all, I have written below syntax but got an error but I can't figure out why worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).range(cells(y,1),cells(y,6)) However, I can do it if I seperate it as follows: worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).activate worksheets(sheet2).range(cells(y,1),cells(y,6)).pastespecial Would you please let us know what's the problem? -- -- 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/discussexcel
Re: $$Excel-Macros$$ Single Pivot from More than one worksheet
Hey Venkat, It was very interesting. Can u pls. let me know whether it works in Office 2007 as i was not able to figure this out. Thanks !! On Tue, Jun 28, 2011 at 11:58 AM, Venkatesan c venkat1.sql@ gmail.comwrote: Hi Deepak, Find attached html file .for your queryYou prepare single pivot from more than one.data *Best Regards,* *Venkat* On Tue, Jun 28, 2011 at 10:21 AM, dpk dpk1...@gmail.com wrote: Hi, any body help me , for prepare single pivot from more than one worksheet. regrds deepak -- -- 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/discussexcel -- ** * ** * -- -- 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/discussexcel -- -- 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/discussexcel
RE: $$Excel-Macros$$ Question on VBA
Hi, worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).range(cells(y,1),cells(y,6)) is one same line so you have to add an underscore mark : worksheets(sheet1).range(cells(x,1):cells(x,6).copy _ worksheets(sheet2).range(cells(y,1),cells(y,6)) Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Ming Envoyé : mardi 28 juin 2011 14:42 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Question on VBA Hi all, I have written below syntax but got an error but I can't figure out why worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).range(cells(y,1),cells(y,6)) However, I can do it if I seperate it as follows: worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).activate worksheets(sheet2).range(cells(y,1),cells(y,6)).pastespecial Would you please let us know what's the problem? -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Macro causing drawing objects to be deleted
The objects are locked. The object lock settings on the problem PC are identical to those on the PCs not experiencing the problem. -- -- 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/discussexcel
$$Excel-Macros$$ Send individual complete details through email to respective client
There is a sheet with name Sheet1 and it contains the following data: A1 contains name, B1 Product, C1 Amount, D1 Email A1B1 C1D1 Name Product Amount Email Raj Shoes 1000 a...@a.com Sun Socks 800b...@b.com Raj Socks 700a...@a.com Sun Ball500b...@b.com Raj Tennis 3000 a...@a.com Now a macro should be created in such a way that email should be send automatically to both Raj Sun with details shown below Raj EMAIL DETAILS Name Product Amount Raj Shoes 1000 Raj Socks 700 Raj Tennis 3000 Total4700 Sun Email Details Name Product Amount Sun Socks 800 Sun Ball500 TOTAl1300 Please keep in mind such a macro would be used to send emails to more than 1000 people. So please provide a error proof fully automatically macro. -- -- 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/discussexcel
Re: $$Excel-Macros$$ Question on VBA
*instead of : you should use , while using cells in range reference* On Tue, Jun 28, 2011 at 6:12 PM, Ming mingtam...@gmail.com wrote: Hi all, I have written below syntax but got an error but I can't figure out why worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).range(cells(y,1),cells(y,6)) However, I can do it if I seperate it as follows: worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).activate worksheets(sheet2).range(cells(y,1),cells(y,6)).pastespecial Would you please let us know what's the problem? -- -- 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/discussexcel -- Rakesh Joshi -- -- 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/discussexcel
$$Excel-Macros$$ Stuck on very simple problem - VBA for Excel
I have a macro which works down through all the cells in a column, parsing the contents of the cell for a particular text string. Here's the general outline: sCellValue = ActiveCell.Value CharCount = sCellValue.Characters.Count Found = 0 For i = 1 To CharCount If the cell contains a date, I get an error on the Characters.Count although the variabls sCellValue is correct. My guess was that the cell with the date wasn't text, so Characters.Count won't work. I tried using the istext function, but cannot figure out the syntax to test it for true or false. I guess I haven't ever used any of the boolean functions in VBA. Any / all suggestions appreciated. Regards, Jon -- -- 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/discussexcel
Re: $$Excel-Macros$$ PDF File
Mmm i have a doubt?is this trustable?if you have important company documents that you have to put in excel format? 2011/6/16 saggi realsa...@gmail.com Yeah this is very useful siten quick tooo -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Unprotect Sheet in Excel 2007
Dear All, Last night I made some changes in our Process MI Report through VBA code. Today as per process requirement I need to change something but I forgot the VBA password. Is there any way to resolve the problem means to disable the password to view the code. * Thanks Regards, Gyana * On Tue, Jun 28, 2011 at 3:38 PM, SANJAY SONI sanjaysoni2...@yahoo.co.inwrote: Dear Venkar, I think the attached file can resolve your problem..It will remove your passward. * Best Regards, * *Sanjay ** * ** *From:* Venkatesan c venkat1@gmail.com *To:* Google excel-macros@googlegroups.com *Sent:* Tuesday, 28 June 2011 11:07 AM *Subject:* $$Excel-Macros$$ Unprotect Sheet in Excel 2007 Dear All, I want any VBA code or some tool to Unprotect Sheet in Excel 2007 I forgot the password.. *Best Regards,* *Venkat* * * * * -- -- 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/discussexcel -- -- 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/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Question on VBA
Thanks Daniel, Sorry I missed this in the post but actually I wrote this in one line in the macro, but it doesn't work. The book tells me I shouldn't need to activate the worksheet by indicating worksheets(XXX) in the code. I believe I should have interpreted sth wrong, would you please point this out. ** I have checked the help in VBA for copy but it doesn't point me to the right direction... as I thought whether copy is function need to activate the sheet to perform, On 6月29日, 上午12時10分, Daniel dcolarde...@free.fr wrote: Hi, worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).range(cells(y,1),cells(y,6)) is one same line so you have to add an underscore mark : worksheets(sheet1).range(cells(x,1):cells(x,6).copy _ worksheets(sheet2).range(cells(y,1),cells(y,6)) Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Ming Envoyé : mardi 28 juin 2011 14:42 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Question on VBA Hi all, I have written below syntax but got an error but I can't figure out why worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).range(cells(y,1),cells(y,6)) However, I can do it if I seperate it as follows: worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).activate worksheets(sheet2).range(cells(y,1),cells(y,6)).pastespecial Would you please let us know what's the problem? -- --- - -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/discussexcel -- -- 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/discussexcel
Re: $$Excel-Macros$$ Question on VBA
Thanks Rakesh, as I would like to get the copy range changed depending on the variable I set in the macro. Actually, the code I wrote is something like below x = worksheetfunction.counta(worksheets(Sheet1).range(a:a)) worksheets(Sheet1).range(cells(3,1),cells(x,1)).copy . . Sorry I am new in VBA so what I wrote may sound silly and I do know it should have tons of better methods, would you please share it to me? On 6月29日, 上午12時03分, Rakesh Joshi rakesh.ri...@gmail.com wrote: *instead of : you should use , while using cells in range reference* On Tue, Jun 28, 2011 at 6:12 PM, Ming mingtam...@gmail.com wrote: Hi all, I have written below syntax but got an error but I can't figure out why worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).range(cells(y,1),cells(y,6)) However, I can do it if I seperate it as follows: worksheets(sheet1).range(cells(x,1):cells(x,6).copy worksheets(sheet2).activate worksheets(sheet2).range(cells(y,1),cells(y,6)).pastespecial Would you please let us know what's the problem? -- --- --- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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/discussexcel -- Rakesh Joshi -- -- 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/discussexcel
$$Excel-Macros$$ Re: Stuck on very simple problem - VBA for Excel
sCellValue = ActiveCell.Text On Jun 29, 1:03 am, Jon Kanas ka...@qadas.com wrote: I have a macro which works down through all the cells in a column, parsing the contents of the cell for a particular text string. Here's the general outline: sCellValue = ActiveCell.Value CharCount = sCellValue.Characters.Count Found = 0 For i = 1 To CharCount If the cell contains a date, I get an error on the Characters.Count although the variabls sCellValue is correct. My guess was that the cell with the date wasn't text, so Characters.Count won't work. I tried using the istext function, but cannot figure out the syntax to test it for true or false. I guess I haven't ever used any of the boolean functions in VBA. Any / all suggestions appreciated. Regards, Jon -- -- 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/discussexcel