Hi Sandeep,
I have a code, which simply goes to specific folder & open the workbooks
one by one & copy the data and paste them in same sheet (Where the marcro
is written).
** Make sure all the files have same header, because it copies all the data
including the header.
So if this is relevant,
Hi,Any way to solve this problem.
k01v 2 B SIP STEP - 1
From: KANNAN V
Sent: 11-07-2015 08:23 AM
To: vt_kan...@camsonline.com
Subject: FW: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT
From: Mandeep Baluja
Sent: 10-07-2015 05:39 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: FW
Dear Ashish,
Thanks a lot for your help...this one is very closed to what we needed...
Need to make some alteration;
1) We will need if Say bar for A is of 10 mm large, bar for B should be
say 6 mm ( inside the A bar) bar for C should be say 3-4 mm ( inside the B
bar).
2) What I
Hi,
Check this!!
Final shot from my side.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart
Hi,
Check this!!
Final shot from my side.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
@googlegroups.com] *On Behalf Of *Ashish Kumar
*Sent:* Wednesday, September 24, 2014 8:11 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: FW: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart
Hi,
Check this!!
Final shot from my side.
Regards
Ashish
--
Are you =EXP(E:RT
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of AK
Sent: Wednesday, March 19, 2014 8:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Count help
Hi All,
I need to count the non-blank cell from the latest month (Cell M1 -- Feb
Thanks alot Raviinder!
On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei
ravindervbacli...@gmail.comwrote:
pfa
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *AK
*Sent:* Wednesday, March 19, 2014 8:15 AM
*To:* excel-macros@googlegroups.com
There is some update as last output is not correct
On Thu, Mar 20, 2014 at 8:38 AM, AK exce...@gmail.com wrote:
Thanks alot Raviinder!
On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei
ravindervbacli...@gmail.com wrote:
pfa
*From:* excel-macros@googlegroups.com [mailto:
:
excel-macros@googlegroups.com] *On Behalf Of *Ravinder
*Sent:* Friday, March 14, 2014 3:08 PM
*To:* excel-macros@googlegroups.com
*Cc:* 'excelvbacli...@googlegroups.com'; Soum
*Subject:* FW: $$Excel-Macros$$ Conditional Formating
Did you not receive this file..
*From:* Ravinder
To: excel-macros@googlegroups.com
Cc: Soum
Subject: Re: FW: $$Excel-Macros$$ Conditional Formating
Dear Sir,
It is not working..
Please let me know how I can select the all cell in sheet where cell format
is %
Regards,
Prafull Jadhav
9920553518
On 14 March 2014 15:12, Ravinder
= vbGreen
End If
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Friday, March 14, 2014 3:36 PM
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Conditional Formating
Dear Sir,
I want a VBA
@googlegroups.com] *On Behalf Of *Prafull Jadhav
*Sent:* Friday, March 14, 2014 3:36 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: FW: $$Excel-Macros$$ Conditional Formating
Dear Sir,
I want a VBA code ;which will select the all cell in sheet where cell
format is 0.00
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) =
Thanks Ravinder for your kind help. I have not checked it yet, but if I
face any issue, definitely I'll get back to you for further assistance,
hope you would't mind. :)
Thanks Regards,
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and
- Forwarded Message -
From: Waseem Saifi waseemsa...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Wednesday, July 24, 2013 11:50 AM
Subject: Re: $$Excel-Macros$$ Want conditional lookup
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD
@googlegroups.com
*Sent:* Sunday, July 14, 2013 10:19 AM
*Subject:* Re: Fw: $$Excel-Macros$$ small macro help
check the attachment see if it helps
On Sun, Jul 14, 2013 at 12:37 AM, shreya vyas shreyavyas...@gmail.comwrote:
i have attached the new excel file where structure is same, including
i have attached the new excel file where structure is same, including cell
no, and also name of the sheet.
Thank you,
- Forwarded Message -
*From:* ashish koul koul.ash...@gmail.com
*To:* excel-macros excel-macros@googlegroups.com
*Sent:* Saturday, July 13, 2013 6:46 PM
*Subject:* Re:
PFA
Just Drag Drop first formula!!
Cheers!!
On Saturday, May 25, 2013 3:24:08 PM UTC+5:30, Amit Desai (MERU) wrote:
Can someone please look at my query help me?
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *Amit
No its not that easy.
From: Vabz [mailto:v...@vabs.in]
Sent: 25 May 2013 15:51
To: excel-macros@googlegroups.com
Cc: Amit Desai (MERU)
Subject: Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula
PFA
Just Drag Drop first formula!!
Cheers!!
On Saturday, May 25, 2013 3:24:08 PM UTC+5:30
:
*Cc:* Amit Desai (MERU)
*Subject:* Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula
PFA
Just Drag Drop first formula!!
Cheers!!
On Saturday, May 25, 2013 3:24:08 PM UTC+5:30, Amit Desai (MERU) wrote:
Can someone please look at my query help me
Hi Amit sir,
Please use this formula,if it helps
=ABS(IF(IF(AND(H2=yes,G3=no),AND(H2=yes,G4=yes))=TRUE,D2-D4,0)-IF(AND(H2=yes,G3=yes),D2-D3,0))
On Sat, May 25, 2013 at 3:24 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Can someone please look at my query help me?
** **
*From:*
YES... this helped me a lot..
Thanks a lot.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of priti verma
Sent: 25 May 2013 16:13
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula
Hi Amit sir,
Please use
Find below link for solution:
http://www.excelfox.com/forum/f2/need-array-formula-help-912/
On Thursday, 18 April 2013 10:50:04 UTC+5:30, Dhaval Shah wrote:
Hello Lalitji,
Thanks for you formula
sir i modified with formula littel bit now its not working actually while
i run formula
Dear Abhi,
Can I use formula =IF(AND(A6=2,A72),pass,fail) to find pass n fail
=IF(AND(A6=0,A70),pass,fail) even if it pop up pass it should show green
for fail it should show red
Value 0 to 2 = Green
Value greater than 2 = Red
Thanks
Manjunath
From: Abhishek Jain
Can you share an example data from your end so as to establish what exactly
you want?
On Wed, Feb 20, 2013 at 2:57 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
Dear Abhi,
Can I use formula =IF(AND(A6=2,A72),pass,fail) to find pass n fail
=IF(AND(A6=0,A70),pass,fail)
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU)
*Sent:* 26 January 2013 10:44
*To:* excel-macros@googlegroups.com
*Subject:* FW: $$Excel-Macros$$ Calculate Net TAT / time Gap excluding
Holidays as per list
@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Calculate Net TAT / time Gap excluding
Holidays as per list
use sumproduct (=(G2-F2)-SUMPRODUCT((HOliday=F2)*(HOliday=G2)))
holiday list as per your requirement
On Mon, Jan 28, 2013 at 12:36 PM, Amit Desai (MERU)
amit.de...@merucabs.commailto:amit.de
Dear Friends,
Please help.
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 25 January 2013 13:57
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Calculate Net TAT / time Gap
: $$Excel-Macros$$ need formula Highlight
Hi Manjunath,
PFA,
Regards
Prince
On Thursday, January 17, 2013 6:41:46 PM UTC+5:30, Manjunath Narayanappa wrote:
Dear all,
Please can I get macro for below requests
Regards
Manjunath
From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com
:
*Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight
1st Conditional Formatting:
[image: Inline image 1]
2nd Conditional Formatting Rules Manager:
[image: Inline image 2]
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com
to learn more abt Conditional formatting
Regarda
Manjunath
*From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com]
*On Behalf Of *Kuldeep Singh
*Sent:* 22 January 2013 10:05
*To:* excel-...@googlegroups.com
*Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight
@googlegroups.com
Cc: Manjunath Narayanappa; Prince
Subject: Re: FW: $$Excel-Macros$$ need formula Highlight
Hi Manjunath,
See below pdf. I hope it will help you.
http://ide20.com/upload/ModuleAE/Lesson01.pdf
http://ide20.com/upload/ModuleAE/Lesson02.pdf
http://ide20.com/upload/ModuleAE/Lesson03.pdf
Dear all,
Please can I get macro for below requests
Regards
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 17 January 2013 08:47
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ need formula Highlight
you can use conditional formatting for this
--- On Thu, 1/17/13, Manjunath Narayanappa manjunath.narayana...@aon.co.uk
wrote:
From: Manjunath Narayanappa manjunath.narayana...@aon.co.uk
Subject: FW: $$Excel-Macros$$ need formula Highlight
To: 'excel-macros@googlegroups.com' excel-macros
Hi Manjunath,
PFA,
Regards
Prince
On Thursday, January 17, 2013 6:41:46 PM UTC+5:30, Manjunath Narayanappa
wrote:
Dear all,
Please can I get macro for below requests
Regards
Manjunath
*From:* excel-...@googlegroups.com javascript: [mailto:
Dear neeraj chauhan
I hope this will help you.
Regards
Syed Azeem
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of neeraj chauhan
Sent: Wednesday, December 12, 2012 10:59 AM
To: excel-macros@googlegroups.com
Thanks sir
On Wed, Dec 12, 2012 at 1:49 PM, Sayed Abdul Azeem (QFD) sabdulaz...@ccc.ae
wrote:
Dear neeraj chauhan
** **
** **
** **
I hope this will help you.
** **
** **
** **
** **
** **
** **
Regards
** **
*Syed Azeem*
** **
** **
** **
** **
Hello Gurus
i am trying to develop a very dynamic Fixed Asset depreciation schedule but
facing a slight formula or logic challenge and as usual seeking your expert
advice. Basically what this current schedule does is assuming you want to
depreciate your asset for say 5 years, starting from 2013
Dear NOORAIN ANSARI
I am having huge data like attached file DATA sheet, from description
column selected contains need to copy sheet2 with vba code which is very
helpful for me, please see attached file sheet Data and sheet2 for your
understand.
Thanks in advance
Azeem Quraishi
Here is thread on this Solution , Please visit
http://www.excelfox.com/forum/f20/delete-list-contain-matching-second-list-5
89/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 04 October 2012 9:58
To:
From: Siraj Momin (BTG)
Sent: Monday, September 17, 2012 7:23 AM
To: 'excel-macros@googlegroups.com'
Subject: RE: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C
WITH COLUMN E AND G AND UPDATE THE VALUES.
Hi prince
May be I did not explain you properly see the attachment
, September 17, 2012 3:27:41 AM
Subject: FW: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH
COLUMN E AND G AND UPDATE THE VALUES.
From:Siraj Momin (BTG)
Sent: Monday, September 17, 2012 7:23 AM
To: 'excel-macros@googlegroups.com'
Subject: RE: FW: $$Excel-Macros$$ MATCHING
ANY SOLUTION POSSIBLE
SIRAJ
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Siraj Momin (BTG)
Sent: Monday, September 10, 2012 5:41 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH
COLUMN E
Hi Siraj,
As i saw u r using loop on the rang which runs fine on small amount of data
but in case of large amount of data it will take huge time to process so
do one thing instead of looping on the range get all data in an Array then
apply same logic as u r doing one the range.
Or
Please
; Siraj Momin (BTG)
Subject: Re: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C
WITH COLUMN E AND G AND UPDATE THE VALUES.
Hi Siraj,
please see the attachment
Regards
Prince
On Sunday, September 16, 2012 6:55:18 PM UTC+5:30, Siraj Momin (BTG)
wrote:
Hi Prince
Thank
Hi Everyone,,
I am trying to use chrome instead using Internet explorer.
Here is the code I have (the code the works for Internet Explorer and
the modified code for Chrome):
Dim IEapp As Object
Dim CHromeapp As Object
'Open Internet Explorer and Display the Route
Set IEapp =
Hi Don,
Thanks for your post,
I was trying to understand the formula, if we use array formula then below
highlighted cells also getting fixed and formula is not giving the proper
result,
=INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV20,0))
Can you please share the formula in excel file, to understand
Hi Experts,
I am also looking for this solution, can you please help.
Regards, Anil Bhange
IP Phone - 800105 | Mobile - +31 6 1192 3971
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Dhananjay Pinjan
Sent: Wednesday,
Noorin sir
Can y send me this file in excel 2003
On Mon, Aug 27, 2012 at 4:03 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Neeraj,
See attached sheet, Hope it will help to you.
On Mon, Aug 27, 2012 at 3:23 PM, Neeraj neerajchauhan...@gmail.comwrote:
** **
** **
*From:*
Dear noorain,
I don't want to change the colum min and mix.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Monday, August 27, 2012 4:04 PM
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ resolve the problem
Thanks noorain.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Monday, August 27, 2012 5:07 PM
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ resolve the problem
Dear Neeraj,
Try below formula
*To:* excel-macros@googlegroups.com
*Subject:* Re: FW: $$Excel-Macros$$ resolve the problem
** **
Dear Neeraj,
Try below formula :
=IF(COUNTIF($C$2:C2,C2)=1,LARGE(IF($C$2:$C$1006=C2,$D$2:$D$1006),1)-SMALL(IF($C$2:$C$1006=C2,$D$2:$D$1006),1),)
with ctrl+shift+enter
See attached sheet
)/24*4),)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 30 June 2012 8:30
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Macro timings should be multiple based
.
** **
*Regards,*
*Lalit Mohan*
*www.excelfox.com/forum*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
*Sent:* Saturday, June 30, 2012 8:36 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: FW: $$Excel-Macros$$ Macro timings should
Hi Lokesh
You must apply [h]:mm:ss format on that cell to get proper result
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 30 June 2012 10:38
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Macro
yes thank you, now the i have changed the date format.
And one more correction if there is no user timings and macro timings the
result should be shown blank not for 4:00:00.
please do the needful brother.
Regards
Lokesh.M
On Sat, Jun 30, 2012 at 8:26 PM, Rajan_Verma
: $$Excel-Macros$$ Macro timings should be multiple based on
date changing
yes thank you, now the i have changed the date format.
And one more correction if there is no user timings and macro timings the
result should be shown blank not for 4:00:00.
please do the needful brother.
Regards
*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
*Sent:* 30 June 2012 8:30
*To:* excel-macros@googlegroups.com
*Subject:* Re: FW: $$Excel-Macros$$ Macro timings should be multiple
based on date
See the revised version
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 13 June 2012 6:37
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Region wise count
Hi Loki,
Here is a VBA Solution for you, see
Dear all,
Please try to find out any solution!
Sandeep Chhajer
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 11 Jun 2012 10:59:23
To: excel-macros@googlegroups.com
Reply-To:
I think I misunderstood your question , you can use this macro :
Private Sub Workbook_Open()
Dim wksSheet As Worksheet
For Each wksSheet In Me.Worksheets
If wksSheet.Name = Result Then
wksSheet.Copy ,
ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count)
Hi Rajan,
Its working fine now.
Thanks again.
Mangesh
On Thu, Jun 7, 2012 at 8:39 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
I think I misunderstood your question , you can use this macro :
** **
Private Sub Workbook_Open()
Dim wksSheet As Worksheet
For Each
Dear Rajan,
Congratulations..
Keep the same stream always...
Regards,
Muneer,
CC
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
To All,
- Forwarded Message -
From: Aamir Shahzad aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, May 23, 2012 1:42 AM
Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
I don't think so or any other group member can provide solution.
You also can use:
=IF(SUMPRODUCT(--($A$2:$C$11=E2)*($E$2:$E$11))1,,Not Present)
Regards,
Aamir Shahzad
On Sun, May 20, 2012 at 8:46 AM, Mohammed Muneer mmun...@ccc.com.qa wrote:
HI, Rajan its working that’s what I exactly want to do.
Thanx Buddy….
Regards,
Muneer,
CC….
--
Of *Aamir Shahzad
*Sent:* 20 May 2012 1:41
*To:* excel-macros@googlegroups.com
*Subject:* Re: FW: $$Excel-Macros$$ Find the number missing in other cols*
***
** **
You also can use:
** **
=IF(SUMPRODUCT(--($A$2:$C$11=E2)*($E$2:$E$11))1,,Not Present)
** **
Regards
Ignore that please
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: 20 May 2012 2:09
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Find the number missing
HI, Rajan its working that's what I exactly want to do.
Thanx Buddy
Regards,
Muneer,
CC
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Group is not allowing large size Files. So I am sending the Excel file and
Access DB on your personal mail. J
Rajan
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: Apr/Fri/2012 06:55
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Need help
Hi,
In shared
Dear Williams,
Pls post query
On Thu, Mar 22, 2012 at 10:19 AM, Mike Williams mwilli...@marinaauto.comwrote:
**
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem,
Can anyone please help me on this?
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 25 March 2012 18:33
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to sort excel data email to party
Dear
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the
Dear All,
Please find attached sample file. Following things needs to be done;
1) In first sheet there are data that needs to be sorted work shop wise.
2) In the second sheet email ids are mentioned where we need to send those
sorted data per workshop.
Please let me know if we have
From right.
=Len(A1)- MAX(--(MID(A1,ROW(INDIRECT(1:LEN(A1))),1)=
)*ROW(INDIRECT(1:LEN(A1+1 with cse
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: Feb/Fri/2012 07:35
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ How to find out rightmost space in a cell
Rajan,
The formula you posted would give 1, if there is no word in the cell and
secondly if there is only one word, the result would be 1 + length of the
word, which is incorrect.
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Ah.. thanks for correction..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Feb/Fri/2012 08:48
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ How to find out rightmost space in a cell
of text string with many spaces
Please ignore previous
Try this With CSE
=LARGE(--(NOT(ISERROR(E3:W3)))*IFERROR(E3:W3,0),1)
Rajan
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: Jan/Tue/2012 07:07
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ reqment of greater than formula
Try
Dear sir,
could you plese provide soulution sir,
Regards
chandru
On Tue, Jan 3, 2012 at 8:24 PM, chandra sekaran duraichan...@gmail.comwrote:
Dear Rajan,
if i select Month july only july data will come but all data comes
output sheet after that i little bit change from date ,
Dear Mr. Sastry,
Pls. check the attachment for your query..
__
Thanks Regards,
Utpal Samui
_
The earth is enjoyed by heroes-this is the unfailing truth. Be a hero.
Always say, I have no fear.
- Swami Vivekanand
Hi Group,
Please help
Thanks
Prasad.
-- Forwarded message --
From: suryaprasad...@gmail.com
Date: Thu, Oct 13, 2011 at 10:43 AM
Subject: Fw: $$Excel-Macros$$ Help required
To: excel-macros@googlegroups.com
**Hi Guys can anyone help me on this please
Thanks
Prasad
Sent from
,
Please help
Thanks
Prasad.
-- Forwarded message --
From: suryaprasad...@gmail.com
Date: Thu, Oct 13, 2011 at 10:43 AM
Subject: Fw: $$Excel-Macros$$ Help required
To: excel-macros@googlegroups.com
**Hi Guys can anyone help me on this please
Thanks
Prasad
Sent from
Hi Guys can anyone help me on this please
Thanks
Prasad
Sent from BlackBerry® on Airtel
-Original Message-
From: Mr Excellent suryaprasad...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Oct 2011 04:52:12
To: excel-macros@googlegroups.com
Reply-To:
Hi all,
Can anyone help me on this??
Regards
Prasad
Sent from BlackBerry® on Airtel
-Original Message-
From: Mr Excellent suryaprasad...@gmail.com
Date: Mon, 5 Sep 2011 17:10:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Hi
Dear Surya,
Please see attached sheet if it help to u..
-- Forwarded message --
From: suryaprasad...@gmail.com
Date: Mon, Sep 5, 2011 at 11:15 PM
Subject: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes
To: excel-macros@googlegroups.com
**Hi all,
Can anyone help me
message --
From: suryaprasad...@gmail.com
Date: Mon, Sep 5, 2011 at 11:15 PM
Subject: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes
To: excel-macros@googlegroups.com
**Hi all,
Can anyone help me on this??
Regards
Prasad
Sent from BlackBerry® on Airtel
dear danial,
as per your code its not working, please give me suggesstion as per my
attachement file.
sajid memon
From: dcolarde...@free.fr
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ date in range
Date: Sat, 3 Sep 2011 19:39:41 +0200
Paste the below
Dear Rajan,
Thanks for this..but I do want to edit the attached formula, please explain the
same how to do ?
Also I want to have the formula with criteria of either or (in countifs we used
to add 2 count ifs)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf
Dear Amit,
You can use Sumproduct instead of Countifs for Multiple Criteria..
See example..
=*SUMPRODUCT(--(A2:A30=F24)*(B2:B30=G24)*(C2:C30=H24))*
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Sep 2, 2011 at 3:21
Data Table
Date
Party Name
Amount
Hi can u suggest here for Sumproduct formula
8/30/2011
Anuvanshika -Kanpur
3
8/30/2011
Kelvin Elec.
49649
Name of Parties
Date
Amt.
8/30/2011
Anand Agencies
15
Kelvin
hi experts
please help me.plz find the atachment
thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hey amit,
can you share the example sheet.
On Wed, Aug 17, 2011 at 11:00 AM, Amit Desai (MERU)
amit.de...@merucabs.com wrote:
Thanks, but this did not worked..I have updated few data in sheet1, after
pressing cltr+shift+S, selected the entire range, than given the name of
sheets where we have
Hey Satish,
please see the below link and follow instructions
http://support.microsoft.com/kb/214081
On Wed, Aug 17, 2011 at 11:36 AM, Satish Bandaru snband...@gmail.com wrote:
hi experts
please help me.plz find the atachment
thanks in advance
--
Dear Sir,
Sir I have a query that by using this macro file I am able to merge
different files into single excel but after merging the data is not under
single column heading, Pls. suggest how can I merge files having similar
column headers in all files, so that I can easily sort data as per my
Your source files should all be structured the same. If not, you will have to
program. Attach samples
From: vikas gupta
Sent: Tuesday, August 16, 2011 6:55 AM
To: excel-macros@googlegroups.com
Cc: pankaj chawla ; tech_pankajcha...@rediffmail.com
Subject: Fwd: FW: $$Excel-Macros$$ Workbooks
I can help email me at excelvba...@gmail.com
On Tue, Aug 16, 2011 at 6:55 AM, vikas gupta vikas.63...@gmail.com wrote:
Dear Sir,
Sir I have a query that by using this macro file I am able to merge
different files into single excel but after merging the data is not under
single column
hey Vikas,
try to use batch file
open notepad...paste below code then save as
copy.bat
Copy *Comman file name*.xls output.xls
exit
On Tue, Aug 16, 2011 at 5:25 PM, vikas gupta vikas.63...@gmail.com wrote:
Dear Sir,
Sir I have a query that by
Try this :
Sub Compile()
On Error GoTo Err_Clear:
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim Fso As New Scripting.FileSystemObject
Dim Path As String
Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to
Pick Downloaded Bills
Hi Mukesh
Did you shoot this query again , I have sent a solution for this , see the
attached sheet, Revert if any query you have?
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: Friday, August 05, 2011 6:02 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$
1 - 100 of 139 matches
Mail list logo