Re: Fw: $$Excel-Macros$$ Merge multiple Workbook

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, I

Fw: $$Excel-Macros$$ Merge multiple Workbook

Hi,Any way to solve this problem.

FW: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT

:- S NO CODE SLAB LOCATION TYPE STEP 1 k01v 1 T NORMAL STEP - 1 2 k01v 2 T NORMAL STEP - 1 3 k01v 1 B NORMAL STEP - 1 4 k01v 2 B NORMAL STEP - 1 1 k01v 1 T SIP STEP - 1 2 k01v 2 T SIP STEP - 1 3 k01v 1 B SIP STEP - 1 4 k01v 2 B SIP STEP - 1 From: KANNAN V Sent: ‎11-‎07-‎2015 08:23 AM T

Re: FW: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

m [mailto: > excel-macros@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!

RE: FW: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

@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 @

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://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titl

FW: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

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

Re: FW: $$Excel-Macros$$ Count help

There is some update as last output is not correct On Thu, Mar 20, 2014 at 8:38 AM, AK 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-macr

Re: FW: $$Excel-Macros$$ Count help

Thanks alot Raviinder! On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei wrote: > 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-Mac

FW: $$Excel-Macros$$ Count help

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

Re: FW: $$Excel-Macros$$ Conditional Formating

; 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 > > *

RE: FW: $$Excel-Macros$$ Conditional Formating

rior.Color = 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,

Re: FW: $$Excel-Macros$$ Conditional Formating

1:$L$21, you can increase as per your requirement. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Prafull Jadhav > *Sent:* Friday, March 14, 2014 3:29 PM > *To:* excel-macros@googlegroups.com > *Cc:* Soum > *Sub

RE: FW: $$Excel-Macros$$ Conditional Formating

: 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

Re: FW: $$Excel-Macros$$ Conditional Formating

m [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 > > > >

FW: $$Excel-Macros$$ UDF convert to Macro

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) = WorksheetFuncti

Re: FW: $$Excel-Macros$$ Need experts help ***URGENT***

Hi Experts / Ravinder, Macro is working fine but facing one issue. Macro is collecting data from almost 500 files, and doing it's doing good, but there is a problem, after collecting the data the Master file is getting stuck, don't know why? Actually I'm trying to collect data from read only fil

Re: FW: $$Excel-Macros$$ Need experts help ***URGENT***

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 inten

Fw: $$Excel-Macros$$ Want conditional lookup

        - Forwarded Message - From: Waseem Saifi To: excel-macros 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 wrote: Dear Expert, >Want conditional lookup fro

Re: Fw: Fw: $$Excel-Macros$$ small macro help

cros > *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 wrote: > > > i have attached the new excel file where structure is same, includ

Fwd: Fw: $$Excel-Macros$$ small macro help

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 *To:* excel-macros *Sent:* Saturday, July 13, 2013 6:46 PM *Subject:* Re: $$Excel-Macros$$ small macro help Is the structure

RE: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

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 this

Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

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) wrote: > Can someone please look at my query & help me? > > ** ** > > *From:* excel-

Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

groups.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,

RE: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

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+

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? > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Amit Desai (MERU) > *Se

Re: FW: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

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 fo

Re: FW: $$Excel-Macros$$ conditional formatting

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,A7>2),"pass","fail") to find pass n fail > > =IF(AND(A6=0,A7>

FW: $$Excel-Macros$$ conditional formatting

Dear Abhi, Can I use formula =IF(AND(A6=2,A7>2),"pass","fail") to find pass n fail =IF(AND(A6=0,A7>0),"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 [mailto:abhishek

RE: FW: $$Excel-Macros$$ Calculate Net TAT / time Gap excluding Holidays as per list

cros@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) mailto:amit.de...@me

Re: FW: $$Excel-Macros$$ Calculate Net TAT / time Gap excluding Holidays as per list

Best Regards, > > Amit Desai > > ** ** > > *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$

FW: $$Excel-Macros$$ Calculate Net TAT / time Gap excluding Holidays as per list

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 excl

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

Re: FW: $$Excel-Macros$$ need formula Highlight

gt;> >> *From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com] >> *On Behalf Of *Manjunath Narayanappa >> >> *Sent:* 18 January 2013 08:09 >> *To:* 'excel-...@googlegroups.com**' >> *Cc:* 'Prince' >> >> >> *

Re: FW: $$Excel-Macros$$ need formula Highlight

; *To:* excel-...@googlegroups.com > *Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight > > > > > > 1st Conditional Formatting: > > > > [image: Inline image 1] > > 2nd Conditional Formatting Rules Manager: > > > > [im

FW: $$Excel-Macros$$ need formula Highlight

rayanappa Subject: Re: FW: $$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

Re: FW: $$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-...@googleg

Re: FW: $$Excel-Macros$$ need formula Highlight

you can use conditional formatting for this  --- On Thu, 1/17/13, Manjunath Narayanappa wrote: From: Manjunath Narayanappa Subject: FW: $$Excel-Macros$$ need formula Highlight To: "'excel-macros@googlegroups.com'" Date: Thursday, January 17, 2013, 6:41 PM Dear

FW: $$Excel-Macros$$ need formula Highlight

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

Re: FW: $$Excel-Macros$$ Help req.

Thanks sir On Wed, Dec 12, 2012 at 1:49 PM, Sayed Abdul Azeem (QFD) wrote: > Dear neeraj chauhan > > ** ** > > ** ** > > ** ** > > I hope this will help you. > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > Regards > > ** ** > > *Syed Azeem* > > ** ** > > ** ** > > **

FW: $$Excel-Macros$$ Help req.

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 Subjec

Fw: $$Excel-Macros$$ Dynamic Fixed Asset Depreciation Schedule *

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 yo

FW: $$Excel-Macros$$

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

FW: $$Excel-Macros$$ macro: delete base on table

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: 'excel-macros@goo

Re: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.

imer     tElapsed = tstop - tstart     tMin = tElapsed \ 60     tSec = tElapsed Mod 60         MsgBox "Finished" & Chr(13) & tMin & " min " & tSec & " sec" End Sub     Paul - “Do all the good you can, By all the means you can, In all the ways you can, In a

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

RE: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.

; 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

Re: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.

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 s

FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.

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 AN

Re: Fwd: FW: $$Excel-Macros$$ Send PDF Email from Excel - Mail Merge

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 = CreateObject(

FW: $$Excel-Macros$$ Required Revenue started from Date..

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:IV2>0,0)) Can you please share the formula in excel file, to understand be

FW: $$Excel-Macros$$ countdown macro needed.........

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, August

Re: FW: $$Excel-Macros$$ resolve the problem

gt; > *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),&q

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 : =IF

RE: FW: $$Excel-Macros$$ resolve the problem

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 pr

Re: FW: $$Excel-Macros$$ resolve the problem

Noorin sir Can y send me this file in excel 2003 On Mon, Aug 27, 2012 at 4:03 PM, NOORAIN ANSARI wrote: > Dear Neeraj, > > See attached sheet, Hope it will help to you. > > > On Mon, Aug 27, 2012 at 3:23 PM, Neeraj wrote: > >> ** ** >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto

Re: FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

> *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

RE: FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

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 on date changi

Re: FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

gt; > * * > > *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 >

RE: FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

ubject: Re: FW: $$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

Re: FW: $$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 Lokesh.M On Sat, Jun 30, 2012 at 8:26 PM, Rajan_Verma wrote: > Hi Lokesh > >

FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

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 timings

Re: FW: $$Excel-Macros$$ Region wise count

Hello Brother's, Wow great solution. Now i got the exact result. Thanks a lot. Once again thanks a lot for Noorain also. These two guy's are rocking in group, have a great future ahead. Regards Lokesh.M On Wed, Jun 13, 2012 at 6:47 PM, Rajan_Verma wrote: > See the revised version > > **

FW: $$Excel-Macros$$ Region wise count

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 th

Re: Fw: $$Excel-Macros$$ Name a table

can you share a sample file On Mon, Jun 11, 2012 at 8:27 PM, wrote: > 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,

Fw: $$Excel-Macros$$ Name a table

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: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macro

Re: FW: $$Excel-Macros$$ Need Help - To rename the sheet

Hi Rajan, Its working fine now. Thanks again. Mangesh On Thu, Jun 7, 2012 at 8:39 PM, Rajan_Verma wrote: > I think I misunderstood your question , you can use this macro : > > ** ** > > Private Sub Workbook_Open() > > Dim wksSheet As Worksheet > > For Each wksSheet In Me.Wo

FW: $$Excel-Macros$$ Need Help - To rename the sheet

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)

FW: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

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 Problem

Fw: $$Excel-Macros$$ unable to use advance vlookup

To All,         - Forwarded Message - From: Aamir Shahzad 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.  Regards, Aamir Shahzad On

RE: FW: $$Excel-Macros$$ Find the number missing in other cols

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 in

Re: FW: $$Excel-Macros$$ Find the number missing in other cols

el-macros@googlegroups.com] *On Behalf 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(SUMP

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, Aamir Shahzad On Sun, May 20, 2012 at 8:46 AM, Mohammed Muneer wrote: > HI, Rajan its working that’s what I exactly want to do. > > > > Thanx Buddy…. > > > > > > > > Regards, > > Muneer, > > CC…. >

FW: $$Excel-Macros$$ Find the number missing in other cols

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 Probl

FW: $$Excel-Macros$$ Need help

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 W

FW: $$Excel-Macros$$ Macro to sort excel data & email to party

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 Al

Re: FW: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 25 Messages in 15 Topics

Dear Williams, Pls post query On Thu, Mar 22, 2012 at 10:19 AM, Mike Williams wrote: > ** > > > -- > 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 N

FW: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 25 Messages in 15 Topics

-- 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 thr

FW: $$Excel-Macros$$ Sum of all the random numbers generated

Dear All, Can we get the required details? Regards, Saurabh Patel From: Saurabh Madhusudan Patel [mailto:saurabh.pa...@in.aegisglobal.com] Sent: Saturday, March 24, 2012 7:49 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Sum of all the random numbers generated

FW: $$Excel-Macros$$ macro to sort excel data & email to party

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

RE: FW: $$Excel-Macros$$ How to find out rightmost space in a cell of text string with many spaces.

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

Re: FW: $$Excel-Macros$$ How to find out rightmost space in a cell of text string with many spaces.

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 th

RE: FW: $$Excel-Macros$$ How to find out rightmost space in a cell of text string with many spaces.

As per Krishna logic . it can be used .. =LEN(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",100)),100)))+1 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Feb/Fri/2012 08:37 To: excel-macros@googlegroups.com Subject: Re: FW:

Re: FW: $$Excel-Macros$$ How to find out rightmost space in a cell of text string with many spaces.

=IF(ISNUMBER(FIND(" ",A2)),1+LEN(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",100)),100))),"") Kris -- 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 Adv

FW: $$Excel-Macros$$ How to find out rightmost space in a cell of text string with many spaces.

>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

FW: $$Excel-Macros$$ reqment of greater than formula

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 w

Re: FW: $$Excel-Macros$$ cashflow statement

Dear sir, could you plese provide soulution sir, Regards chandru On Tue, Jan 3, 2012 at 8:24 PM, chandra sekaran wrote: > 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 , To date it is > wor

FW: $$Excel-Macros$$ Decimals upto & beyond 20

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 Vivekan

Re: Fw: $$Excel-Macros$$ Help required

Value GoTo lable1: End Sub On Thu, Oct 13, 2011 at 4:21 PM, Mr Excellent wrote: > Hi Group, > > Please help > > Thanks > Prasad. > > -- Forwarded message -- > From: > Date: Thu, Oct 13, 2011 at 10:43 AM > Subject: Fw: $$Excel-Macros$$

Fwd: Fw: $$Excel-Macros$$ Help required

Hi Group, Please help Thanks Prasad. -- Forwarded message -- From: 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 BlackBerry® on Airtel

Fw: $$Excel-Macros$$ Help required

Hi Guys can anyone help me on this please Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 04:52:12 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help required Hi G

Re: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes

rwarded message -- > From: > 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 BlackBe

Fwd: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes

Dear Surya, Please see attached sheet if it help to u.. -- Forwarded message -- From: 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

Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes

Hi all, Can anyone help me on this?? Regards Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent Date: Mon, 5 Sep 2011 17:10:47 To: Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single cas

FW: $$Excel-Macros$$ date in range

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

Re: FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

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/* On Fri, Sep 2, 2011 at 3:21

FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

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

FW: $$Excel-Macros$$ Book2.xlsx

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 Elec.

Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

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 wrote: > hi experts > please help me.plz find the atachment > thanks in advance > > -- >

Re: FW: $$Excel-Macros$$ Update Data source range & converting "0" to "-"

Hey amit, can you share the example sheet. On Wed, Aug 17, 2011 at 11:00 AM, Amit Desai (MERU) 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 Pivots. > > Best Reg

  1   2   >