Re: $$Excel-Macros$$ Need help in function
=TEXT(D5-C5,[MM]) 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ sandeepxxxku...@gmail.com Hi All, I want to calculate difference between two date , but i want result in minute's. please suggest function, Please find attached if u r sending solved reply Please CC sandeepxxxku...@gmail.com -- Thanks Regards: ╚►♥ѕαη∂єєρ♥◄╝ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Need help in function
=TEXT(D5-C5,[MM]) On Tue, Apr 6, 2010 at 10:06 AM, ashish koul koul.ash...@gmail.com wrote: =TEXT(D5-C5,[MM]) 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ sandeepxxxku...@gmail.com Hi All, I want to calculate difference between two date , but i want result in minute's. please suggest function, Please find attached if u r sending solved reply Please CC sandeepxxxku...@gmail.com -- Thanks Regards: ╚►♥ѕαη∂єєρ♥◄╝ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Need help in function
Sandeep, Please check the attached file. I used a custom format of [m]:ss (without quotes). Remove :ss part if you don't want seconds. Is this what you want ? Best, AJ 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ sandeepxxxku...@gmail.com Hi All, I want to calculate difference between two date , but i want result in minute's. please suggest function, Please find attached if u r sending solved reply Please CC sandeepxxxku...@gmail.com -- Thanks Regards: ╚►♥ѕαη∂єєρ♥◄╝ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Book14.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need help in function
Dear sandeep, Please Find Attached File Thanks, Chandrabhan 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ sandeepxxxku...@gmail.com Hi All, I want to calculate difference between two date , but i want result in minute's. please suggest function, Please find attached if u r sending solved reply Please CC sandeepxxxku...@gmail.com -- Thanks Regards: ╚►♥ѕαη∂єєρ♥◄╝ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Copy of Book14.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need help in function
Hi, I have attached your sheet with formula for finding the difference in minutes. I have used the formula CONVERT. If the CONVERT function is not available, install and load the Analysis ToolPak add-in. On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. Example of CONVERT =CONVERT(A2,day,hr) Convert 6 days to hours (144) =CONVERT(A2,hr,mn) Convert 6 hours to minutes (360) =CONVERT(A2,yr, day) Convert 6 years to days (2191.5) The above information is given on help section of Excel. I used the formula like this. =CONVERT((d3-c3),day,mn) As your both dates are written in d3 and c3, it will first calculate the difference and then convert the days into minutes. Hope this is helpful. Regards, Seema On 4/6/10, ╚►♥ѕαη∂єєρ♥◄╝ sandeepxxxku...@gmail.com wrote: Hi All, I want to calculate difference between two date , but i want result in minute's. please suggest function, Please find attached if u r sending solved reply Please CC sandeepxxxku...@gmail.com -- Thanks Regards: ╚►♥ѕαη∂єєρ♥◄╝ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Book14(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Worksheets password break
Thanks alot Shyam, But it has VBA Password ,will you please help me in breaking that password. Regards, Kumara Datta On Mon, Apr 5, 2010 at 6:01 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear Try to use tools-- unprotect workbook tools--unprotect sheets tools--unprotect share workbook Password is abc123 Remember this password while working on that workbook. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 5:47 PM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, I can try,i will let you as soon as possible. Please wait for next post. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 4:55 PM, kumara datta yagneswara hkda...@gmail.com wrote: Hi Frnds, Can any one break this file's password. Thanks Regards, Kumara Datta. On Mon, Apr 5, 2010 at 12:37 AM, Nishant Sharma leonish...@gmail.com wrote: On Sun, Apr 4, 2010 at 2:51 AM, Vishal Parihar vish.pari...@gmail.com wrote: Hi Friends is there any vba code to break excel file which has a password to open Thanks Nishant Today i am going to show you how to crack excel sheets password. Vba code to break password. 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 Tata sky laga dala life will be jiga lala Range(a1).Value = Tata sky laga dala life will be jiga lala Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub I hope i like this one. Regards Vishal Parihar 9910415530 vish.pari...@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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer
$$Excel-Macros$$ Plz Help me urgent
Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Questions.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need help in function
Hi Sandeep, Just try the simple function as follows... on row 3 =(D3 - C3) * 24 * 60 make sure the editing of the result column is standard (i.e. nothing) Let me know... Greetings Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ hi-help required .
Hello Dear, Use the following instruction. Select Range Data Menu Pivot Table And Pivot Chart Report Next(Follow the instruction) or go to link below http://www.cpearson.com/excel/pivots.htm http://www.contextures.com/xlpivot07.html Hope it Will Help Happy to Help :) Shyam On Tue, Apr 6, 2010 at 11:47 AM, Sarvesh sarve...@yahoo.com wrote: hi thanks for your help. what you are doing is right..but i dont knwo pivot table and how did u do it...any tutorial for the same...? regards, *sarvesh lahoti.* --- On *Tue, 6/4/10, rf1234 rf1234 rfhyd1...@gmail.com* wrote: From: rf1234 rf1234 rfhyd1...@gmail.com Subject: Re: $$Excel-Macros$$ hi-help required . To: excel-macros@googlegroups.com Cc: sarve...@yahoo.com Date: Tuesday, 6 April, 2010, 10:52 AM Hello Dear, Attached workbook has a sample for your problem. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 7:35 PM, Sarvesh sarve...@yahoo.comhttp://mc/compose?to=sarve...@yahoo.com wrote: hi firstly r u from hyderabad... just felt so with ur mail id.( i am from hyderabad) i am attaching my actual file. plz go thru it. thanks a ton. regards, *sarvesh lahoti.* --- On *Mon, 5/4/10, rf1234 rf1234 rfhyd1...@gmail.comhttp://mc/compose?to=rfhyd1...@gmail.com * wrote: From: rf1234 rf1234 rfhyd1...@gmail.comhttp://mc/compose?to=rfhyd1...@gmail.com Subject: Re: $$Excel-Macros$$ hi-help required . To: excel-macros@googlegroups.comhttp://mc/compose?to=excel-mac...@googlegroups.com Cc: sarve...@yahoo.com http://mc/compose?to=sarve...@yahoo.com Date: Monday, 5 April, 2010, 5:03 PM Hello Dear, Following attachment have a solution regarding your problem. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh sarve...@yahoo.comhttp://mc/compose?to=sarve...@yahoo.com wrote: hi i have a worksheet where sizes and qty are maintained for each item in this way 460*12 Pet 31 460*12 Pet 265 460*12 Pet 340 460*12 Pet 392 460*12 Pet 523 460*12 Pet 150 470*12 Pet 35 470*12 Pet 212 470*12 Pet 159 480*12 Pet 131 480*12 Pet 7 480*12 Pet 56 480*12 Pet 12 480*12 Pet 91 daily some sizes and qty are added , deleted, modified. i need to know the total requirement of each size eg: 480*12 pet =+131+7+56+12+91 which is 297. same way need for all the sizes. the list is very big. i am not familiar with macros , any other formulae based solution will be helpful. thanks regards, *sarvesh lahoti.* -- Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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.comhttp://mc/compose?to=excel-mac...@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at
Re: $$Excel-Macros$$ Importing Text file
HI, Right Click .txt file and open with excel just try it On Mon, Apr 5, 2010 at 2:37 PM, Mahesh mahender.bi...@gmail.com wrote: Dear All, Need ur advise... I got around 20 text files in a day,which had 13 to 15 columns separated by | this sign. each file contains around 15 lacs or more line items. when i import that text file in excel 2007, it takes the first 10 lacs records; rest does not come. Need ur help to solve this, I want that rest records should move to next sheet of the same workbook -- With Love, Mahesh Bisht -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, We can't Spell S_ccess without U Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ hi-help required .
Here is the solution attached you can do it with the help of sumproduct formula or with Sumif Formula Regards Hemant On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh sarve...@yahoo.com wrote: hi i have a worksheet where sizes and qty are maintained for each item in this way 460*12 Pet 31 460*12 Pet 265 460*12 Pet 340 460*12 Pet 392 460*12 Pet 523 460*12 Pet 150 470*12 Pet 35 470*12 Pet 212 470*12 Pet 159 480*12 Pet 131 480*12 Pet 7 480*12 Pet 56 480*12 Pet 12 480*12 Pet 91 daily some sizes and qty are added , deleted, modified. i need to know the total requirement of each size eg: 480*12 pet =+131+7+56+12+91 which is 297. same way need for all the sizes. the list is very big. i am not familiar with macros , any other formulae based solution will be helpful. thanks regards, *sarvesh lahoti.* -- Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards Hemant Koranne Check out my web site for learning excel http://exceltnt.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Solution.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Plz Help me urgent
Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Questions.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ How can I Add tool tips to each of list items ?
Hello Folks, Can someone help me in adding tooltips for each listbox items selected. I'm using Excel 2007 and using list box from Active x control. Thanks in Advance, Regards, Anantha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?
Hello Dear, Attached workbook have the solution for your proble. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 1:26 PM, Anantha anant...@gmail.com wrote: Hello Folks, Can someone help me in adding tooltips for each listbox items selected. I'm using Excel 2007 and using list box from Active x control. Thanks in Advance, Regards, Anantha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Tool Tip Text For List Box.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Plz Help me urgent
check it if this helps u On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Questions(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Plz Help me urgent
Dear Anil, Please see the attached file. I've used an array formula. Press Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined the range names. Let me know if you need any further help on this. Dilip's friend... :) Abhishek On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Questions.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Plz Help me urgent
Thanks to Lot Abhishek Ji about help me thanks On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain abhishek@gmail.comwrote: Dear Anil, Please see the attached file. I've used an array formula. Press Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined the range names. Let me know if you need any further help on this. Dilip's friend... :) Abhishek On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Plz Help me urgent
Dear Mr. Saxena, Please find Attached file. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Copy of Questions-1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Plz Help me urgent
You're welcome Anil. On Tue, Apr 6, 2010 at 2:09 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Thanks to Lot Abhishek Ji about help me thanks On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain abhishek@gmail.comwrote: Dear Anil, Please see the attached file. I've used an array formula. Press Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined the range names. Let me know if you need any further help on this. Dilip's friend... :) Abhishek On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?
Dear Sir May i know how can we use that excel tool tip file. sry i m new to excel but like this group much its help me a lot pls tell me the way how can we use that as i m clicking on that there is some id type is there and nothing else please suggest me Regards LKmodi On 4/6/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, Attached workbook have the solution for your proble. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 1:26 PM, Anantha anant...@gmail.com wrote: Hello Folks, Can someone help me in adding tooltips for each listbox items selected. I'm using Excel 2007 and using list box from Active x control. Thanks in Advance, Regards, Anantha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Plz Help me urgent
Dear Anil Saxena Find attached solution to your problem. Hope this suffies Regards Sivakumar ES On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards Sivakumar ES +91 99250 12482 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. excel solved match and index.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?
Dear Sir May i know how can we use that excel tool tip file. sry i m new to excel but like this group much its help me a lot pls tell me the way how can we use that as i m clicking on that there is some id type is there and nothing else please suggest me Regards On 4/6/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, Attached workbook have the solution for your proble. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 1:26 PM, Anantha anant...@gmail.com wrote: Hello Folks, Can someone help me in adding tooltips for each listbox items selected. I'm using Excel 2007 and using list box from Active x control. Thanks in Advance, Regards, Anantha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ list of file name from explorer to excel
Dear All, I am looking for a solution which can provide me the list of file names from a folder which has sub folders on a server (not on my desktop) in excel Few pointers : - I am using excel 2007 - the server is a restricted server and can be accessed only if permission is provided I did google it and there is a solution with the help of VBA , but to my despair since i am not an expert on VBA cannot play around with the script . Sub AllFilenames() Rem Change D: Y = D: Cells(1, 1) = Filenames r = 2 f = Dir(D, 7) Do While f Cells(r, 1) = f r = r + 1 f = Dir Loop End Sub If some one can help I will be more then grateful. Regards, Vishal Chaturvedi Mo# +971504532896 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Plz Help me urgent
Thanks Lot Chandrabhan Singh Ji On Tue, Apr 6, 2010 at 2:24 PM, Born to Win cs4...@gmail.com wrote: Dear Mr. Saxena, Please find Attached file. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?
Hello Dear, I am using excel 2003. Ok,So generally we can add text on our controlls which can be highlighted after any event triggers..i.e MouseOver MouseClick ETC. If you want to create your sample 1.use the stem. Tools--Macro--Visual Basic Editor--Insert--UserForm--Addcontrols(TOOLS) ListBox1--Property--ControlsTipText---Text What U want To write After ListBox1 Activate Run form. Hope it Will Help Happy to Help :) Shyam On Tue, Apr 6, 2010 at 3:28 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear Sir May i know how can we use that excel tool tip file. sry i m new to excel but like this group much its help me a lot pls tell me the way how can we use that as i m clicking on that there is some id type is there and nothing else please suggest me Regards On 4/6/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, Attached workbook have the solution for your proble. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 1:26 PM, Anantha anant...@gmail.com wrote: Hello Folks, Can someone help me in adding tooltips for each listbox items selected. I'm using Excel 2007 and using list box from Active x control. Thanks in Advance, Regards, Anantha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer
Re: $$Excel-Macros$$ list of file name from explorer to excel
Hello Dear, I do not know. that is there any way,to bypass network security and access that folder,but if u can save that folder in your pc,then i can provide u the macro, which will display or list file in particular folder. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 4:03 PM, chaturvedi vishal vishalbunty2...@yahoo.com wrote: Dear All, I am looking for a solution which can provide me the list of file names from a folder which has sub folders on a server (not on my desktop) in excel Few pointers : - I am using excel 2007 - the server is a restricted server and can be accessed only if permission is provided I did google it and there is a solution with the help of VBA , but to my despair since i am not an expert on VBA cannot play around with the script . Sub AllFilenames() Rem Change D: Y = D: Cells(1, 1) = Filenames r = 2 f = Dir(D, 7) Do While f Cells(r, 1) = f r = r + 1 f = Dir Loop End Sub If some one can help I will be more then grateful. Regards, Vishal Chaturvedi Mo# +971504532896 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ VBA VLookup dates
Dave, Apologies for the late response. Very much appreciate the effort you have put into this - it works perfectly! Thanks again! Andy. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Need help in function
Hi, Ashish Koul is right. His formula is working prefectly fine. Superb Ashish. Cheers Gaurav Jain On Tue, Apr 6, 2010 at 10:44 AM, seema mba seema.mba2...@gmail.com wrote: Hi, I have attached your sheet with formula for finding the difference in minutes. I have used the formula CONVERT. If the CONVERT function is not available, install and load the Analysis ToolPak add-in. On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. Example of CONVERT =CONVERT(A2,day,hr) Convert 6 days to hours (144) =CONVERT(A2,hr,mn) Convert 6 hours to minutes (360) =CONVERT(A2,yr, day) Convert 6 years to days (2191.5) The above information is given on help section of Excel. I used the formula like this. =CONVERT((d3-c3),day,mn) As your both dates are written in d3 and c3, it will first calculate the difference and then convert the days into minutes. Hope this is helpful. Regards, Seema On 4/6/10, ╚►♥ѕαη∂єєρ♥◄╝ sandeepxxxku...@gmail.com wrote: Hi All, I want to calculate difference between two date , but i want result in minute's. please suggest function, Please find attached if u r sending solved reply Please CC sandeepxxxku...@gmail.com -- Thanks Regards: ╚►♥ѕαη∂єєρ♥◄╝ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Plz Help me urgent
your welcome. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Thanks Lot Chandrabhan Singh Ji On Tue, Apr 6, 2010 at 2:24 PM, Born to Win cs4...@gmail.com wrote: Dear Mr. Saxena, Please find Attached file. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ list of file name from explorer to excel
Hi Shyam, I can save the folders in my desktop for sure as I do have an access .. Please advice the solution .. I am greatful to you for giving me light in the tunnel Further , do advice me where i have to change the path names in the Macro or the solution. Regards, Vishal Chaturvedi Mo# +971504532896 From: rf1234 rf1234 rfhyd1...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, April 6, 2010 2:52:37 PM Subject: Re: $$Excel-Macros$$ list of file name from explorer to excel Hello Dear, I do not know. that is there any way,to bypass network security and access that folder,but if u can save that folder in your pc,then i can provide u the macro, which will display or list file in particular folder. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 4:03 PM, chaturvedi vishal vishalbunty2...@yahoo.com wrote: Dear All, I am looking for a solution which can provide me the list of file names from a folder which has sub folders on a server (not on my desktop) in excel Few pointers : - I am using excel 2007 - the server is a restricted server and can be accessed only if permission is provided I did google it and there is a solution with the help of VBA , but to my despair since i am not an expert on VBA cannot play around with the script . Sub AllFilenames() Rem Change D: Y = D: Cells(1, 1) = Filenames r = 2 f = Dir(D, 7) Do While f Cells(r, 1) = f r = r + 1 f = Dir Loop End Sub If some one can help I will be more then grateful. Regards, Vishal Chaturvedi Mo# +971504532896 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to
Re: $$Excel-Macros$$ Group Data
Thanks AJ I was able to solve the problem. Thanks again!! On Mar 26, 12:18 am, Abhishek Jain abhishek@gmail.com wrote: Hi, A sample file of your query would help to understand better, please attach if possible. However, you may try subtotal. DataSubtotal. Cheers! AJ On Thu, Mar 25, 2010 at 11:21 PM, Dave davidstev...@gmail.com wrote: Hi, I have a spreadsheet with the following columns: Item # 1 to 1000 Account Number alphanumeric 20 characters long Amount 1 Amount 2 Period 1 Period 2 Data is currently sorted by Amount 2 ( largest to smallest). There are multiple entries for the same account number What I want to do is now group the data so that All the same account numbers are grouped together along with all other fields but in this grouping I want the amounts to keep the current sort largest to smallest ( largest to smallest).If an account as three numbers I want them on the sheet in consecutive lines Thanks for all your help, -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ hi-help required .
thanks ..thanks a lot. one little doubt...if i delete or add a qty in the list...then pivot table is not updated immediately ? i need it to be updated regards,sarvesh lahoti. --- On Tue, 6/4/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: From: rf1234 rf1234 rfhyd1...@gmail.com Subject: Re: $$Excel-Macros$$ hi-help required . To: excel-macros@googlegroups.com Cc: sarve...@yahoo.com Date: Tuesday, 6 April, 2010, 10:52 AM Hello Dear, Attached workbook has a sample for your problem. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 7:35 PM, Sarvesh sarve...@yahoo.com wrote: hi firstly r u from hyderabad... just felt so with ur mail id.( i am from hyderabad) i am attaching my actual file. plz go thru it. thanks a ton. regards, sarvesh lahoti. --- On Mon, 5/4/10, rf1234 rf1234 rfhyd1...@gmail.com wrote: From: rf1234 rf1234 rfhyd1...@gmail.com Subject: Re: $$Excel-Macros$$ hi-help required . To: excel-macros@googlegroups.com Cc: sarve...@yahoo.com Date: Monday, 5 April, 2010, 5:03 PM Hello Dear, Following attachment have a solution regarding your problem. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh sarve...@yahoo.com wrote: hi i have a worksheet where sizes and qty are maintained for each item in this way 460*12 Pet 31 460*12 Pet 265 460*12 Pet 340 460*12 Pet 392 460*12 Pet 523 460*12 Pet 150 470*12 Pet 35 470*12 Pet 212 470*12 Pet 159 480*12 Pet 131 480*12 Pet 7 480*12 Pet 56 480*12 Pet 12 480*12 Pet 91 daily some sizes and qty are added , deleted, modified. i need to know the total requirement of each size eg: 480*12 pet =+131+7+56+12+91 which is 297. same way need for all the sizes. the list is very big. i am not familiar with macros , any other formulae based solution will be helpful. thanks regards, sarvesh lahoti. Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens;
Re: $$Excel-Macros$$ list of file name from explorer to excel
Hi Shyam, I created a folder on C ; on D; and copied the file to the folder from the server when I run the Macro , I get an error as below : Run time error 445 Object doesn't support this action Regards, Vishal Chaturvedi Mo# +971504532896 From: rf1234 rf1234 rfhyd1...@gmail.com To: excel-macros@googlegroups.com Cc: vishalbunty2...@yahoo.com Sent: Tue, April 6, 2010 4:59:14 PM Subject: Re: $$Excel-Macros$$ list of file name from explorer to excel Hello Dear, It is great that you can save that folder on your PC. Now check it out the macro attached.You have to only give the path and file type. path:path of your folder type:*.xlsFor excel Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 5:54 PM, chaturvedi vishal vishalbunty2...@yahoo.com wrote: Hi Shyam, I can save the folders in my desktop for sure as I do have an access .. Please advice the solution .. I am greatful to you for giving me light in the tunnel Further , do advice me where i have to change the path names in the Macro or the solution. Regards, Vishal Chaturvedi Mo# +971504532896 From: rf1234 rf1234 rfhyd1...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, April 6, 2010 2:52:37 PM Subject: Re: $$Excel-Macros$$ list of file name from explorer to excel Hello Dear, I do not know. that is there any way,to bypass network security and access that folder,but if u can save that folder in your pc,then i can provide u the macro, which will display or list file in particular folder. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 4:03 PM, chaturvedi vishal vishalbunty2...@yahoo.com wrote: Dear All, I am looking for a solution which can provide me the list of file names from a folder which has sub folders on a server (not on my desktop) in excel Few pointers : - I am using excel 2007 - the server is a restricted server and can be accessed only if permission is provided I did google it and there is a solution with the help of VBA , but to my despair since i am not an expert on VBA cannot play around with the script . Sub AllFilenames() Rem Change D: Y = D: Cells(1, 1) = Filenames r = 2 f = Dir(D, 7) Do While f Cells(r, 1) = f r = r + 1 f = Dir Loop End Sub If some one can help I will be more then grateful. Regards, Vishal Chaturvedi Mo# +971504532896 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they
$$Excel-Macros$$ Urgent Help
*Hi friends* ** *Please help me urgent* *problem of Hlookup formula in attached file. * -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Help.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Modifying input data
Thanks Seema and Paul, for posting your reply to my problem. I am aware of the fuctionality to import data from text files. Seema: the file you have attached is the exact point from where i have my problem, i need to modify the input data from here. If you see at Column A: you will find the following: Row 1: states the column headings Row3: i.e. Open Ended Schemes(Balanced) [This is one type of data in the file] Row5, 10,17: are the Scheme Names [or companies that have Row3 kind of schemes] Row78: are two sub schemes available under the company [Baroda Pioneer Mutual Fund] Now, the problem i am facing is as follows: I need, Company Name, Scheme Type, in front of every Sub Schemes, so that my data becomes adequate to apply Autofilter on. Please help, or advise on how to approach this problem Thanks Harry On Apr 5, 10:09 pm, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Hapreet, I agree with Seema: import with delimiter semicolon and the first sheet RAW DATA becomes easier. If it is still very cumbersome for you to convert this Seema-Raw Data to the Modified data sheet, tell me and I'll make it in the blink of an eye... Kind regards, Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Urgent Help
Done, see attach On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar bluecore...@gmail.com wrote: *Hi friends* ** *Please help me urgent* *problem of Hlookup formula in attached file. * -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks, Madhu Nair -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Help(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA
Okay Am looking for codes to forward emails which am receiving in my OUTLOOK 2007 to my second mail/Account and if some emails contain attachment, then all email with attachment file =3MB will be excluded automatically. I hope you understood Thanks for helping Jenie.. On Tue, Apr 6, 2010 at 8:28 AM, rf1234 rf1234 rfhyd1...@gmail.com wrote: Hello Dear, I appriciate your prompt reply,it may be a missunderstanding,but please let me know if any one has a outlook express in his or her PC,Then what is need to write a macro for outlook(To Send The Mail) . It is useful when we are accessing outlook from another application. Your suggestion are welcome,so that i can improve my prompt reply. Hope it Will Help Happy to Help :) Shyam On Tue, Apr 6, 2010 at 1:48 AM, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Shyam, I mean the following: I understand what Janet wrote in a different way than you. I had the impression that you assume that Janet wants something from Excel, but I think he/she wants VBA macros for Outlook (not for Excel)... regards Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ HELP: Appending multiple sheet into one
Hello Team I have more than 52 workbooks each contain 3 sheets but only one sheet sheet1 contain data. all sheets containing data have the same column names in the 1st row, i want to append all sheets into one excel sheet. Please send me some codes to accomplish the task. Thanks in advance Jenie.. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ HELP: Appending multiple sheet into one
are the workbook names listed somewhere? or are they all in one folder? Paul From: janet dickson janetdicks...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, April 6, 2010 1:18:13 PM Subject: $$Excel-Macros$$ HELP: Appending multiple sheet into one Hello Team I have more than 52 workbooks each contain 3 sheets but only one sheet sheet1 contain data. all sheets containing data have the same column names in the 1st row, i want to append all sheets into one excel sheet. Please send me some codes to accomplish the task. Thanks in advance Jenie.. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
$$Excel-Macros$$ Re: Any Excel file for Payroll
I have designed Excel base Payroll program but it is for India Please download from www.jiguparmar.com and see whether It may helful to You. On Apr 6, 5:22 pm, Vasi S D vas...@gmail.com wrote: Hi, I am looking for a format in Excel for Payroll Overtime compatiable to UAE With Summary reports. Thanks I'm not the BEST but I'm not like the REST ! ! ! Shabbir Dawoodi Vasi Prosperity Consultant vas...@gmail.com faint_grain.jpg 1KViewDownload image001122.gif 32KViewDownload image0011133.gif 12KViewDownload image002244.gif 37KViewDownload IMSTP9.gif 61KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
$$Excel-Macros$$ Re: Modifying input data
Hi Harpreet, Here it comes... I made a new sheet test to test it, but you can change that statement in cCooked = MODIFIED DATA after testing, of course. Feedback is welcome. Kind regards, Paul Willekens '=== Sub CookData() Dim cContent Dim cCooked Dim cHouse Dim cName Dim cRaw Dim cType Dim dDate Dim nEmpty Dim nRepurchase Dim nRowRaw Dim nRowCooked Dim nNetValue Dim nSales cRaw = RAW DATA nRowRaw = 3 cCooked = test nRowCooked = 2 Sheets(cRaw).Select While nEmpty 3 cContent = Trim(Cells(nRowRaw, 1).Value) If Len(cContent) 0 Then 'not an empty line nEmpty = 0 If IsNumeric(cContent) Then 'scheme ID 'Scheme Name cName = Cells(nRowRaw, 2) 'Net Asset Value nNetValue = Cells(nRowRaw, 3) 'Repurchase Price nRepurchase = Cells(nRowRaw, 4) 'Sale Price nSales = Cells(nRowRaw, 5) 'Date dDate = Cells(nRowRaw, 6) Sheets(cCooked).Select Cells(nRowCooked, 1).Value = cHouse Cells(nRowCooked, 2).Value = cType Cells(nRowCooked, 3).Value = cContent Cells(nRowCooked, 4).Value = cName Cells(nRowCooked, 5).Value = nNetValue Cells(nRowCooked, 6).Value = nRepurchase Cells(nRowCooked, 7).Value = nSales Cells(nRowCooked, 8).Value = dDate nRowCooked = nRowCooked + 1 Sheets(cRaw).Select Else 'either a new Mutual Fund House or a new Type If Right(cContent, 1) = ) Then 'new Type cType = cContent cHouse = Else 'new Mutual Fund House cHouse = cContent End If End If Else nEmpty = nEmpty + 1 End If nRowRaw = nRowRaw + 1 Wend End Sub '=== -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Need help in function
Hi Gaurav, Did you try my solution? =(D3 - C3) * 24 * 60 What's wrong about that? The result remains numeric, while Ashish's solution becomes text! cu Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Plz Help me urgent
Good one guyz nice to see such creative formulas, here is my share of knowledge. Kindly check out the index match function without adding additional column. Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Tue, Apr 6, 2010 at 4:59 PM, Born to Win cs4...@gmail.com wrote: your welcome. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Thanks Lot Chandrabhan Singh Ji On Tue, Apr 6, 2010 at 2:24 PM, Born to Win cs4...@gmail.com wrote: Dear Mr. Saxena, Please find Attached file. Thanks, Chandrabhan Singh 9911255330 On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena anilsaxena170...@gmail.comwrote: Hi Dilip plz do the needful it is urgent I want the same ans match with ID and Questions ? Plz Sir show the Formula also Regards Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Harmeet_index match with transpose.xls Description: MS-Excel spreadsheet
RE: $$Excel-Macros$$ VBA VLookup dates
You're welcome. Glad to help. Dave. Date: Tue, 6 Apr 2010 03:47:24 -0700 Subject: Re: $$Excel-Macros$$ VBA VLookup dates From: andyr...@hotmail.co.uk To: excel-macros@googlegroups.com Dave, Apologies for the late response. Very much appreciate the effort you have put into this - it works perfectly! Thanks again! Andy. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. _ Browse profiles for FREE! Meet local singles online. http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Request Help to make code more efficient.
Hi Jason, One way of speeding this up is to use: Application.ScreenUpdating=False at the beginning of your code. (And don't forget the Application.ScreenUpdating=True at the end.) But I'm sure we could speed it up in other ways as well. Any chance of attaching the file, or a sample file? Regards - Dave. Date: Tue, 6 Apr 2010 08:18:05 -0700 Subject: $$Excel-Macros$$ Request Help to make code more efficient. From: jsin...@gmail.com To: excel-macros@googlegroups.com Hello all fellow fellow Macro friends :) I have a short bit of code that I was wondering if it's possible to make it run more efficiently. When it runs currently it takes up to 1 minute which seems like a long time. Notes: This is designed to remove an entire row if the condition is met. There is no *real* set limit on the number of potential rows, but in reality it shouldn't exceed 1,500 rows on a bad day. There is more code that runs after this but it's basic formatting stuff that dos not have a loop function in it. Regards, Jason Dim rng As Range Dim what As String Dim what1 As String Dim what2 As String Dim what3 As String Dim what4 As String Dim what5 As String Dim what6 As String Dim what7 As String Dim what8 As String what = FD what1 = EX what2 = NA what3 = NB what4 = NC what5 = HN what6 = CLD what7 = Location what8 = of Do Set rng = ActiveSheet.UsedRange.Find(what) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what1) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what2) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what3) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what4) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what5) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what6) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what7) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what8) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. _ View photos of singles in your area! Looking for a hot date? http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Excel, go through Column B
All: I have the following sub that will go down Column B and stop if there is no more value presented. However, it only works on currently active sheet. How do I modify it so that I can specify a specific work sheet named furniture? Sub GoColumnB() Dim rngClnB As Range, Cell As Range Set rngClnB = Intersect(Range(B:B), ActiveSheet.UsedRange) For Each Cell In rngClnB 'Create Arguments here. Next Cell On Error Resume Next MsgBox Done! End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
$$Excel-Macros$$ Does anybody have games
Hi All, Does anybody have games in excel sheet, if so please send me. Thanks, Naniram -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Request Help to make code more efficient.
HI, Try out the following: Sub trial() Dim rng As Range Dim what(9) As String what(1) = FD what(2) = EX what(3) = NA what(4) = NB what(5) = NC what(6) = HN what(7) = CLD what(8) = Location what(9) = of For i = 1 To 9 Do Set rng = ActiveSheet.UsedRange.Find(what(i)) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Next i End Sub On 4/6/10, JsinSk jsin...@gmail.com wrote: Hello all fellow fellow Macro friends :) I have a short bit of code that I was wondering if it's possible to make it run more efficiently. When it runs currently it takes up to 1 minute which seems like a long time. Notes: This is designed to remove an entire row if the condition is met. There is no *real* set limit on the number of potential rows, but in reality it shouldn't exceed 1,500 rows on a bad day. There is more code that runs after this but it's basic formatting stuff that dos not have a loop function in it. Regards, Jason Dim rng As Range Dim what As String Dim what1 As String Dim what2 As String Dim what3 As String Dim what4 As String Dim what5 As String Dim what6 As String Dim what7 As String Dim what8 As String what = FD what1 = EX what2 = NA what3 = NB what4 = NC what5 = HN what6 = CLD what7 = Location what8 = of Do Set rng = ActiveSheet.UsedRange.Find(what) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what1) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what2) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what3) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what4) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what5) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what6) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what7) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop Do Set rng = ActiveSheet.UsedRange.Find(what8) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Need Help to find a date and time calculation
Hi All., Need your help with the following macro.. there are Four date and time columns in the attached spreadsheet. Date A1, Date A2, Date B1 and Date B2. The macro I'm looking for should color the entire row if the date and time range of B1 to B2 falls within (or same as) the date and time range of A1 to A2. failing which it should color the row red. Can you guys help me out on this please.. also can you share the code you are using to get this sorted please.. Many Thanks., kishore M I -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. Date Range Diff color.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Modifying input data
Paul, This is simply amasing...Thanks a ton Cheers!!! Harry On Apr 6, 10:54 pm, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Harpreet, Here it comes... I made a new sheet test to test it, but you can change that statement in cCooked = MODIFIED DATA after testing, of course. Feedback is welcome. Kind regards, Paul Willekens '=== Sub CookData() Dim cContent Dim cCooked Dim cHouse Dim cName Dim cRaw Dim cType Dim dDate Dim nEmpty Dim nRepurchase Dim nRowRaw Dim nRowCooked Dim nNetValue Dim nSales cRaw = RAW DATA nRowRaw = 3 cCooked = test nRowCooked = 2 Sheets(cRaw).Select While nEmpty 3 cContent = Trim(Cells(nRowRaw, 1).Value) If Len(cContent) 0 Then 'not an empty line nEmpty = 0 If IsNumeric(cContent) Then 'scheme ID 'Scheme Name cName = Cells(nRowRaw, 2) 'Net Asset Value nNetValue = Cells(nRowRaw, 3) 'Repurchase Price nRepurchase = Cells(nRowRaw, 4) 'Sale Price nSales = Cells(nRowRaw, 5) 'Date dDate = Cells(nRowRaw, 6) Sheets(cCooked).Select Cells(nRowCooked, 1).Value = cHouse Cells(nRowCooked, 2).Value = cType Cells(nRowCooked, 3).Value = cContent Cells(nRowCooked, 4).Value = cName Cells(nRowCooked, 5).Value = nNetValue Cells(nRowCooked, 6).Value = nRepurchase Cells(nRowCooked, 7).Value = nSales Cells(nRowCooked, 8).Value = dDate nRowCooked = nRowCooked + 1 Sheets(cRaw).Select Else 'either a new Mutual Fund House or a new Type If Right(cContent, 1) = ) Then 'new Type cType = cContent cHouse = Else 'new Mutual Fund House cHouse = cContent End If End If Else nEmpty = nEmpty + 1 End If nRowRaw = nRowRaw + 1 Wend End Sub '=== -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
Re: $$Excel-Macros$$ Need help in function
hi yes to avoid making it text u an got right click on cell - format - cutom format - [mm] On Tue, Apr 6, 2010 at 11:36 PM, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Gaurav, Did you try my solution? =(D3 - C3) * 24 * 60 What's wrong about that? The result remains numeric, while Ashish's solution becomes text! cu Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need help in function
Paul your solution is working fine thanks, i always get to learn something new from this group Thanks to all On Wed, Apr 7, 2010 at 9:07 AM, ashish koul koul.ash...@gmail.com wrote: hi yes to avoid making it text u an got right click on cell - format - cutom format - [mm] On Tue, Apr 6, 2010 at 11:36 PM, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Gaurav, Did you try my solution? =(D3 - C3) * 24 * 60 What's wrong about that? The result remains numeric, while Ashish's solution becomes text! cu Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Does anybody have games
Try these links http://www.excelgames.org/ http://www.automateexcel.com/2005/01/13/52_excel_games/ Regards, Andy On Wed, Apr 7, 2010 at 12:37 AM, Nani Ram 06n...@gmail.com wrote: Hi All, Does anybody have games in excel sheet, if so please send me. Thanks, Naniram -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.
$$Excel-Macros$$ Count number of times a part is out of stock without counting all days part is out of stock
I have a spreadsheet that has dates across the top row and a list of items in the first column. Under each date, if a part had a back- order, the total quantity appears under the respective date. What I am trying to do is figure out how many times an item has been on back-order in the last X days. I don't want the count of total days on back-order, that is easy. What I only want to count is the first day in a series of consecutive days that the item is on backorder. For example, part A has been on backorder for 15 out of the last 30 days. This could mean it has been on backorder every other day for the entire 30 day period (15 occurrences) {scenario 1} or it could have been in stock for 15 days, and out of stock for 15 consecutive days (1 occurrence) {scenario 2}. The example points to the extremes, but the number of occurrences could fall somewhere in between. I have the option of changing the layout if it will facilitate the calculation. I would also be open to using MSAccess to possibly perform the operation as well. I have done some one-time work to achieve results, but I have reached a point where I need this to be repeatable across a large dataset (1 records) I am pretty well versed in VBA but I cannot get my brain around this one. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject.