Re: $$Excel-Macros$$ Thank you Dave Bonallack !!

2010-08-04 Thread Vasant
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..

Re: $$Excel-Macros$$ Thank you Dave Bonallack !!

2010-08-04 Thread gaurav pahuja
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

$$Excel-Macros$$ Help Required Extract Numbers

2010-08-04 Thread Venkatesan c
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

RE: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

2010-08-04 Thread Dave Bonallack
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:

Re: $$Excel-Macros$$ Address Book Problem

2010-08-04 Thread Maries
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

Re: $$Excel-Macros$$ Address Book Problem

2010-08-04 Thread Nikhil Shah
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

Re: $$Excel-Macros$$ Ctrl + space bar

2010-08-04 Thread Suryaprasad
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

$$Excel-Macros$$ Re: Need to sum if data is in another cell

2010-08-04 Thread Stuart Redmann
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

RE: $$Excel-Macros$$ Need to sum if data is in another cell

2010-08-04 Thread Saurabh Patel
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

Re: $$Excel-Macros$$ Re: Macro for tracing the changes

2010-08-04 Thread sudhir kumar
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

Re: $$Excel-Macros$$ Help Required Extract Numbers

2010-08-04 Thread praveen kumar
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

Re: $$Excel-Macros$$ Re: Need to sum if data is in another cell

2010-08-04 Thread Nadine S
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

Re: $$Excel-Macros$$ Urgent: Help required in VBA form

2010-08-04 Thread Intelligent But Crazy
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

Re: $$Excel-Macros$$ Address Book Problem

2010-08-04 Thread Srinivasan Ethirajalu
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

Re: $$Excel-Macros$$ Macro to clean up file

2010-08-04 Thread Joel Dawson
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

$$Excel-Macros$$ Need Help

2010-08-04 Thread prabhakar thakur
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

Re: $$Excel-Macros$$ Need Help

2010-08-04 Thread Aindril De
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,

Re: $$Excel-Macros$$

2010-08-04 Thread Aindril De
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

Re: $$Excel-Macros$$

2010-08-04 Thread prabhakar thakur
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