Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread NOORAIN ANSARI
Congrats Paul Sir, Really, You are milestone of Excel-Macro Group, i followed you from last 4 years and learn a lots of new things from your expertise. I salute your deep and awesome knowledge in MS Excel. We are so lucky because you are attached with this group. Please keep to sharing your valu

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread Aamir Shahzad
well done & congrates Paul. Aamir Shahzad On Tue, Dec 4, 2012 at 11:11 AM, Rakesh Kumar Sharma wrote: > Hi Paul, > > Congratulations... > > > On Tue, Dec 4, 2012 at 10:33 AM, Satendra kumar > wrote: > >> Hi Paul, >> >> >> congratulations... >> >> >> On Tue, Dec 4, 2012 at 10:31 AM,

Re: $$Excel-Macros$$ Re: Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread अनिल नारायण गवली
congrats dear. Regards, Gawli Anil On Tue, Dec 4, 2012 at 12:00 PM, Rajan_Verma wrote: > Heartly Congrats Paul :) > > > On Monday, 3 December 2012 23:58:06 UTC+5:30, Ayush Jain wrote: >> >> Dear members, >> >> Paul Schreiner has been selected as 'Most Helpful Member' for the month >> of Nov'12.

$$Excel-Macros$$ Re: Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread Rajan_Verma
Heartly Congrats Paul :) On Monday, 3 December 2012 23:58:06 UTC+5:30, Ayush Jain wrote: > > Dear members, > > Paul Schreiner has been selected as 'Most Helpful Member' for the month of > Nov'12. He has posted 52 posts last month and helped forum members through > his excel expertise. > I tru

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread Rakesh Kumar Sharma
Hi Paul, Congratulations... On Tue, Dec 4, 2012 at 10:33 AM, Satendra kumar wrote: > Hi Paul, > > > congratulations... > > > On Tue, Dec 4, 2012 at 10:31 AM, Pravin Gunjal wrote: > >> *Dear Paul,* >> *Hearty congratulations on your achievement.* >> * >> * >> *Regards* >> *Pravin Gu

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread Satendra kumar
Hi Paul, congratulations... On Tue, Dec 4, 2012 at 10:31 AM, Pravin Gunjal wrote: > *Dear Paul,* > *Hearty congratulations on your achievement.* > * > * > *Regards* > *Pravin Gunjal* > > -- Forwarded message -- > From: Ayush Jain > Date: Mon, Dec 3, 2012 at 11:58 P

$$Excel-Macros$$ Average from different sheets except blank data

2012-12-03 Thread Pravin Gunjal
*Not understood.* -- Forwarded message -- From: ashish koul Date: Mon, Dec 3, 2012 at 11:02 PM Subject: Re: $$Excel-Macros$$ Average from different sheets except blank data To: excel-macros@googlegroups.com try something like this instead of J take some other column which you t

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread Karan Singh
Congrats buddy! :) Karan Singh On Tue, Dec 4, 2012 at 8:59 AM, wrote: > ** > Congrats paul... > Sent from my BlackBerry® smartphone from !DEA > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Mon, 3 Dec 2012 23:58:06 +0530 > *To: *

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread p . dhamsaiya
Congrats paul... Sent from my BlackBerry® smartphone from !DEA -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member

$$Excel-Macros$$ Re: Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread Prince
Congrats Paul Regards Prince On Monday, December 3, 2012 11:58:06 PM UTC+5:30, Ayush Jain wrote: > Dear members, > > Paul Schreiner has been selected as 'Most Helpful Member' for the month of > Nov'12. He has posted 52 posts last month and helped forum members through > his excel expertise.

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread vba
Hey Paul, Congratulations ... Sent on my BlackBerry® from Vodafone -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Paul Schreiner - Most Helpful

$$Excel-Macros$$ Excel Macro

2012-12-03 Thread AR
Hi Frnds, Can anybody tell me , whether is it possible to document a process by recording the process using macro. For example .. i am having 2 excel files .. i am copying data from one to another and using the necessary formulas i am preparing the report say P&L.. i need to document these steps

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 *

2012-12-03 Thread pawel lupinski
Paul - congratulation !!! Pawel From: "resp...@gmail.com" To: excel-macros@googlegroups.com Sent: Monday, December 3, 2012 9:55 PM Subject: Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 * I couldn't agree more. Thumbs up Paul. Great

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 *

2012-12-03 Thread respuzy
I couldn't agree more. Thumbs up Paul. Great to be associated with you. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 To: excel-macros Reply-To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ lookup based on multiple dates.

2012-12-03 Thread Ms Excel user
Hi, please see the attachment. On Mon, Dec 3, 2012 at 8:10 PM, AK wrote: > Hi All, > > I have a question, looking for solution through formula (but VBA is fine > if not possible through formula :) )...I have 2 sheets in a workbook i.e > "Cust data" and "Review"... > > > In the Cust data s

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread Kuldeep Singh
Hi, Congratulations Paul. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-120-4763789, Extn.: 789,9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Dec 3, 2012 at 11:

Re: $$Excel-Macros$$ Average from different sheets except blank data

2012-12-03 Thread ashish koul
try something like this instead of J take some other column which you think is mandatory to fill SUM(April:March!H26)/COUNT(April:March!J4) On Mon, Dec 3, 2012 at 10:04 AM, Pravin Gunjal wrote: > *Hello,* > *Can anybody help me to get the solution. Thanks.* > * > * > *Regards / Pravin > * >

Re: $$Excel-Macros$$

2012-12-03 Thread ashish koul
Hi I am not using lotus notes now so can't test it but i would suggest for any lotus notes related queries try IBM's own forum https://www.ibm.com/developerworks/lotus/community/ Regards Ashish On Mon, Dec 3, 2012 at 11:46 AM, Prashant Pawle wrote: > Dear Team, > > I am trying to use below cod

Re: $$Excel-Macros$$ lookup based on multiple dates.

2012-12-03 Thread ashish koul
Try something like this COUNTIFS(Review!A:A,'Cust data'!A2,Review!B:B,">=#"&'Cust data'!B2&"#",Review!B:B,"<=#"&'Cust data'!C2&"#") On Mon, Dec 3, 2012 at 8:10 PM, AK wrote: > Hi All, > > I have a question, looking for solution through formula (but VBA is fine > if not possible through formul

$$Excel-Macros$$ lookup based on multiple dates.

2012-12-03 Thread AK
Hi All, I have a question, looking for solution through formula (but VBA is fine if not possible through formula :) )...I have 2 sheets in a workbook i.e "Cust data" and "Review"... In the Cust data sheet I have start date of the project i.e column B, column C is First review date and Column D i

Re: $$Excel-Macros$$ Insert Multiple mails as icons into excel

2012-12-03 Thread Shaik Waheed
Hi Ashish, Thanks for the reply, I have used the below code to get the selected mails in the excel as icons. Please check it out and give any suggestion if we can make it better Sub Macro1() ' ' Macro1 Macro ' Dim path As String Dim lf As New Collection 'Dim ab As String ab = Application.GetOpenF

$$Excel-Macros$$ Re: Excel & Google Map Integration

2012-12-03 Thread Prince
Thanks Ashish for sharing such a nice stuff. Regards Prince On Sunday, December 2, 2012 9:22:41 AM UTC+5:30, ashish wrote: > > Hi Group, > > If anybody wants to create Google Geo Charts in Excel visit below links > and download the working files to try them. > > To know more about Google Charts

Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS

2012-12-03 Thread Amit Gandhi
Hi Experts Pls help me on below. Regards Amit On Sat, Dec 1, 2012 at 11:40 AM, Amit Gandhi wrote: > Hi Paul > > This is not working. I am trying to elaborate more step by step what I > required. > > Step 1. Macro will check in sheet *"TT",* column A (A6 onwards) with * > "TTlist"* for values