Dear sir,
It's working perfect. Thanks a lot 😊
-Original Message-
From: "Mandeep Baluja"
Sent: ‎11-‎07-‎2015 11:36 PM
To: "excel-macros@googlegroups.com"
Subject: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT
Check this attachment :!
Check this attachment :!
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
On Friday, July 10, 2015 at 7:46:59 AM UTC+5:30, pappu wrote:
>
-Original Message-
From: "KANNAN V"
Sent: ‎11-‎07-‎2015 09:26 AM
To: "KANNAN V" ; "vt_kan...@camsonline.com"
Subject: RE: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT
Hi Bro,
Really thanks for your effect, but its not working. Pls
Code Changed !! Try this Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
> Sub Createdata()
>
> Lc = Sheets("Sheet3").Cells(Rows.Count,
Bro,
Its not standard for 5rows. It's depends on requirement. And I wrongly raised
my query. Sorry.
-Original Message-
From: "Mandeep Baluja"
Sent: ‎10-‎07-‎2015 02:48 PM
To: "excel-macros@googlegroups.com"
Subject: Re: $$Excel-Macros$$ Re: FW: Automa
: ‎10-‎07-‎2015 01:44 PM
> To: excel-...@googlegroups.com
> Subject: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT
>
> Regards, Mandeep Baluja
>
> Run this code output will receive in sheet2 and the criteria to get the
> result is pasted in sheet3.
>
>
Than of ur reply Bro, I am using excel 2010. In my company mail, ur attachment
has not open. It's showing 'the file is corrupt and cannot opened'.
-Original Message-
From: "Mandeep Baluja"
Sent: ‎10-‎07-‎2015 01:44 PM
To: "excel-macros@googlegroups.com&
Regards, Mandeep Baluja
Run this code output will receive in sheet2 and the criteria to get the
result is pasted in sheet3.
Sub Createdata()
Lc = Sheets("Sheet3").Cells(Rows.Count, 1).End(xlUp).Row
Sheets("Sheet2").Cells.ClearContents
a = 5
b = 5
For a1 = 2 To Lc
v = Split(Sheets("Shee
.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of pankaj khairanar
Sent: 18 June 2014 19:55
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: FW: Auto update Data, Row & Columns
Hi
Can you please share more details
Hi
Can you please share more details? it couldent be possible for any one to
provide you correct macro without understanding the proper requirement.
Regards,
Pankaj
On Wednesday, June 18, 2014 2:08:42 PM UTC+5:30, Raj wrote:
> Dear Experts,
>
>
>
> Is there any chance.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Lalit Mohan Pandey
Sent: Thursday, August 29, 2013 2:10 PM
To: excel-macros@googlegroups.com
Cc: vatspoojav...@gmail.com
Subject: $$Excel-Macros$$ Re: Fw: Query on Text to Columns function
Try this
Option
Try this
Option Explicit
Sub SplitValues()
Dim lngLoop As Long
Dim vararrRawData() As Variant
Dim vararrSplitData As Variant
'Const variable change accordingly as per your requirement
Const strDataRangeToSplit As String = "C1:C65536"
Const s
HI Prashant,
i think google will be the best place for your question.there you may get
lots of description regarding your question.
regards
prince
On Tuesday, January 8, 2013 10:18:41 PM UTC+5:30, prashant shinde wrote:
>
>
>
>
> Sent from Samsung Mobile
>
>
> Original message ---
Hi Prashant,
I guess it is not the best practice to have the same identifier name for a
variable that going to be used locally and globally.But if you still want
have the same situation please use any of the example shared by Lalit Or
Paul.
Bu i will avoid this situation as this way of coding
Hi Prashant,
You can do it in this way but it is not a good practice
*Dim intValueAs Integer*
*
*
*Sub Test()*
*
*
*Dim intValueAs Integer*
**
*intValue = 10*
*
*
*End Sub*
*
*
*Sub AssignValueToGlobalVariable(ByVal intParameter As Integer)*
*
*
*
Hi Prashant,
Can you explain why you take same name variable in Public and Private scope.
Regards,
Lalit Mohan
On Thursday, 3 January 2013 23:15:17 UTC+5:30, prashant shinde wrote:
>
>
>
>
> Original message
> Subject: Conflict between Local and Global variable
> From: "Shinde,
Hi Sandeep,
Can you please share ur workbook so that i can understand your problem.
Regards
Prince
On Thursday, December 13, 2012 10:13:29 PM UTC+5:30, sandeep chhajer wrote:
>
> Dear excel guru is there any way to make data validation effective in case
> the source data is copied from other so
Thanks guys for your support.
I have banned that user.
Regards
Ayush Jain
On Friday, 8 June 2012 21:50:25 UTC+5:30, sandeep chhajer wrote:
> Hi Ayush, Noorain and all mentor,
>
> You all are the best mind in the field of Information Technology. So
> please do needful to stop this type of cro
;
excel-macros@googlegroups.com;
willy_n...@rediffmail.com;
govindke...@gmail.com;
harpreetguj...@gmail.com;
harpreetsinghguj...@hsbc.co.in;
intermediatec...@googlemail.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ RE: FW: hi there...
Thanks to Bed Defense! They saved my
At any rate it is advertising unrelated to the group.
Date: Fri, 8 Jun 2012 21:47:27 +0530
Subject: Re: $$Excel-Macros$$ RE: FW: hi there...
From: mangesh.da...@gmail.com
To: excel-macros@googlegroups.com
Yes, sure and please think on it how to protect this group from such spams.
Mangesh
On
t;
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* 08 June 2012 9:27
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ RE: FW: hi there...
>
> ** **
>
> Please po
It's a spam I think
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 08 June 2012 9:27
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ RE: FW: hi
Please post ur query
On Fri, Jun 8, 2012 at 9:18 PM, OfficeVba Trainer <
officevbatrai...@yahoo.com> wrote:
> Thanks to Bed Defense! They saved my sister and I from our buildings
> bedbug infestation!!
> http://socjologia.c0.pl/lastnews/94RichardAlien/
>
> --
> FORUM RULES (986+ members already B
Hi
Your formula in N168 would be
=COUNTIFS(Attendance!$E$4:$E$98,'Summary
Sheet'!$M168,Attendance!$C$4:$C$98,'Summary
Sheet'!N$167,INDEX(Attendance!$G$4:$AK$98,,MATCH($N$166,Attendance!$G$3:$AK$3)),"P")
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ayush
Sent: Sunday, December 19, 2010 5:28 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: FW: AUTOFILTER
Hi Kemas,
It is referring to second filter of the Active sheet. It is not necessary to
be the
Hi Kemas,
It is referring to second filter of the Active sheet. It is not necessary to
be the second column of the sheet.
Let us know if you have any further questions.
Thanks.
Best Regards,
Ayush
--
--
Some impor
Hi Umesh,
Attached file has the solution which you are looking for. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/24/09, Umesh Gupta 3 wrote:
>
> sorry not Sorting when filter select
> -
*Cc:* excel-macros@googlegroups.com
> *Sent:* 19 September, 2009 3:32 PM
> *Subject:* $$Excel-Macros$$ Re: Fw: Add Row
>
> *Hi Umesh.*
>
> Don't know how I missed this out.
> Sorrry for that, attached file has the solution you desire. Thanks.
>
> --
> DILIP KUMAR PANDEY
*Hi Umesh.*
Don't know how I missed this out.
Sorrry for that, attached file has the solution you desire. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/6/09, Home 2 wrote:
>
>
> - Original
Hi William,
I have included your both the examples in the solved workbook and attached
that with this email. Please have a look.
Further to this, what I have understood as per your query is "there are some
numbers which will be generated randomly and at the end will be followed by
some Zeros".. h
Hi William,
Apologies for the delay.
Please find the attached solution.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Sun, Aug 23, 2009 at 2:50 AM, William wrote:
>
> - Original Message -
31 matches
Mail list logo
