Re: $$Excel-Macros$$ Thank you Dave Bonallack !!
Congratulations Dave! great help for all of us, keep contributing. Regards Vasant On 8/4/10, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Thanks you very much *Dave*.. God has given you a brilliant mind..and you always solve to group's problem Kindly Keep it in future.. Regards, Noorain On Wed, Aug 4, 2010 at 10:49 AM, Dave Bonallack davebonall...@hotmail.com wrote: Thanks Dilip. Dave. -- Date: Tue, 3 Aug 2010 20:43:16 +0530 Subject: Re: $$Excel-Macros$$ Thank you Dave Bonallack !! From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: davebonall...@hotmail.com Thanks Dave for Gearing upp...!! you are awsome.. Keep helping the GROUP...!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Sat, Jul 31, 2010 at 2:29 PM, Ayush jainayus...@gmail.com wrote: Dear Group, In the recent group survey conducted, I asked one question that How the top posters should be rewarded in the group ... and most of you replied that we should announce the name of top poster every month... So the time has come to announce the Top Poster of July 2010 and i.e. Our own Excel and Macros Expert DAVE BONALLACK. He is not only top poster of the month but is the top poster of the group with 461 posts. Dave, you are the asset of the group and we feel very proud for your association with this group. Your voluntary support is very helpful ( and life saver for some :) ) . We wish you all the best for your assignments and expect long association with the group. Thank you Dave :) I have published the name of monthly top poster on Home Page... Keep posting !! Regards, Ayush Jain Group Manager P.S. If you have any feedback for group, please fill the survey formhttp://www.surveymonkey.com/s/L8BTDNQ -- -- 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 -- Thanks regards, Noorain Ansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the
Re: $$Excel-Macros$$ Thank you Dave Bonallack !!
Any VBA developer in NCR, India looking for job change. Fwd your resume to gauravhpah...@gmail.com by 10th Aug, 2010. On Wed, Aug 4, 2010 at 10:49 AM, Dave Bonallack davebonall...@hotmail.comwrote: Thanks Dilip. Dave. -- Date: Tue, 3 Aug 2010 20:43:16 +0530 Subject: Re: $$Excel-Macros$$ Thank you Dave Bonallack !! From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: davebonall...@hotmail.com Thanks Dave for Gearing upp...!! you are awsome.. Keep helping the GROUP...!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Sat, Jul 31, 2010 at 2:29 PM, Ayush jainayus...@gmail.com wrote: Dear Group, In the recent group survey conducted, I asked one question that How the top posters should be rewarded in the group ... and most of you replied that we should announce the name of top poster every month... So the time has come to announce the Top Poster of July 2010 and i.e. Our own Excel and Macros Expert DAVE BONALLACK. He is not only top poster of the month but is the top poster of the group with 461 posts. Dave, you are the asset of the group and we feel very proud for your association with this group. Your voluntary support is very helpful ( and life saver for some :) ) . We wish you all the best for your assignments and expect long association with the group. Thank you Dave :) I have published the name of monthly top poster on Home Page... Keep posting !! Regards, Ayush Jain Group Manager P.S. If you have any feedback for group, please fill the survey formhttp://www.surveymonkey.com/s/L8BTDNQ -- -- 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 -- -- 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
$$Excel-Macros$$ Help Required Extract Numbers
Dear Group, Find Below data Requirement.I Want to extract numbers post (_ )Only. Raw Data Required Best Regards, Venkat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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 Help Required File.xls Description: MS-Excel spreadsheet
RE: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1
Hi Angelo, Have a look at the attached and run the macro. I've used Columns IS:IV as a work space. If you want to put data in these columns, then we'd have to change the macro a little. Regards - Dave. From: spinolaang...@gmail.com Date: Tue, 3 Aug 2010 10:37:22 +0100 Subject: Re: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1 To: excel-macros@googlegroups.com Does someone else know how to do this please! 2010/8/3 Dave Bonallack davebonall...@hotmail.com Hi Angelo, The summing could be done with worksheet functions - probably SUMPRODUCT. But the deleting of lines has to be done by macro, so it makes sense to do both by macro. I can't look at it straight away, but if no one else comes up with anything, I'll have a look later. Regards - Dave. From: spinolaang...@gmail.com Date: Mon, 2 Aug 2010 12:54:55 +0100 Subject: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1 To: excel-macros@googlegroups.com Forgot the attachment, sorry :) 2010/8/2 Angelo Spinola spinolaang...@gmail.com Hello All, I need a formula that Checks if B,C, D are the sameif equal (could have more than just two equal) sums the Columns E and F and replace it for just one Line instead of having duplicates or triplicates. How can i create this ? With a Macro ? Regards. -- -- 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 -- -- 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 problem.xls Description: Binary data
Re: $$Excel-Macros$$ Address Book Problem
Dear Mr.Nikhil, Find the attached file... I hope that, this file will fulfill your requirements... Regards, Marieswaran On Wed, Aug 4, 2010 at 11:15 AM, Nikhil Shah nikhil201...@gmail.com wrote: Hi Dave Recd your E-mail.. Thanks for sending excel sheet.. but still there is something missing to Address - Excel sheet, there is an error in Main sheet.. Error... Suppose I select Area : Navrangpura Category is Female, then, here you can see that only one the same name of Female Doctor is coming repeatedly and other columns are empty, You can see that in the Doc - Famale Sheet , there are total four Doctors in the selected area with information in other columns: So, actually I want to get all the cells of the selected data, ex. ... in above case, I want all the four names at once as I select Area Navrangpura and the category Female with all related columns filled. I am sending once again my address book - Excel sheet for your ref. pl help me out of this query.. Regards Nikhil On Wed, Aug 4, 2010 at 4:56 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, Please have a look at the attached. Regards - Dave. -- Date: Mon, 2 Aug 2010 17:45:28 +0530 Subject: $$Excel-Macros$$ Address Book Problem From: nikhil201...@gmail.com To: excel-macros@googlegroups.com Dear All Members, Here i am sending One Address Book - Excel Sheet.It contains ( 1 ) Main Menu ( 2 ) Doc - Male Data ( 3 ) Doc - Female Date. Address Execution Mode :- On Main Menu First I Select Area , Then I Select Category through Pop up list.. Now coming to query, ( 1 ). Suppose I select Category : Male... , then All Data should come From Doc - Male Database Female , then All Data Should come From Doc - Female Database. Pl help me out for my query, as you can see it is Huge Database..it is being updated regularly.. Awaiting Reply Nikhil Shah -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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 -- -- 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
Re: $$Excel-Macros$$ Address Book Problem
Dear Friend, O.K. Half Problem is Resolved. Columns Add_1 ; Add_2 ; Add_3 ; Tele( c ) ; Tele ( r ) and mobile No. - all are empty ex. ... in above case, I want all the four names at once as I select Area Navrangpura and the category Female with all related columns filled. For Pl see Main menu.. Regards, Nikhil On Wed, Aug 4, 2010 at 4:49 PM, Maries talk2mar...@gmail.com wrote: Dear Mr.Nikhil, Find the attached file... I hope that, this file will fulfill your requirements... Regards, Marieswaran On Wed, Aug 4, 2010 at 11:15 AM, Nikhil Shah nikhil201...@gmail.comwrote: Hi Dave Recd your E-mail.. Thanks for sending excel sheet.. but still there is something missing to Address - Excel sheet, there is an error in Main sheet.. Error... Suppose I select Area : Navrangpura Category is Female, then, here you can see that only one the same name of Female Doctor is coming repeatedly and other columns are empty, You can see that in the Doc - Famale Sheet , there are total four Doctors in the selected area with information in other columns: So, actually I want to get all the cells of the selected data, ex. ... in above case, I want all the four names at once as I select Area Navrangpura and the category Female with all related columns filled. I am sending once again my address book - Excel sheet for your ref. pl help me out of this query.. Regards Nikhil On Wed, Aug 4, 2010 at 4:56 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi, Please have a look at the attached. Regards - Dave. -- Date: Mon, 2 Aug 2010 17:45:28 +0530 Subject: $$Excel-Macros$$ Address Book Problem From: nikhil201...@gmail.com To: excel-macros@googlegroups.com Dear All Members, Here i am sending One Address Book - Excel Sheet.It contains ( 1 ) Main Menu ( 2 ) Doc - Male Data ( 3 ) Doc - Female Date. Address Execution Mode :- On Main Menu First I Select Area , Then I Select Category through Pop up list.. Now coming to query, ( 1 ). Suppose I select Category : Male... , then All Data should come From Doc - Male Database Female , then All Data Should come From Doc - Female Database. Pl help me out for my query, as you can see it is Huge Database..it is being updated regularly.. Awaiting Reply Nikhil Shah -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join
Re: $$Excel-Macros$$ Ctrl + space bar
When you are facing such a prblm then y cant u disable the VBA option? On Wed, Aug 4, 2010 at 10:43 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, I never use Ctrl+Space. Didn't know about it. When the list of names appears, just select the one you want by double-clicking on it Regards - Dave. Date: Tue, 3 Aug 2010 15:49:18 -0700 Subject: $$Excel-Macros$$ Ctrl + space bar From: moor...@ldschurch.org To: excel-macros@googlegroups.com CC: moor...@ldschurch.org I am in the very infancy of learning VBA and a couple of sources that I am using to learn it both refer to the Visual Basic IDE which provides an auto-complete feature for all the names used in Excel VBA. I am told to type only the first few characters to get the name I want and then press Ctrl+Spacebar to activate the auto-complete list of all names that begin with those characters. However, I have a problem. When I try this and press Ctrl+Spacebar I get connected to Google. Some programer, somewhere in my large organization has apparently absconded Ctrl+Spacebar to directly connect with Google. That being the case how can I find a way to set up my one short-cut to connect with the VBA auto-complete feature? -- -- 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
$$Excel-Macros$$ Re: Need to sum if data is in another cell
Nadine S wrote: I have a worosheet with cokumns for 20+ payments. Please, if you want to get help from others, make sure that your posting is not full of typos. It makes reading quite hard. These columns track the date it was entered for payment, amount, check date, record number for each of the 20+ columns. Just out of curiousity: How many columns arel you going to insert into the worksheet? Is there any limit? You should note that Excel 2003 and older can only cope with 255 columns. In another sheet, I want to sum the amount entered and the amount paid by line. Meaning, row 2 on sheet 1 ties to row 2 on sheet 2 so I don't need to do lookups or sumif type. At least I don't think so. :) So, I have a formula that sums all the amounts entered but now I need one to sum the amounts is there is a check date and record number. I don't quite get what you want to achieve (sorry, but your English is not so good). I guess that what you wanted to say is that you want to get the sum of all payments that have their Check Date field set. If so, you can use the following formula for cell Amount Paid: =SUM(IF(Sheet1!ZS(1)0,Sheet1!ZS,0),IF(Sheet1!ZS(6)0,Sheet1!ZS(5), 0),IF(Sheet1!ZS(11)0,Sheet1!ZS(10),0),IF(Sheet1!ZS(16)0,Sheet1! ZS(15),0),IF(Sheet1!ZS(21)0,Sheet1!ZS(20),0)) Note that this works only for the currently defined columns. If you add more columns, you'll have to edit formulas for Amount Entered and Amount Paid. As there is a limit to the length of a formula, you may get in trouble even before you run out of columns. I've attached a file as a sample that I think will help you to understand. Thanks for everyone's help. It looks to me as if your workbook should be able to handle lots of rows (which probably stand for some client) and lots of payments. In that case you'll get sooner of later into trouble if you want to get all data into a single sheet. You can get around this if you (a) use Excel 2010, or (b) use a simple database, for example Access. The later has the benefit that more than one user can enter data. Regards, Stuart -- -- 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$$ Need to sum if data is in another cell
Hi, Hope attached is the required solution Regards, Saurabh Patel _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Nadine S Sent: Wednesday, August 04, 2010 3:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need to sum if data is in another cell I have a worosheet with cokumns for 20+ payments. These columns track the date it was entered for payment, amount, check date, record number for each of the 20+ columns. In another sheet, I want to sum the amount entered and the amount paid by line. Meaning, row 2 on sheet 1 ties to row 2 on sheet 2 so I don't need to do lookups or sumif type. At least I don't think so. :) So, I have a formula that sums all the amounts entered but now I need one to sum the amounts is there is a check date and record number. I've attached a file as a sample that I think will help you to understand. Thanks for everyone's help. -- -- 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 Need amount paid_Sol.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Macro for tracing the changes
Thanks stuart for ur reply, but, macro record is work for when u r using same type of command again and again, but this time issue is different On Wed, Aug 4, 2010 at 11:10 AM, Stuart Redmann dertop...@web.de wrote: sudhir kumar wrote: hi friend, i attached an excel file, which having some information in it, now i want that if i will do any type of change in it, i will be able to trace it, means, i change in some of the column or row, or i introduce any new row ,or delete any row. every type of change i want to trace., Why don't you just turn on the macro recorder? This component pretty much saves a playback of all the actions the user does. The recorded macro can be used to generate a log file. I can't think of any other way. Regards, Stuart -- -- 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 -- Regards- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@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 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$$ Help Required Extract Numbers
Hi, Solution for your query will be available in the below link. http://www.ozgrid.com/VBA/ExtractNum.htm On Wed, Aug 4, 2010 at 3:26 PM, Venkatesan c venkat1@gmail.com wrote: Dear Group, Find Below data Requirement.I Want to extract numbers post (_ )Only. Raw Data Required Best Regards, Venkat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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 -- Regards, praveen -- -- 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$$ Re: Need to sum if data is in another cell
Stuart, first let me thank you for your email. In response to your comment of my few misspellings, let me apologize for my hurried email and therefore lack of running spell check. According to Brain Connection, proficient readers read most words (except very long ones) principally through the first and last letters and a rapid recognition of the general shape and content of the entire word. That's why we typically read misspelled words with no trouble. My misspellings didn't seem so outrageous to me but maybe that's just me. In regards to, How many columns arel you going to insert into the worksheet? I'm assuming that your word arel is supposed to be are. With that assumption, the answer is I don't know. As many as needed would have to be my best guess at this point. Currently there are 21 but that may need to increase in time or possibly even decrease. Basically I just don't know. I don't have the option of using Excel 2010, only Excel 2003. As for a database, etc, yes, that's the better way to go but, once again, that is not an option. I need to make this work with the only tool I have which is Excel 2003. Your assumption that this is to handle lots of rows is correct, however, I don't understand what you mean when you said, (which probably stand for some client). To clarify for you and everyone else what I need: I have one worksheet (sheet1) that lists 4 fields of data for each payment (20+ payments) across the top of the worksheet. To the left of this is specific row information that is linked to those same places (rows and columns) on sheet2. What I need to show on sheet 2 in column B is the amount that has been entered for payment for the corresponding row on sheet 1. I've done this with a formula that sums all the amounts in sheet 1 in the cells titled Amount in the corresponding row on sheet 2 . What I need help with is a writing a formula that will then sum all the amounts in the corresponding row on sheet 1 where a check date and/or record # are recorded next to the amount. Once again, I've attached my original file. The formula I need will be placed on sheet 2 column C. So for the first row containing data on sheet 1 (row2) the total paid would be $1000+$500+$450 for a total formula result of $1950. I hope my English is good enough for everyone to understand what it is I need. Once again, I apologize for my apparently outrageously poor English. Thank you all who are willing to take the time to attempt a solution for me. I truly appreciate all the help I receive from this group. Unfortunately when I put Stuart's formula into cell C2 on sheet 2, I get #NAME? as the result and not $1950. Thanks all. From: Stuart Redmann dertop...@web.de To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wed, August 4, 2010 6:35:31 AM Subject: $$Excel-Macros$$ Re: Need to sum if data is in another cell Nadine S wrote: I have a worosheet with cokumns for 20+ payments. Please, if you want to get help from others, make sure that your posting is not full of typos. It makes reading quite hard. These columns track the date it was entered for payment, amount, check date, record number for each of the 20+ columns. Just out of curiousity: How many columns arel you going to insert into the worksheet? Is there any limit? You should note that Excel 2003 and older can only cope with 255 columns. In another sheet, I want to sum the amount entered and the amount paid by line. Meaning, row 2 on sheet 1 ties to row 2 on sheet 2 so I don't need to do lookups or sumif type. At least I don't think so. :) So, I have a formula that sums all the amounts entered but now I need one to sum the amounts is there is a check date and record number. I don't quite get what you want to achieve (sorry, but your English is not so good). I guess that what you wanted to say is that you want to get the sum of all payments that have their Check Date field set. If so, you can use the following formula for cell Amount Paid: =SUM(IF(Sheet1!ZS(1)0,Sheet1!ZS,0),IF(Sheet1!ZS(6)0,Sheet1!ZS(5), 0),IF(Sheet1!ZS(11)0,Sheet1!ZS(10),0),IF(Sheet1!ZS(16)0,Sheet1! ZS(15),0),IF(Sheet1!ZS(21)0,Sheet1!ZS(20),0)) Note that this works only for the currently defined columns. If you add more columns, you'll have to edit formulas for Amount Entered and Amount Paid. As there is a limit to the length of a formula, you may get in trouble even before you run out of columns. I've attached a file as a sample that I think will help you to understand. Thanks for everyone's help. It looks to me as if your workbook should be able to handle lots of rows (which probably stand for some client) and lots of payments. In that case you'll get sooner of later into trouble if you want to get all data into a single sheet. You can get around this if you (a) use Excel 2010, or (b) use a simple database, for example Access. The later has the benefit that
Re: $$Excel-Macros$$ Urgent: Help required in VBA form
Hi Dav, First of all congrats, I request you to pls help me in this problem, my whok project n promotion is now only depands on this. I m waitinig for your reply. Regards Pankaj k Pandey On 8/4/10, Intelligent But Crazy secrets...@gmail.com wrote: My Apologiese Pls find the Password details. For Workbook: bads...@143 For VBA Editor : bads...@143 For Worksheets : SecretShot For Mastersheet : SecretShot Pls help me in this. Thanks Pankaj k Pandey On 8/3/10, Intelligent But Crazy secrets...@gmail.com wrote: Hi group, My self pankaj, currentally I m working on a project, I have created a Excel VBA form for quality analysis, but i m facing a problem that when the VBA form is open in this Excel so i m unable to activate any onather Excel file. Pls help me in this only because of this my whole project will be useless. Excel file is attech for refarence. Thanks Pankaj k Pandey -- -- 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 -- Pankaj Pandey Bhopal -- Pankaj Pandey Bhopal -- -- 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$$ Address Book Problem
Merge the Male Female sheet. And fill the empty cell will correct values for *Cat'y* *Pincode* *Area* And use Pivot tabale for getting subset of the search critiria. if you don't know the Pivot table, please search in net explore yourself. thanks Srinivasan Ethirajalu On 8/4/10, Maries talk2mar...@gmail.com wrote: Find the attached file. Rgds,Maries On Wed, Aug 4, 2010 at 3:57 PM, Nikhil Shah nikhil201...@gmail.comwrote: Dear Friend, O.K. Half Problem is Resolved. Columns Add_1 ; Add_2 ; Add_3 ; Tele( c ) ; Tele ( r ) and mobile No. - all are empty ex. ... in above case, I want all the four names at once as I select Area Navrangpura and the category Female with all related columns filled. For Pl see Main menu.. Regards, Nikhil On Wed, Aug 4, 2010 at 4:49 PM, Maries talk2mar...@gmail.com wrote: Dear Mr.Nikhil, Find the attached file... I hope that, this file will fulfill your requirements... Regards, Marieswaran On Wed, Aug 4, 2010 at 11:15 AM, Nikhil Shah nikhil201...@gmail.comwrote: Hi Dave Recd your E-mail.. Thanks for sending excel sheet.. but still there is something missing to Address - Excel sheet, there is an error in Main sheet.. Error... Suppose I select Area : Navrangpura Category is Female, then, here you can see that only one the same name of Female Doctor is coming repeatedly and other columns are empty, You can see that in the Doc - Famale Sheet , there are total four Doctors in the selected area with information in other columns: So, actually I want to get all the cells of the selected data, ex. ... in above case, I want all the four names at once as I select Area Navrangpura and the category Female with all related columns filled. I am sending once again my address book - Excel sheet for your ref. pl help me out of this query.. Regards Nikhil On Wed, Aug 4, 2010 at 4:56 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi, Please have a look at the attached. Regards - Dave. -- Date: Mon, 2 Aug 2010 17:45:28 +0530 Subject: $$Excel-Macros$$ Address Book Problem From: nikhil201...@gmail.com To: excel-macros@googlegroups.com Dear All Members, Here i am sending One Address Book - Excel Sheet.It contains ( 1 ) Main Menu ( 2 ) Doc - Male Data ( 3 ) Doc - Female Date. Address Execution Mode :- On Main Menu First I Select Area , Then I Select Category through Pop up list.. Now coming to query, ( 1 ). Suppose I select Category : Male... , then All Data should come From Doc - Male Database Female , then All Data Should come From Doc - Female Database. Pl help me out for my query, as you can see it is Huge Database..it is being updated regularly.. Awaiting Reply Nikhil Shah -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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
Re: $$Excel-Macros$$ Macro to clean up file
Need macro to get file output to look like tab 3 whether the input file looks like tab 1 or tab 2. What I think needs to happen is look for the column headers in the file and if they are there copy the entire column and paste to new tab, if they are not create just the column header and paste that and move on to the next column. Any help with a macro that would do that would be greatly appreciated. *Joel* -- -- 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 example file.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need Help
Hi All, Please help. Thanks, Prabhakar Thakur New Delhi +919953736776 On Wed, Aug 4, 2010 at 10:49 PM, prabhakar thakur prabhakarthak...@gmail.com wrote: Dear Group, I need help to a month year wise report, I made a povit but couldn't get correct report. -- Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- 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$$ Need Help
Hi I have responded to your email sent before pl chk and see if this is what u wanted Regards, Andy On Thu, Aug 5, 2010 at 9:48 AM, prabhakar thakur prabhakarthak...@gmail.com wrote: Hi All, Please help. Thanks, Prabhakar Thakur New Delhi +919953736776 On Wed, Aug 4, 2010 at 10:49 PM, prabhakar thakur prabhakarthak...@gmail.com wrote: Dear Group, I need help to a month year wise report, I made a povit but couldn't get correct report. -- Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- 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$$
Sorry got your name wrong On Thu, Aug 5, 2010 at 10:22 AM, Aindril De aind...@gmail.com wrote: Hi Prabhat, This is happening because the column date contains actual dates and not months. However I have added a column called month, which takes care of the issue. PFA the solution Its in Sheet6. Regards, Aindril On Wed, Aug 4, 2010 at 10:49 PM, prabhakar thakur prabhakarthak...@gmail.com wrote: Dear Group, I need help to a month year wise report, I made a povit but month repate again again. -- Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- 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$$
Dear Aindril, Thanks for help but not get accurate result, date is different month but in this formula only calculate jan-09 jan-10 for all month. Thanks, Prabhakar Thakur New Delhi +919953736776 On Thu, Aug 5, 2010 at 10:22 AM, Aindril De aind...@gmail.com wrote: Hi Prabhat, This is happening because the column date contains actual dates and not months. However I have added a column called month, which takes care of the issue. PFA the solution Its in Sheet6. Regards, Aindril On Wed, Aug 4, 2010 at 10:49 PM, prabhakar thakur prabhakarthak...@gmail.com wrote: Dear Group, I need help to a month year wise report, I made a povit but month repate again again. -- Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- 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