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 silkyro...@gmail.com 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*

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

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 =

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

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 exce...@gmail.com wrote: Hi All, I have a question, looking for solution through formula (but VBA is fine if not possible through

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 ppawle.ex...@gmail.comwrote: Dear Team, I am

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 isk1...@gmail.com wrote: *Hello,* *Can anybody help me to get the solution. Thanks.* * * *Regards /

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

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 exce...@gmail.com 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

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 jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 To:

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

2012-12-03 Thread pawel lupinski
Paul - congratulation !!! Pawel From: resp...@gmail.com 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

$$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 PL.. i need to document these steps

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 jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

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

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 jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject:

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, p.dhamsa...@gmail.com wrote: ** Congrats paul... Sent from my BlackBerry® smartphone from !DEA -- *From: * Ayush Jain jainayus...@gmail.com *Sender: * excel-macros@googlegroups.com *Date:

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

2012-12-03 Thread Pravin Gunjal
*Not understood.* -- Forwarded message -- From: ashish koul koul.ash...@gmail.com 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

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 isk1...@gmail.com wrote: *Dear Paul,* *Hearty congratulations on your achievement.* * * *Regards* *Pravin Gunjal* -- Forwarded message -- From: Ayush Jain jainayus...@gmail.com

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 satendrakuma...@gmail.comwrote: Hi Paul, congratulations... On Tue, Dec 4, 2012 at 10:31 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Paul,* *Hearty congratulations on your achievement.* * *

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

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 rajanverma1...@gmail.comwrote: 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

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 rakeshks@gmail.com wrote: Hi Paul, Congratulations... On Tue, Dec 4, 2012 at 10:33 AM, Satendra kumar satendrakuma...@gmail.com wrote: Hi Paul, congratulations... On

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