RE: $$Excel-Macros$$

You're welcome. Dave. Date: Mon, 2 Aug 2010 10:56:18 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ To: excel-macros@googlegroups.com Dave, Thank you so much. This works! You don't know how thankful I am. I needed that peice before I could move forward with a wor

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

Hi Ayush, My pleasure. Dave. > Date: Sat, 31 Jul 2010 01:59:16 -0700 > Subject: $$Excel-Macros$$ Thank you Dave Bonallack !! > From: jainayus...@gmail.com > To: excel-macros@googlegroups.com > > Dear Group, > > In the recent group survey conducted, I asked one question that "How > the top po

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

I Second that Ayush...Dave Rocks.Cheers Warm Regards, Harmeet Singh IT Analyst McKinsey & Company http://www.facebook.com/Harmeeet On Sat, Jul 31, 2010 at 2:29 PM, Ayush wrote: > Dear Group, > > In the recent group survey conducted, I asked one question that "How > the top po

RE: $$Excel-Macros$$ Use a Variable to Define an Offset's Value

Hi Jess, The code line you've given looks ok. Perhaps you should post a copy of the whole macro, and tell us what "I can't make it work" actually means. The best thing would be to attach a copy of your workbook, or a sample at least. Regards - Dave. > Date: Mon, 2 Aug 2010 13:31:27 -0700 > S

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

Too kind Harmet. Dave. From: harmeet.hew...@gmail.com Date: Tue, 3 Aug 2010 14:46:02 +0530 Subject: Re: $$Excel-Macros$$ Thank you Dave Bonallack !! To: excel-macros@googlegroups.com I Second that Ayush...Dave Rocks.Cheers Warm Regards, Harmeet Singh IT Analyst McKinsey &

RE: $$Excel-Macros$$ Sumproduct with 3 criteria +

Hi Nadine, I'm guessing a bit. "What I need is a total of the result of that" I assume this means the result of your SumProduct formula "plus the same if it = $R$2 and if it = $R$1" I assume that if the result of the SumProduct formula = R2 AND = R3, then you want the result of the Sum

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

Congrats Dave! and Thank You for being kind enough for solving almost all problems for us. We feel 'saved' having you here. Keep up the good work. Kind regards, AJ On Tue, Aug 3, 2010 at 2:50 PM, Dave Bonallack wrote: > Too kind Harmet. > Dave. > > -- > From: harme

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

Does someone else know how to do this please! 2010/8/3 Dave Bonallack > 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 n

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

Also will like to thanks Ayush for initiating survey & than actioning on suggestions provided by others , though am not the active member but this group has helped me a lot. - Nayan From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Harmeet Singh Sent: 03 A

Re: $$Excel-Macros$$ Create macro to reformat spreadsheet for importing

Vasant, Thanks for the help. I can play around with this macro and do everything I need. Also do you know can you run a macro from a different spreadsheet? I'm going to be getting a spreadsheet every few weeks and will need to run this macro against the spreadsheet. I don't want the users to im

Re: $$Excel-Macros$$ Sumproduct with 3 criteria +

Let me try this again. Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F, G, and H.  If those all match then I need to check if column AH in Sheet 1 matches either R2, R1 or R4 in Sheet 2.  If so, then I need to sum column X in Sheet 1.  The result needs to show on Shee

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

Hi Nikhil, Its done however i am not getting the option to upload a file into discussion. I have uploaded the file in http://groups.google.com/group/excel-macros/files with Nikhil+-+Address +Book.xls Have a look Neeraj Lamba --

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

Hi dave, good work.. Guys , continue ur wishes to dave On 8/3/10, Nayan K Lodaya wrote: > Also will like to thanks Ayush for initiating survey & than actioning on > suggestions provided by others , though am not the active member but this > group has helped me a lot. > > - Nayan > > From: e

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

Dear Neeraj Excellent Work Sheet. Yes this result I want.. Thanks Regards Nikhil Shah On Tue, Aug 3, 2010 at 6:18 PM, Neeraj Lamba wrote: > Hi Nikhil, > Its done however i am not getting the option to upload a file into > discussion. I have uploaded the file in > http://groups.google.com

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

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 wrote: > Dear Group, >

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

Hey Pankaj, The File is password protected, provide password to unlock and get the required. Group is waiting On Tue, Aug 3, 2010 at 7:13 PM, Intelligent But Crazy wrote: > Hi group, > > My self pankaj, > currentally I m working on a project, I have created

$$Excel-Macros$$ Ctrl + space bar

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+Sp

$$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

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

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 Craz

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

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@googlegr

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

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...!! -- T

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

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 wrote: > Thanks Dilip. > Dave. > > -- > Date: Tue, 3 Aug 2010 20:43:16

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

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 chan

$$Excel-Macros$$ Excel VBA job opening

We are looking for VBA Excel developer for a MNC for their Gurgaon office. Knowledge of SQL would be an advantage. Minimum Exp: 2 years. Send your resume to gauravhpah...@gmail.com latest by 10/8/2010. Salary package would be best in industry. -- --