Re: $$Excel-Macros$$ Please make for me in macro code for in attached
Dear Please use Pivot Table Regards On Fri, Apr 15, 2011 at 12:50 PM, Umed Singh umed.singh.par...@gmail.comwrote: Hi Dear, I need your help in attached file. Please make for me in macro code for in attached file. i want to selected department and past another sheet for seperately. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ OT
very nice speech Mr. Paul Sir. Regards Sumit Vyas On Tue, Mar 8, 2011 at 7:07 PM, Paul Schreiner schreiner_p...@att.netwrote: Dave, Hey! I'm an ENGINEER, not an ENGLISH major! Or a veterinarian for that matter! What kind of dog would jump over a fox anyway... Always seemed (seems?) suspicious (spurious?), if you ask me... lol. Paul -- *From:* Dave Bonallack davebonall...@hotmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Mon, March 7, 2011 7:54:54 PM *Subject:* $$Excel-Macros$$ OT Hi Paul, Completely OT, but it has to be jumps, not jumped, otherwise there's no s in the sentence. -:) Dave. -- Date: Mon, 7 Mar 2011 06:13:04 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ ( ) for Array Must??? To: excel-macros@googlegroups.com It really depends on how you're using the array. Basically, using: Dim Arrayabc You're not declaring an array, you're declaring a single variable, type Variant. Now, later you can use Redim ArrayABC(30) and change the variable to an array. Or, curiously enough: ArrayABC = Split(The big brown dog jumped over the lazy fox, ) will Redim ArrayABC to whatever array size is required to store the string. (in this case, Ubound(ArrayABC) will be 8) If you were to use: Dim ArrayABC Dim ArrayDEF() Dim ArrayXYZ(3) . . . Redim ArrayABC(30) Redim ArrayDEF(30) Redim ArrayXYZ(30) ' Will not work, because the array was already defined. So, depending on how you plan to use it, you can either have the () or not. However, if you choose to use the (), you MUST (in some manner) define the array size before you can use the array. However: You CAN change a single variant to an array, and back again: Dim A A = The Big Brown Dog A = Split(The big brown dog jumped over the lazy fox, ) Erase A A = Jumped over the Lazy Fox hope this isn't too confusing. Paul -- *From:* hanumant shinde hanumant_5...@yahoo.co.in *To:* excel macros excel-macros@googlegroups.com *Sent:* Sat, March 5, 2011 2:31:03 PM *Subject:* $$Excel-Macros$$ ( ) for Array Must??? Hi friends, when we declare array is it must to give () i mean parantheses. can i declare array as dim arrayabc or i have to say dim arrayabc() i know that if we dont write any value in () its ok. but i am not sure if we can declare array without () -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns
=A2 B2 C2 = FSD COM com On Tue, Mar 8, 2011 at 7:17 PM, Paul Schreiner schreiner_p...@att.netwrote: another alternative actually reduces the wear on the ol' keyboard. =A2 B2 C2 accomplishes the same thing! Paul -- *From:* davidpk...@verizon.net davidpk...@verizon.net *To:* excel-macros@googlegroups.com; kandy.kr...@gmail.com *Sent:* Mon, March 7, 2011 1:32:54 PM *Subject:* Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns =CONCATENATE(A2, ,B2, ,C2) Dave Mar 7, 2011 06:51:07 AM, excel-macros@googlegroups.com wrote: data attached On Mon, Mar 7, 2011 at 3:47 PM, Krish wrote: Hi , I have data in row and column 1-3, and needs to club the data in single row and column since the data acorss three columns, Pls help me. Regards, Krish Kandy. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Sales Dashboard
Very Nice Mr. Kalyan On Wed, Jan 19, 2011 at 1:43 PM, Kal xcel kalx...@gmail.com wrote: Dear All, I am sharing two types of outlook of a Sales Dashboard which I am preparing for my company. I need your honest comment that looks wise which one is better. Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Dear Mr. Dilip *Congratulations to you* Regards Sumit Vyas On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ unlock excel sheet
send file On Sat, Dec 18, 2010 at 7:28 PM, Rajiv Kumar xlraja...@gmail.com wrote: Dear sir, I forget my excel password and how can open my excel sheet so dear sir plz unlocked my excel sheet Thanks regards Rajiv Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ On Time
find herewith thanks sumit On Mon, Nov 22, 2010 at 4:29 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Any help please Thanks On Fri, Nov 19, 2010 at 6:07 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, When I run the program excel starts flicekring how to avoid this. Thanks Chandra Shekar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Copy of ontime.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ workbook open password protected.
send file On Wed, Nov 17, 2010 at 4:20 AM, Johnnyboy5 intermediatec...@gmail.comwrote: workbook open password protected. I need to be able to get a message box to appear with some information - before the Password message box appears. I can get the message to appear after the Password box - but not before. any ideas. Johnnyboy -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Help Required
already give solution On Fri, Oct 29, 2010 at 3:16 PM, Born to Win cs4...@gmail.com wrote: Hello, Please Use COUNTA() Function or check Attached File. Thanks, Chandrabhan Singh On Fri, Oct 29, 2010 at 2:43 PM, Rakesh Sharma rksharma...@gmail.comwrote: *Dear All, Please find the attachment and let me know how its possible that . There are two sheets in my workbook in 1st sheet is raw data date wise and in second sheet in want date wise count , Note:- cell are not count repeatably. Please do the needful ASAP Thanks In advance * -- Regards Rakesh Sharma +91 9906115140 rakesh.kumar.d.sha...@ericsson.com rakesh_sharm...@yahoo.in -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ 2003 To 2007 Macro disable problem.
Dear All, I am send one file create in 2003 but file open 2007 2007 error macros disable ( Hyperlink data ) On Fri, Oct 15, 2010 at 10:02 PM, Vijay Kr. Aggarwal vjaggarwal2...@gmail.com wrote: Thanks a lot Srinivasan, siti, Paul and P. VijayKumar Regards, Vijay On Fri, Oct 15, 2010 at 5:28 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Dear Vijay After slecting your required data go to Format menu in that there are a number of formats.In the last there is Custom Format,By selecting that you can specify your own format.In that specify the format you want to have your data,Your data will be changed to the format you wanted. Regards, Vijaykumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ VLOOKUP PROBLEM
Dear Use sumif formulas SUMIF(Sheet1!$A$2:$A$19,Sheet2!A2,Sheet1!$B$2:$B$19) CR-MSP-619+ 110 CR-MSP-620 600 CR-MSP-621 400 CR-MSP-622 180 CR-MSP-623 140 CR-MSP-624+ 110 CR-MSP-625 150 CR-MSP-626 350 CR-MSP-627+ 80 CR-MSP-628 360 CR-MSP-629 1000 CR-MSP-630 80 CR-MSP-631+ 140 CR-MSP-632 450 On Thu, Oct 14, 2010 at 9:36 PM, ashish koul koul.ash...@gmail.com wrote: hi check the attachment see if it helps you you can apply customer filter on temp column and choose greater than 1 and copy all and paste into sheet2 On Thu, Oct 14, 2010 at 8:06 PM, renuka chari jva.ch...@gmail.com wrote: GOOD EVENIG ALL EXPERTS CAN U SLOVE MY VLOOKUP PROBLEM THIS IS MY DATA IN SHEET1 = VNo CR Amt = CR-MSP-619+ 70 CR-MSP-620 600 CR-MSP-621 400 CR-MSP-622 180 CR-MSP-623 140 CR-MSP-624+ 60 CR-MSP-625 150 CR-MSP-626 350 CR-MSP-627+ 70 CR-MSP-628 360 CR-MSP-629 1000 CR-MSP-630 80 CR-MSP-631+ 60 CR-MSP-632 450 CR-MSP-619+ 40 CR-MSP-624+ 50 CR-MSP-627+ 10 CR-MSP-631+ 80 PLUS VALUS ARE DUPLICATE VOCHERS AND DIFFERENT CR AMT VALUES MY QUERY IS USING VLOOKUP FUNCTION MAPING THESE VNO INTO SECOUND DUPLICATE VALUES ONLY IN OTHER SHEET = VNO CR AMT CR-MSP-619+ 40 CR-MSP-624+ 50 CR-MSP-627+ 10 CR-MSP-631+ 80 THANKS IN ADVANCE -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..
Xls 2003 Select Data Copy Data Past Data Past Only Filter Data On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Experts, Please solve my problem. How can we copy only filtered data in Excel. -- Thanks in advance.. Noorain Ansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Text to collumn
gb On Wed, Oct 13, 2010 at 2:18 PM, kaza deepu deepuk...@gmail.com wrote: Hi Kashan Abbas, Find attached it may helps you. On 10/13/10, Kashan Abbas kashanabbas...@hotmail.com wrote: Dear All, I have extracted a report from sap .The first column has been merged with multiple information for which i need separe column. The detail of information in first column is given as first few character represent product name ,then SAE level e.g (SAE 40,SAE 10W90) and then packing size e.g (4L Can and 205LDrum) .I just want to have seprate collumn for each given information.I am using text to collumn option but could not able produce desired output. For you working file have been attached.Please suggest me best possible solution on urgent basis. Need of your usual cooperation . Regards , Kashan Abbas . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards, Dileep Kumar Kaza Duty is God Work is Worship -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ VLOOKUP function
Dear, Please find herewith VBA vlookup one Value look up in column 1 6 Value look up in column 2 vlookup2(F10, F11, tLookupDemo, 3) Result Option Explicit '' *** '' Purpose : Test VLOOKUP2 function '' Written : 01-Nov-2001 by Andy Wiggins, Byg Software Limited '' Notes: To see the reuslts, ensure the Immediate window is open (Ctrl+G) '' Sub Test_Vlookup2() ThisWorkbook.Activate Sheets(Lookup in two columns).Select ''Test two numeric parameters Debug.Print (1) VLOOKUP2(3, 5, Range(tLookupDemo), 3) ''Test alpha and numeric parameter Debug.Print (2) VLOOKUP2(One, 4, Range(tLookupDemo), 3) ''Test two valid parameters If IsError(VLOOKUP2(3, 5, Range(tLookupDemo), 3)) Then Debug.Print (3) Is error Else Debug.Print (3) Okay End If ''Test with an invalid parameter If IsError(VLOOKUP2(33, 5, Range(tLookupDemo), 3)) Then Debug.Print (4) Is error Else Debug.Print (4) Okay End If End Sub '' *** '' Purpose : Lookup function based on two columns / Demonstrate use of Evaluate '' Written : 30-Oct-2001 by Andy Wiggins, Byg Software Limited '' Amended : 09-May-2002 by Andy Wiggins '' Function VLOOKUP2(pVal1, pVal2, pRng As Range, pInd As Integer) ''The lookup values refer to columns 1 and 2 in the range Application.Volatile Dim lStr_Seek As String Dim lStr_Col1 As String Dim lStr_Col2 As String Dim lStr_Col3 As String ''If an error occurs with Evaluate it isn't passed to this function's error handler ''This handler will pick up any other errors that may occur On Error GoTo Error_VLOOKUP2 ''The quotes enure strings are treated as such and NOT as range names lStr_Seek = pVal1 : pVal2 lStr_Col1 = pRng.Columns(1).Address lStr_Col2 = pRng.Columns(2).Address lStr_Col3 = pRng.Columns(pInd).Address VLOOKUP2 = Evaluate(index( lStr_Col3 ,match( lStr_Seek , lStr_Col1 : lStr_Col2 ,0))) Exit Function Error_VLOOKUP2: VLOOKUP2 = Err End Function On Mon, Oct 11, 2010 at 5:34 PM, Pranav Vashishtha pranav...@gmail.comwrote: Dear Alan Apply tis formula and your problem will be over. VlOOKUP Function needs 4 parameters your 1st,2nd, 4th parameters are correct but in the 3rd parameter (Column no.) you supplied the column address that is $E:$E. I have just changed it to column no. 2 which is second column of your table where you want to look up for data. =VLOOKUP($A2,$D$2:$E$9,2,FALSE) Hope that helps! Warm Regards, Pranav On Sun, Oct 10, 2010 at 2:30 AM, Alan jalantho...@verizon.net wrote: I am using Excel 2007 and having a strange problem with the VLOOKUP function. I have never used it before, but I have looked at examples on the Internet. However, I cannot figure it out. I placed the following formula in Cell B2: =VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE) and then copied it to B3 and B4, which respectively show up as: =VLOOKUP($A3,$D$2:$E$9,$E:$E,FALSE) =VLOOKUP($A4,$D$2:$E$9,$E:$E,FALSE) My lookup table is located at D2:E9, with what I am looking up in column D, and the value for the lookup in column E. I placed the second entry in the table in cells A2, A3, and A4. The VLOOKUP functions in cells B2, B3, and B4 show the following results: B2: #VALUE! B3: second entry in the table, same as in A3 B4: the correct lookup value. This does not make any sense to me, based on the examples I have seen. What am I doing wrong? Thanks, Alan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link
Re: $$Excel-Macros$$ Column hide from excel
Dear Vishal This trick is VBA inst log file. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count = 1 Then If Target.Value Then If Target.Column = 3 And Target.Row 1 Then Target(1, -1) = Format(Now, dd-mmm- hh:mm:ss) Target(1, 0) = Application.UserName End If End If End If End Sub But One Bug :-modify data any time change your log sugg :- please enter option on entry then enter protect row Thanks 7 Regards Sumit On Fri, Oct 8, 2010 at 4:03 PM, Vishal Angre vishal.k.an...@gmail.comwrote: 4 column(A,B,C,D) in atteched excel, please tell me how to do this -- With Regards, *Vishal K. Angre* E-mail : visha...@gmail.com vishal.k.an...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Job Opening for Excel and VBA
Dear Ayush, Thanks for you, 1) excel group 2) help all time 3) touch you every 4) help find job you are great person in this world. regard Sumit Vyas On Fri, Oct 8, 2010 at 9:20 PM, Ayush jainayus...@gmail.com wrote: Dear Group, There is a opening for one person with the following skill to work as Sub contractor. Basic Skill set: (Mandatory) Advance knowledge of xl and VBA Marco Advance Skill Set: (Optional) Exposure to PM methodology Quality Systems Qualifications: MCA/BE Company Name :- STMicroelectronics Location :- Greater Noida Job Type :- Contractual. Please let me know if somebody known to you is interested. Send me the resume at jainayus...@gmail.com. Thanks. Best regards, Ayush Jain Group Manager. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months
Dear one colum set structure :- month = jan-2008 jan-2009 jan-2010 then use use pivot table On Sat, Oct 9, 2010 at 10:34 AM, Kal xcel kalx...@gmail.com wrote: Hi Worawat, Thanks for your advice. But I can't use pivot table in this scenario. Because lot of other issues attached with this. Thanks Kalyan On Sat, Oct 9, 2010 at 3:43 AM, worawat kh worawat...@gmail.com wrote: Hi Kalyan You can use pivot table to solve this , better than use many excel function Worawat 2010/10/8, Kal xcel kalx...@gmail.com: Dear Experts, I want to extract last 3 months consolidated sale data based on current month. I have attached the file with my query. Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Moo Moo' I have much time for give you -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ write to end of page to foot total
Dear, Please send No Of Row No Of Column Sheet Name eg: Date / Name / No. 1-2-3 / product name i make sure report. Regards Sumit Vyas On Thu, Oct 7, 2010 at 4:26 PM, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote: Mr Brain, A macro can be written such that 1. It will copy certain number of rows (one page full) to another sheet (example sheet2) 2. In sheet2 it will be formatted for printout (such that C/F, B/F, Page header, Page footer etc.) (counters will be maintained for page numbers, C/F, B/ F ) 3. the page will be printed 4.Repeat the process till all 10,000 rows are over If you won't get reasonable solution from others, U can send me the file to my mail ID. I can construct the macro and send it to you. Regards, Kishan Reddy kishanreddy.kethire...@gmail.com On Oct 7, 12:26 pm, fill brain fillbr...@gmail.com wrote: Hello , i mean i want to see to totals on custom footer.. like below excel file.. i wrote xxx which place i want to write footer total.. my intention. that is file... ornek.xls i added it in the group files. http://excel-macros.googlegroups.com/web/ornek.xls?gda=e7Xufj4o61... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Analysing
On Wed, Oct 6, 2010 at 10:41 AM, SUMIT VYAS svyas0...@gmail.com wrote: Dear No Proper work On 10/5/10, Paul Schreiner schreiner_p...@att.net wrote: funny! Luckily, I haven't had any of my editors convert the characters to smileys! It would make it VERY distracting.. although cheerful! Paul - Original Message From: ta...@tinusz.hu ta...@tinusz.hu To: excel-macros@googlegroups.com Sent: Tue, October 5, 2010 10:17:47 AM Subject: Re: $$Excel-Macros$$ Analysing nice mackro! :-) see att. On Tue, 5 Oct 2010 06:52:11 -0700 (PDT), Paul schreiner_p...@att.net wrote: Try: Sub AddTags() Dim ChkStr, ChkChar, OutStr, C ChkStr = Range(A1).Value OutStr = For C = 1 To Len(ChkStr) ChkChar = Mid(ChkStr, C, 1) If (IsNumeric(ChkChar)) Then OutStr = OutStr N ChkChar ElseIf ((ChkChar = UCase(ChkChar)) _ And (ChkChar )) Then OutStr = OutStr H ChkChar Else OutStr = OutStr ChkChar End If Next C Range(B1).Value = OutStr End Sub Paul - Original Message From: sivam sivamma...@gmail.com To: Paul Schreiner schreiner_p...@att.net Sent: Tue, October 5, 2010 8:57:18 AM Subject: Re: $$Excel-Macros$$ Analysing suppose if a cell(one) having value like Mathusudh ANan12 means i need to take each and every cell and i need to check. If a particular character having Capital letter than i need to put H infront of the character. If it is number i need to put N infront of the character. Please look into this.. On Oct 5, 8:50 am, Paul Schreiner schreiner_p...@att.net wrote: what do you want to do with them? are they in a cell or from a userform? - Original Message From: sivam sivamma...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, October 5, 2010 8:39:34 AM Subject: $$Excel-Macros$$ Analysing Hi My string is surha12hj Here i want to take each and every character and i need to take only charaters which is from A-Z or a-z.. Can any one help on to this. -- -- - Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall...- 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Please help
Dear Rajasekhar Please use u Sumif Formulas. Regards Sumit Vyas On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: hi Excel Guru, Please assist me in this concern . Attached are two sheets Task distribution orginal and other sheet with task distribution My daily activity is to do vlookup and firstly i will copy the pivot table from task distribution sheet orginal and paste special in one new excel sheet then compare it with another sheet which is task distribution sheet. 1) Prepare vlookup to find the batches which are pending . once i perform vlookup it will display the names against the batches. which are pending . Please advise is this possible through vba. Thanks for your help in advance., Raj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ VBA Passward
Dear SX0123456789X On 10/6/10, Jai jaihumtu...@gmail.com wrote: I need VBA Passward in Excel , Because When Anybody open in excel file he want VBA Passward . Thaks in Advance -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10
Dear Mr. Ayush Jain One Word Name You : - *Matrix EXCEL * Congratulations Ayush Jain. Really Very proud of you man. Regards Sumit Vyas On 10/5/10, Aindril De aind...@gmail.com wrote: Hey Ayush!! You haven't responded to Neil's email Where is the Treat Man!!!? [?][?] Cheers, Andy On Mon, Oct 4, 2010 at 9:17 PM, krishna mummina lovemekris...@gmail.comwrote: Congratulations Ayush Jain. Really Very proud of you man. On 10/4/10, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: hearty congratulations ayush, you really deserve it Infact you are good encyclopedia for us. Have a flamboyant future and delightful moments for ur future endeavors. Regards, Raj On Sun, Oct 3, 2010 at 3:47 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am proud to announce that I am awarded Microsoft Most Valuable Professional MVP on October 01, 2010 for providing technical expertise in Excel technical communities for past one year. http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx This is a prestigious award from Microsoft given every Quarter to the people who share their deep knowledge, real-world experience, and impartial, objective feedback to help people enhance the way they use technology. My deep thanks to each group member for all your support and contribution to this group. Best regards, Ayush Jain Microsoft MVP -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts 982.gif
Re: $$Excel-Macros$$ Numer To Text
Dear Vijay Very Good explain by you Thanks On 10/5/10, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear Ankit, There is no Direct formula to convert numbers into text.But there are some add-ins available in the websites. just google for text to numbers converter in excel add-in. Once you download the add-in to install the add-in to excel go to the excel ribbon Button, the from there open excel options ,then select add-in from the avialble options. Excel will then display the add-ins which are already installed . It will also have a go button in the bottom for installing others in that it will show some available not installed add-ins,you can also install them along with our add-in..After clicking go button then click the browse button then select the file which you downloaded to any disk or any place in your computer.Then click OK.Your add-in is installed.Once installed the file which is selected for installation should not be moved from the place it is downloaded.To many movements make the add-in not working.So when downloading only make sure that the file is saved in a place in which is is not disturbed further.Once installed you add-in shall work in every workbook. Make sure that an addin button is added to the Menu Bar.Hope this clarified your problem Regards, VijayKumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Analysing
Dear No Proper work On 10/5/10, Paul Schreiner schreiner_p...@att.net wrote: funny! Luckily, I haven't had any of my editors convert the characters to smileys! It would make it VERY distracting.. although cheerful! Paul - Original Message From: ta...@tinusz.hu ta...@tinusz.hu To: excel-macros@googlegroups.com Sent: Tue, October 5, 2010 10:17:47 AM Subject: Re: $$Excel-Macros$$ Analysing nice mackro! :-) see att. On Tue, 5 Oct 2010 06:52:11 -0700 (PDT), Paul schreiner_p...@att.net wrote: Try: Sub AddTags() Dim ChkStr, ChkChar, OutStr, C ChkStr = Range(A1).Value OutStr = For C = 1 To Len(ChkStr) ChkChar = Mid(ChkStr, C, 1) If (IsNumeric(ChkChar)) Then OutStr = OutStr N ChkChar ElseIf ((ChkChar = UCase(ChkChar)) _ And (ChkChar )) Then OutStr = OutStr H ChkChar Else OutStr = OutStr ChkChar End If Next C Range(B1).Value = OutStr End Sub Paul - Original Message From: sivam sivamma...@gmail.com To: Paul Schreiner schreiner_p...@att.net Sent: Tue, October 5, 2010 8:57:18 AM Subject: Re: $$Excel-Macros$$ Analysing suppose if a cell(one) having value like Mathusudh ANan12 means i need to take each and every cell and i need to check. If a particular character having Capital letter than i need to put H infront of the character. If it is number i need to put N infront of the character. Please look into this.. On Oct 5, 8:50 am, Paul Schreiner schreiner_p...@att.net wrote: what do you want to do with them? are they in a cell or from a userform? - Original Message From: sivam sivamma...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, October 5, 2010 8:39:34 AM Subject: $$Excel-Macros$$ Analysing Hi My string is surha12hj Here i want to take each and every character and i need to take only charaters which is from A-Z or a-z.. Can any one help on to this. -- -- - Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall...- 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Remove the Space
Dear, Please Select A Row Press Ctrl + F Alt + P Find What :- Space Key 5 To 10 Replace With :- Blank Click Replace All Please try it On 9/25/10, Jai jaihumtu...@gmail.com wrote: Dear Groups Member, I want to Remove the Space, In Cloum C , Sheet Attach, Please Help me. Thanks for Advance. -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Fwd: कविता :- उस Expert का शुभ नाम है......पाण् डेय MR. दिलीप जी.
Dear All R/s Friends Dilip Pandey is great personality . That is truth. He is genius and great knowledge of excel vba. I salute to you . D = Data ( Good Data Method ) I = Input ( All input Knowledge ) L = Logic ( Good Logic ) I = International ( International Khiladi ) P = Platform ( In Excel - Macro Platform ) Formula *=VlookupData+input+logic+international) , ( world,moon,sun,galaxy) (all talent ) True * Ans Ans =*Mr. DILIP* Regards Sumit Vyas On 9/28/10, ayush jain jainayus...@gmail.com wrote: Hi Dilip, You deserve this appreciation in the form of poem. we all love you and your solutions. KEEP IT UP. Hi Noorain, I think we have a great poet with us...Now I will bother you to write more poems(or chaalisa) for our excel enthusiasts.. :) Thank you for awesome poem for wonderful person. May be you will write poem in English next time for our English readers. Best Regards, Ayush Jain Group Manager -- Forwarded message -- From: Dilip Pandey dilipan...@gmail.com Date: 2010/9/28 Subject: Fwd: कविता :- उस Expert का शुभ नाम है..पाण्डेय MR. दिलीप जी. To: ayush jain jainayus...@gmail.com FYI..!! Many thanks to you as well for creating this wonderful platform.. :) Warmest Regards, DILIPandey -- Forwarded message -- From: NOORAIN ANSARI noorain.ans...@gmail.com Date: 2010/9/28 Subject: कविता :- उस Expert का शुभ नाम है..पाण्डेय MR. दिलीप जी. To: Dilip Pandey dilipan...@gmail.com, dilipan...@yahoo.com जिनके ह्रदय के धरातल पर जलता है EXCEL का दीप जी. और उस दीप के रौशनी में पलते है कई हजारों TRICK जी. उस Expert का शुभ नाम है... पाण्डेय MR. दिलीप जी. झट से पूछो सवाल, और चट से पावों जवाब. Excel/VBA का है ये एक चलता-फिरता किताब. इनके FUNDO के पीछे LOGIC है बेहिसाब. इनके इस skills का तो हम है पुराने FAN जी. तभी तो इनको कहते है हम MACRO MAN जी. बहूत ज्यादा PRACTICE छुपी है जो इनकी KNOWLEDGE है DEEP जी. उस Expert का शुभ नाम है... पाण्डेय MR. दिलीप जी. As a Friend भी ये एक बहूत अच्छे इंसान है. दिल की बाते खुलकर कहना इनकी मूल पहचान है. ग्रुप का प्रॉब्लम SOLVE करने में इनका बहूत योगदान है. मगर अपनी तारीफ़ करने से ये बहूत ज्यादा बचते है. तभी तो अपने दोस्तों को, ये बहूत ज्यादा जचते है. मैं जितना लिखूं होगा उनके बारे में बस BRIEF जी. उस Expert का शुभ नाम है... पाण्डेय MR. दिलीप जी. आपका एक फनकार दोस्त, नूरैन अंसारी -- Thanks regards, Noorain Ansari -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ HIGHLIGHT CODE Please explain it
Please use application in macro coding. On Tue, Sep 14, 2010 at 4:50 PM, عمر omar27...@gmail.com wrote: *Range(A i + 2).* = a2 *Resize(1, 6)** = a2:f2* * * *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *neil johnson *Sent:* Tuesday, September 14, 2010 9:17 AM *To:* villager.g...@gmail.com; davebonall...@hotmail.com *Cc:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ HIGHLIGHT CODE Please explain it Hi Sir, Please explain that highlighted code . What is that means. Dim i As Long, j As Long For i = 0 To Me.ListBox1.ListCount - 1 If Me.ListBox1.Selected(i) Then * Worksheets(Sheet1).Range(A i + 2).Resize(1, 6).*Copy Worksheets(Sheet2).Range(A Rows.Count).End(xlUp).Offset(1) End If Next i Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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: FW: $$Excel-Macros$$ Entering Data in Excel
Dear, Right Click Cell Format Number Tab Select Number decimal place is 0 ok Regards Sumit Vyas +919755549483 On Sat, Sep 11, 2010 at 8:00 PM, Saurabh Patel saurabh.pa...@in.aegisglobal.com wrote: Change the cell format to Number by right clicking on cell. Regards, Saurabh Patel -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of viju mobile Sent: Saturday, September 11, 2010 5:39 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Entering Data in Excel Hi All, I am trying to input 20 digit number in a column. But it does not enter it correctly. Please guide me. Regards, Vijay -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 DISCLAIMER:The information contained in this electronic message and in any attachments to this message is confidential, legally privileged and intended only for the person or entity to which this electronic message is addressed. If you are not the intended recipient, please notify the system manager and you are hereby notified that any distribution, copying, review, retransmission, dissemination or other use of this electronic transmission or the information contained in it is strictly prohibited. Please accordingly also note that any views or opinions presented in this email are solely those of the author and may not represent those of the Company or bind the Company. This message has been scanned for viruses and dangerous content by Mail Scanner, and is believed to be clean. The Company accepts no liability for any damage caused by any virus transmitted by this email. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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$$ Convert Numeric Value in Character.....
1. Start Microsoft Excel. 2. Press ALT+F11 to start the Visual Basic Editor. 3. On the *Insert* menu, click *Module*. 4. Type the following code into the module sheet. Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Dollars, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = Thousand Place(3) = Million Place(4) = Billion Place(5) = Trillion ' String representation of amount. MyNumber = Trim(Str(MyNumber)) ' Position of decimal place 0 if none. DecimalPlace = InStr(MyNumber, .) ' Convert cents and set MyNumber to dollar amount. If DecimalPlace 0 Then Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) _ 00, 2)) MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If Count = 1 Do While MyNumber Temp = GetHundreds(Right(MyNumber, 3)) If Temp Then Dollars = Temp Place(Count) Dollars If Len(MyNumber) 3 Then MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = End If Count = Count + 1 Loop Select Case Dollars Case Dollars = No Dollars Case One Dollars = One Dollar Case Else Dollars = Dollars Dollars End Select Select Case Cents Case Cents = and No Cents Case One Cents = and One Cent Case Else Cents = and Cents Cents End Select SpellNumber = Dollars Cents End Function ' Converts a number from 100-999 into text Function GetHundreds(ByVal MyNumber) Dim Result As String If Val(MyNumber) = 0 Then Exit Function MyNumber = Right(000 MyNumber, 3) ' Convert the hundreds place. If Mid(MyNumber, 1, 1) 0 Then Result = GetDigit(Mid(MyNumber, 1, 1)) Hundred End If ' Convert the tens and ones place. If Mid(MyNumber, 2, 1) 0 Then Result = Result GetTens(Mid(MyNumber, 2)) Else Result = Result GetDigit(Mid(MyNumber, 3)) End If GetHundreds = Result End Function ' Converts a number from 10 to 99 into text. Function GetTens(TensText) Dim Result As String Result =' Null out the temporary function value. If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19... Select Case Val(TensText) Case 10: Result = Ten Case 11: Result = Eleven Case 12: Result = Twelve Case 13: Result = Thirteen Case 14: Result = Fourteen Case 15: Result = Fifteen Case 16: Result = Sixteen Case 17: Result = Seventeen Case 18: Result = Eighteen Case 19: Result = Nineteen Case Else End Select Else ' If value between 20-99... Select Case Val(Left(TensText, 1)) Case 2: Result = Twenty Case 3: Result = Thirty Case 4: Result = Forty Case 5: Result = Fifty Case 6: Result = Sixty Case 7: Result = Seventy Case 8: Result = Eighty Case 9: Result = Ninety Case Else End Select Result = Result GetDigit _ (Right(TensText, 1)) ' Retrieve ones place. End If GetTens = Result End Function ' Converts a number from 1 to 9 into text. Function GetDigit(Digit) Select Case Val(Digit) Case 1: GetDigit = One Case 2: GetDigit = Two Case 3: GetDigit = Three Case 4: GetDigit = Four Case 5: GetDigit = Five Case 6: GetDigit = Six Case 7: GetDigit = Seven Case 8: GetDigit = Eight Case 9: GetDigit = Nine Case Else: GetDigit = End Select End Function 5. 6. 7. copy past On Mon, Aug 9, 2010 at 11:37 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Experts, I need to convert Numeric Value in charaters..Is it possible through excel or Macro. Example... 25302- *Twenty Five thousand three hundred two.* With Advance Thanks, Noorain Ansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at
Re: $$Excel-Macros$$ needs to crack the password for excel window
YES On Sat, Jul 31, 2010 at 1:28 AM, shashank bhosle catchshashankbho...@yahoo.co.in wrote: Hi, Is it possible to crack the password for the excel window. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 to ADD product of two columns in a single cell
good On Thu, Jul 22, 2010 at 10:27 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Hi There, See attached file. Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal ravepat...@gmail.comwrote: Please help to add the product of two columns e.g. Column1Column2 23 119 8954 63 32 Want to add (r1c1*r1c2+r2c1*r2c2+r3c1*r3c2) Thanks Ravi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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$$ Pivot table for Datewise Bank Balance
good On Wed, Jun 2, 2010 at 4:52 PM, prabhakar thakur prabhakarthak...@gmail.com wrote: Dear, Please find the attached your query. Thanks, Prabhakar Thakur New Delhi +919953736776 On Wed, Jun 2, 2010 at 12:37 PM, Ashish Khandelwal 4everash...@gmail.comwrote: Dear friends, I want to create a Pivot table with the attached data file. In that I want to check the Bank Balnce datewise or Bank wise. Please send me the Pivot table for the same which will solve my requirement. Pl shelp me in this regard. Thanks, Ashish. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 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 WORK IN ONE WORKBOOK IN MULTIPLE LOCATION
Dear Local Area Network Working Possibale Yes I try Success On Mon, Jan 11, 2010 at 5:48 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Anant, I don't think this is possible in XL. It is standard procedure in Access. Can you use that instead? Regards - Dave. -- Date: Mon, 11 Jan 2010 15:29:04 +0530 Subject: $$Excel-Macros$$ HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE LOCATION From: anant.shelk...@gmail.com To: excel-macros@googlegroups.com Hi, I want some help and little bit challenging I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS AND ALL THE CHANGES MADE BY ALL USERS IT TO BE SAVE IN THAT FILE IF IT IS POSSIBLE PLS TELL ME HOW CAN I DO IT -- Anant Fakt Tumachyasathi -- Browse profiles for FREE View photos of singles in your area!http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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$$ Code User Laval
GREAT ANKUR On Sat, Jan 9, 2010 at 10:32 AM, ankur ankurpande...@gmail.com wrote: hi ramesh please check this file On 1/8/10, Chanti-Hyderabad ramesh1...@gmail.com wrote: Hi Ankur, That working file looks awesomebut i cant see see any data on 'New Data' sheet. Is there a way i can see the data change according to my requirement? Thanks in Advance, Ramesh On Jan 7, 4:33 pm, ankur ankurpande...@gmail.com wrote: hi sumit please check the attached file if any other modification needed? thanks On 1/7/10, SUMIT VYAS svyas0...@gmail.com wrote: Dear Ankur, Thanks For Your Reply I want Make Excel Advance Lavel I show Code But I Hide Code This List No Report Gen rate I want Milty User Working This Excel Report Gen rate One Time . On Thu, Jan 7, 2010 at 11:47 AM, ankur ankurpande...@gmail.com wrote: hi sumit please tell me your requiremnet On 1/7/10, SUMIT VYAS svyas0...@gmail.com wrote: Dear Madhu This Sheet Not A Formulas V Lookup Ok On Wed, Jan 6, 2010 at 8:17 PM, madhu nair madhuna...@gmail.com wrote: Hi SUmit, I added Vlookup, i think thats what you need, check attached sheet, On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS svyas0...@gmail.com wrote: Dear, I Make Some Excel Code User Lavel Setting Ags Report. Please Check Modify Report Please Talk Any Problem. I Wating Your Reply . -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ New Reportin By Ankur Pandey..xlsx 122KViewDownload -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest
Re: $$Excel-Macros$$ Extracting
Dear Solved Password Creack Ask Any Body please ask me formulas =sumit(a1,vyas,2,false) Breack Password This Sheet On Sat, Jan 9, 2010 at 3:34 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Cliff, Just change the cell format to Time. Explained in the attached image. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/6/10, CliffSP cliff.par...@btinternet.com wrote: Hi All I have a spreadsheet with a column of dates times in the format: 12/10/2009 13:23:00 I need to extract just the date part of this field - I don't want the time, but I cannot use =Left(A1,10) as the cell is not text. Any help would be appreciated. Cliff -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 Copy of dropdown.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Password Cracker file
Dear Nandkumar kakvipure This Password Creak Firs Mr.t Sandeep Second Mr. Ankur Third Mr. Sumit Vyas Fourth Nandkumar Thanks For You You Are A Batter. i learning excel. help me thanks On Fri, Jan 8, 2010 at 9:58 AM, Nandkumar kakvipure nandkumar.hindust...@gmail.com wrote: Hello, Find Unprotect File. Password : File-Open password: no password is set File-Modify password: no password is set Workbook password: [DJVXZQWRYQVBMLR] (no brackets) Copy (generated) (removed) Worksheet [1] password: [DJVXZQWRYQVBMLR] (no brackets) Copy (generated) (removed) Range [sumit vyas] password: [DJVXZQWRYQVBMLR] (no brackets) Copy (generated) (removed) *Unprotected file: *New Reporting(2)-unprotected.xls On Thu, Jan 7, 2010 at 3:09 PM, Sathish Jalendran sath...@teamlease.comwrote: Hi, Please find attached the same Regards Sathish Jalendran [image: Picture (Device Independent Bitmap)] *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *SUMIT VYAS *Sent:* 07 January 2010 PM 01:34 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Password Cracker file Dear Attach File Please Creak Password Reply Me On Thu, Jan 7, 2010 at 12:28 PM, grlinks-karthik grli...@gmail.com wrote: Attach the file On Tue, Jan 5, 2010 at 5:07 PM, Prathap . writetosamplesp...@gmail.com wrote: Hi There.. I have excel file which is protected. Can anyone please help crack the password. If possible, then pls tell me. Keeping the confidentiality in to consideration i can mail the excel file to the concerned . Thanks in advance -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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
Re: $$Excel-Macros$$ Help needed
check my attachment On Thu, Jan 7, 2010 at 5:53 PM, Alokeshwar Tiwary alokeshwar.tiw...@yahoo.com wrote: See attached, there is a new column 'Range' with a conditional formula. Use the same to categorize in range and then use a pivot table to get required results. _ There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know. -- *From:* Robinson Boreh rbo...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, 7 January, 2010 3:11:15 PM *Subject:* $$Excel-Macros$$ Help needed Hi guyz, Thanks for the good work you are doing. Am elated to have joined this group and again cheers to you all. All that aside I need your assistance. I need to have a report with the columns and rows as follows RangeType of DepositNumber of depositsAmount Less than 50,000 50,000 - 100,000 100,001 - 500,000 500,001-1,000,000 Over 1,000,00 Attached, please find the data in excel. Regards *Robinson Boreh, * *Finanace Department, Upper Hill,* *Tel: 2874243, 0711019243 Fax: 2719705* -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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! Homepagehttp://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/ . -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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$$ Advance Excel
Dear All, Please Ask Me How To Coding In Excel Exsampel Code Report Enter Code Report Gen rate 101Sale 101CollectionReport 100% Ok How This Is Possible In Excel Without Micro. I Make Program Excel This Future . -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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$$ Code User Laval
Dear Madhu This Sheet Not A Formulas V Lookup Ok On Wed, Jan 6, 2010 at 8:17 PM, madhu nair madhuna...@gmail.com wrote: Hi SUmit, I added Vlookup, i think thats what you need, check attached sheet, On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS svyas0...@gmail.com wrote: Dear, I Make Some Excel Code User Lavel Setting Ags Report. Please Check Modify Report Please Talk Any Problem. I Wating Your Reply . -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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$$ Code User Laval
Dear Ankur, Thanks For Your Reply I want Make Excel Advance Lavel I show Code But I Hide Code This List No Report Gen rate I want Milty User Working This Excel Report Gen rate One Time . On Thu, Jan 7, 2010 at 11:47 AM, ankur ankurpande...@gmail.com wrote: hi sumit please tell me your requiremnet On 1/7/10, SUMIT VYAS svyas0...@gmail.com wrote: Dear Madhu This Sheet Not A Formulas V Lookup Ok On Wed, Jan 6, 2010 at 8:17 PM, madhu nair madhuna...@gmail.com wrote: Hi SUmit, I added Vlookup, i think thats what you need, check attached sheet, On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS svyas0...@gmail.com wrote: Dear, I Make Some Excel Code User Lavel Setting Ags Report. Please Check Modify Report Please Talk Any Problem. I Wating Your Reply . -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 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