Re: $$Excel-Macros$$ Formula to span number of nights (from Arrival Date to Departure Date) in relevant monthly Column

=IF($B2>$C2,"Error Input",IF(TEXT(D$1,"ymm")=TEXT($B2,"ymm"),IF(TEXT(D$1,"ymm")=TEXT($C2,"ymm"),$C2,D$1)-$B2+1,IF(TEXT(D$1,"ymm")=TEXT($C2,"ymm"),DAY($C2),IF(AND(TEXT(D$1,"ymm")>TEXT($B2,"ymm"),TEXT(D$1,"ymm") Excel attached Pada 23/06/2013 1:07, Ali menulis: Hi Vabz, Thank you very much for l

$$Excel-Macros$$ Need an excel template to manage multiple IT vendors relationship. Can anyone help?

Need an excel template to manage multiple IT vendors relationship. Can anyone help? -- 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,

Re: $$Excel-Macros$$ Formula to span number of nights (from Arrival Date to Departure Date) in relevant monthly Column

Hi Vabz, Thank you very much for looking into my problem! Your solution works fine when the Date of Arrival and Date of Departure spans over 2 consecutive months but I get an error in cases where the Date of Arrival and the Date of Departure are in the same month (eg: Arrival on 24-01-13 and De

Re: $$Excel-Macros$$ Date format to be changed

kya baat h sir On Sat, Jun 22, 2013 at 5:56 PM, Pravin Gunjal wrote: > Dear Ahmed, > > Thanks it's working fine.. Nice to see you here after long time.. > > Regards > Pravin Gunjal. > > -- Forwarded message -- > From: Ahmed Honest > Date: Sat, Jun 22, 2013 at 5:51 PM > Subjec

Re: $$Excel-Macros$$ Start and Stop Time - Macro

Thanks again Vabz. The problem is that although I am pretty certain that this is easy to write, I really have no background in VBA programming. On Saturday, June 22, 2013 7:13:34 AM UTC-4, Vabz wrote: > Hi > > For end time you can add one line ti check existing time with end time, if > exist

Re: $$Excel-Macros$$ Help me plz

Thank you, it working fine, I will update in my file now, thank you once again. regards, Thameem.m On Sat, Jun 22, 2013 at 4:42 PM, De Premor wrote: > Attached, new rule based on C > 0 and D=0 > > Rgds, > [dp] > > Pada 22/06/2013 18:03, thameem menulis: > > Plz check attached file > > > On S

Re: $$Excel-Macros$$ Date format to be changed

Hi Reason for not working: It is not date, so u need to convert data in to date by Data text to column you can convert all column data in to date. PFA Thanks On Sat, Jun 22, 2013 at 5:56 PM, Pravin Gunjal wrote: > Dear Ahmed, > > Thanks it's working fine.. Nice to see you here after long ti

Re: $$Excel-Macros$$ Help me plz

Attached, new rule based on C > 0 and D=0 Rgds, [dp] Pada 22/06/2013 18:03, thameem menulis: Plz check attached file On Sat, Jun 22, 2013 at 2:39 PM, De Premor > wrote: can you provide us more raw data in excel with some example that meet your requirement to

Re: $$Excel-Macros$$ Web links in word - reg.

Check default paste option .. It will work i guess. Cheers!! On Sat, Jun 22, 2013 at 5:54 PM, Pravin Gunjal wrote: > Thanks Prabhu & Vaibhav, > > I am trying to paste any link in a new file only and even though it's > happening; I don't know why. > > There might be somewhere setting is change

Fwd: $$Excel-Macros$$ Date format to be changed

Dear Ahmed, Thanks it's working fine.. Nice to see you here after long time.. Regards Pravin Gunjal. -- Forwarded message -- From: Ahmed Honest Date: Sat, Jun 22, 2013 at 5:51 PM Subject: Re: $$Excel-Macros$$ Date format to be changed To: excel-macros@googlegroups.com Dear Pr

Fwd: $$Excel-Macros$$ Web links in word - reg.

Thanks Prabhu & Vaibhav, I am trying to paste any link in a new file only and even though it's happening; I don't know why. There might be somewhere setting is changed. Regards Pravin Gunjal. -- Forwarded message -- From: VBA VABZ Date: Sat, Jun 22, 2013 at 5:06 PM Subject: Re:

Re: $$Excel-Macros$$ Date format to be changed

Dear Pravin : Use the below =TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),"DD-MMM-")​ On Sat, Jun 22, 2013 at 3:15 PM, Pravin Gunjal wrote: > Dear Vaibhav > > It's not working,. please check the attachment. > Thanks, > > Pravin. > > -- Forwarded message -- > From: VBA VABZ

Fwd: $$Excel-Macros$$ Date format to be changed

Dear Vaibhav It's not working,. please check the attachment. Thanks, Pravin. -- Forwarded message -- From: VBA VABZ Date: Sat, Jun 22, 2013 at 3:38 PM Subject: Re: $$Excel-Macros$$ Date format to be changed To: "excel-macros@googlegroups.com" Select cell, right click, format

Re: $$Excel-Macros$$ Web links in word - reg.

HI Open new word doc & try pasting there. If it works there then there is issue in existing doc so you need to re-create existing doc. HTH//Vabs On Sat, Jun 22, 2013 at 4:50 PM, Prabhu Pinky wrote: > hi pravin, > > am also using the same version of MS Word. But its working fine even if i > pr

Re: $$Excel-Macros$$ Web links in word - reg.

hi pravin, am also using the same version of MS Word. But its working fine even if i press enter. better you can re install the MS. it may work. Thanks & Regards, Prabhu R On 22 June 2013 13:23, Pravin Gunjal wrote: > Dear Mr Vijay, > > Thanks for it. I tried the same but it's not workin

Re: $$Excel-Macros$$ Start and Stop Time - Macro

Hi For end time you can add one line ti check existing time with end time, if existing time is > end time then quit sub. HTH//Vabs On Sat, Jun 22, 2013 at 10:57 AM, Bill Q wrote: > Sounds good Vabz Half way there. What about the end time ? Where would > that go ? > On Friday, June 21, 201

Re: $$Excel-Macros$$ Help me plz

Plz check attached file On Sat, Jun 22, 2013 at 2:39 PM, De Premor wrote: > can you provide us more raw data in excel with some example that meet > your requirement to make it more clearly to understand ! > > Rgds > [dp] > Pada 22/06/2013 17:21, thameem menulis: > > SORRY , I need high only

Re: $$Excel-Macros$$ Help me plz

can you provide us more raw data in excel with some example that meet your requirement to make it more clearly to understand ! Rgds [dp] Pada 22/06/2013 17:21, thameem menulis: SORRY , I need high only for 3 condition... there is zero in row 2 also, in my data alot of zero are there... because

Re: $$Excel-Macros$$ Help me plz

SORRY , I need high only for 3 condition... there is zero in row 2 also, in my data alot of zero are there... because still my data is on process not yet freeze... so it can change.. once it get freeze, we can apply C3=0 or c2=0 condition, but to freeze data, it will take 2 more months, but i need

Re: $$Excel-Macros$$ Help me plz

In attached file, please see the conditional formating formula and range to apply Rgds, [dp] Pada 22/06/2013 16:26, thameem menulis: Dear all, Plz find attached file, its sample, I want high for range of cells, only at that condition, plz help me to learn, for condition or sample find attac

Re: $$Excel-Macros$$ Date format to be changed

Select cell, right click, format cell, custom & type DD--. You can use text(cell,"DD-MMM-") also. Thanks On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal wrote: > I have date in this format : *DD.MM.* (with dot) and require it as : * > DD-MMM-* (with hyphen). > For example :

$$Excel-Macros$$ Help me plz

Dear all, Plz find attached file, its sample, I want high for range of cells, only at that condition, plz help me to learn, for condition or sample find attached file. regards, Thameem.M -- 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 of

Re: $$Excel-Macros$$ Subtatal by VBA(urgent)

Here's a list of threads from Excel Fox that contains use of Array and various manipulations http://www.excelfox.com/forum/search.php?searchid=139820 http://www.excelfox.com/forum/search.php?searchid=139822 On Sat, Jun 22, 2013 at 1:40 PM, priti verma wrote: > Hi Sam, > do you Know any good sit

Re: $$Excel-Macros$$ Subtatal by VBA(urgent)

Hi Sam, do you Know any good site from where i Learn array in vba. On Sat, Jun 22, 2013 at 1:22 PM, priti verma wrote: > > Thanks sam its working fine, > > > On Sat, Jun 22, 2013 at 1:14 PM, Sam Mathai Chacko wrote: > >> Range("A1").CurrentRegion.Subtotal GroupBy:=3, Function:=xlSum, >> TotalLi

$$Excel-Macros$$ Date format to be changed

I have date in this format : *DD.MM.* (with dot) and require it as : * DD-MMM-* (with hyphen). For example : I have* 01.04.2013* and want it to be displayed as * 01-APR-2013* Kindly give me the formula. Thanks Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Web links in word - reg.

Dear Mr Vijay, Thanks for it. I tried the same but it's not working. I am using 2007 version. Example: When I paste any link to word its displaying correctly as : https://login.yahoo.com/config/mail?.intl=us but when I hit on enter button it's getting changed as : {HYPERLINK “ https://login.ya

Re: $$Excel-Macros$$ Subtatal by VBA(urgent)

Thanks sam its working fine, On Sat, Jun 22, 2013 at 1:14 PM, Sam Mathai Chacko wrote: > Range("A1").CurrentRegion.Subtotal GroupBy:=3, Function:=xlSum, > TotalList:=Array(4, 5, 6) > > Sam Mathai Chacko > > > On Sat, Jun 22, 2013 at 1:08 PM, priti verma wrote: > >> Hi group, >> >> pleaase help

Re: $$Excel-Macros$$ Subtatal by VBA(urgent)

Range("A1").CurrentRegion.Subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(4, 5, 6) Sam Mathai Chacko On Sat, Jun 22, 2013 at 1:08 PM, priti verma wrote: > Hi group, > > pleaase help me to solve this .see attachment for more clarification. > I want a macro for this. > > Thanks in advanc

$$Excel-Macros$$ Subtatal by VBA(urgent)

Hi group, pleaase help me to solve this .see attachment for more clarification. I want a macro for this. Thanks in advance Priti verma -- 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.f

Re: $$Excel-Macros$$ Web links in word - reg.

Respected Pravin, How do I turn off automatic hyperlinks? To turn off automatic hyperlinks, follow these steps, as appropriate for the version of Word that you are running: In Microsoft Office Word 2010and 2013, follow these steps: On the File menu, click Options. Click Proofing, and then click Au