Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-01 Thread Ashish Kumar
Hi Ashu, PFA.!!! 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 titles. Poor thread titles,

Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-01 Thread Ashu k
Dear Vaibhav Sir, Thanks for your quick response and giving me the valuable information link. Dear Pramod Sir, Its working, but Cell Blinking is stopped after some seconds. Pls Help. Regards Ashu On Tue, Sep 2, 2014 at 11:35 AM, Pramod Singh wrote: > Hi Ashu, > > PFA...

Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-01 Thread Vaibhav Joshi
yes you can chek dis: http://msdn.microsoft.com/en-us/library/office/ff193220(v=office.15).aspx Cheers! On Tue, Sep 2, 2014 at 10:39 AM, Ashu k wrote: > Dear Seniors, > > If I have value in Column A and B. A value is 1 and B value is 12000 > than -2000 is showing in C column & Highlight

Re: $$Excel-Macros$$ Vlookup Issue

2014-09-01 Thread Vaibhav Joshi
cheers!! On Tue, Sep 2, 2014 at 10:28 AM, Sunil Kumar Yadav wrote: > thank u so much...it's working completely. > > > *Thanks & Regards,Sunil Kumar Yadav* > > > On Mon, Sep 1, 2014 at 6:48 PM, Vaibhav Joshi wrote: > >> Check this.. >> >> Cheers!! >> >> >> On Mon, Sep 1, 2014 at 6:36 PM, Sunil

Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-01 Thread Pramod Singh
Hi Ashu, PFA..As per your requirement.. On Tue, Sep 2, 2014 at 10:39 AM, Ashu k wrote: > Dear Seniors, > > If I have value in Column A and B. A value is 1 and B value is 12000 > than -2000 is showing in C column & Highlight Column C with Blinking. > > Like :

Re: $$Excel-Macros$$ load graph in userform

2014-09-01 Thread Anil Gawli
​Dear Hilary, Pl find below attached file for you ref. Warm Regards, Gawli Anil. On Mon, Sep 1, 2014 at 9:16 PM, Hilary Lomotey wrote: > Hello Experts > > Just found a temporal solution to my question above however, i wish to > have some modification, i managed to get the code below but i mod

$$Excel-Macros$$ Need Help - Show (-) Value

2014-09-01 Thread Ashu k
Dear Seniors, If I have value in Column A and B. A value is 1 and B value is 12000 than -2000 is showing in C column & Highlight Column C with Blinking. Like : Earnings (A) Column - Expenses (B) Column = Output (C) Column will be blinking. Is it possible. Regards Ashu -- Are you =EXP(E:R

Re: $$Excel-Macros$$ Vlookup Issue

2014-09-01 Thread Sunil Kumar Yadav
thank u so much...it's working completely. *Thanks & Regards,Sunil Kumar Yadav* On Mon, Sep 1, 2014 at 6:48 PM, Vaibhav Joshi wrote: > Check this.. > > Cheers!! > > > On Mon, Sep 1, 2014 at 6:36 PM, Sunil Kumar Yadav > wrote: > >> Hello Friends, >> >> i have a query, please guide me. >> >> i

$$Excel-Macros$$ Re: Filter Issue

2014-09-01 Thread Bill Q
PERFECT VABZ ! Many thanks. On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote: > Hi Guys, > > PSA. > > What I am ultimately looking for is a formula that would automatically > return all the information based on three different criterias. > > In cell K1 - The operator has the option of

Re: $$Excel-Macros$$ load graph in userform

2014-09-01 Thread Hilary Lomotey
Hello Experts Just found a temporal solution to my question above however, i wish to have some modification, i managed to get the code below but i modified it with Dim x As Integer where x = Sheet1.Range("P6").Value, however when i select ion it an option for the chart to chart ie eg i select

$$Excel-Macros$$ load graph in userform

2014-09-01 Thread Hilary Lomotey
Hello Experts, i want to load graphs in the userform, i got some codes but its not working, can some please assist with the file attached, the objective is to load the graph in the graph sheet in the userform on the dashboard by selecting the required option. thanks -- Are you =EXP(E:RT) or =NO

RE: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation

2014-09-01 Thread Nitin Balodi
Hi Vaibhav, Jan total will always be in column D and so on. Sent from my Windows Phone From: Vaibhav Joshi Sent: ‎01-‎09-‎2014 10:15 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro