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
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
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
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
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 &
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
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
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
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
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
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
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
--
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
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
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,
>
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
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
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
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
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
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
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
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
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.
--
--
24 matches
Mail list logo