$$Excel-Macros$$ save active sheet in new workbook

2014-09-10 Thread Rupesh Patil
Hello Expert, I need your help. I need VBA Macro. How to save active sheet to new workbook with same sheet name in specific location. -- Thanks & Regards, Rupesh Patil, -- 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 p

Re: $$Excel-Macros$$ Convert IF formula to VBA

2014-09-10 Thread Mr_Bill
If I understood you correctly this might work for you Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim Days As Integer, result As String If Target.Address = "$A$2" Then Days = Range("A2").Value If Days >= 180 Then result = "181 days up" ElseIf Days > 90 Then result = "91-180

$$Excel-Macros$$ Fwd: Form design with filter

2014-09-10 Thread daya p
-- Forwarded message -- From: daya p Date: 10 September 2014 18:27 Subject: Form design with filter To: excel-macros@googlegroups.com Sir, i need help to create form as exactly as data in below web site i want 2 forms of 2 website sample data links :( pls check for reference mak

Re: $$Excel-Macros$$ Convert IF formula to VBA

2014-09-10 Thread 'DanJ' via MS EXCEL AND VBA MACROS
Hi, I would like VBA to perform the test and enter the result. DanJ On Wednesday, September 10, 2014 7:24:49 PM UTC+8, Paul Schreiner wrote: > > Are you saying that: > 1) you'd like to use VBA to insert the =IF() statement? > 2) or that you'd like VBA to perform the test and enter the result?

Re: $$Excel-Macros$$ Convert IF formula to VBA

2014-09-10 Thread 'DanJ' via MS EXCEL AND VBA MACROS
Hi Paul, Sorry, if my question is vague. I would like VBA to perform the test and enter the result. Thanks. DanJ On Wednesday, September 10, 2014 7:24:49 PM UTC+8, Paul Schreiner wrote: > > Are you saying that: > 1) you'd like to use VBA to insert the =IF() statement? > 2) or that you'd like

$$Excel-Macros$$ Re: Introduce Yourself !!

2014-09-10 Thread Julian George
Hi All, I am Julian from hyderabad excel enthusiastic like all you guys hereworking as a analyst... -- 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/discussexce

RE: $$Excel-Macros$$ Error in Filtering Data using VBA

2014-09-10 Thread Nitin Balodi
Hi Vaibhav, Thanks for the solution. Its working fine. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Mon, 8 Sep 2014 23:12:00 +0530 Subject: Re: $$Excel-Macros$$ Error in Filtering Data using VBA To: excel-macros@googlegroups.com Hi FA, cheers!!+I did not do this for you. Go

Re: $$Excel-Macros$$ Convert IF formula to VBA

2014-09-10 Thread Paul Schreiner
Are you saying that: 1) you'd like to use VBA to insert the =IF() statement? 2) or that you'd like VBA to perform the test and enter the result? 3) or that you'd like a VBA function to perform the test and return the result? Paul - “Do all the good you can,

Re: $$Excel-Macros$$ Looking for help creating a link to a link in Excel (2007)

2014-09-10 Thread Vaibhav Joshi
Hi for a sake of more convenience can you share sample book with Index sheet and 2 or 3 monthly sheet. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Sep 10, 2014 at 6:15 AM, Jeff Mitchell wrote: > I am hoping somebody can help me resolve a problem

Re: $$Excel-Macros$$ Count ATM ID WITH FOURMULA

2014-09-10 Thread Chandan Bisht
Hi try anyone of below.. =SUMPRODUCT(--($B$2:$B$820=$O11)*($C$2:$C$820=P$10)) or =COUNTIFS($B$2:$B$820,$O11,$C$2:$C$820,P$10) Thankx & Rgds, Chandra Singh Bisht Ph -: 09818724321 On Wed, Sep 10, 2014 at 12:30 PM, Saleem Ansari wrote: > Dear Sir, > > Please Find The Attachment > > Please

Re: $$Excel-Macros$$ Convert IF formula to VBA

2014-09-10 Thread Vaibhav Joshi
Hi You can use fill down method to copy formula to succeeding rows.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Sep 10, 2014 at 12:05 PM, 'DanJ' via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> wrote: > Dear Everyone, > > I want to c

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

2014-09-10 Thread Saleem Ansari
Dear, Formula Noe Work Properly On Monday, September 8, 2014 12:03:57 AM UTC+5:30, Suyog Kulkarni wrote: > > Dear Saleem, > > Find attached excel created by me & already shared in group. This is the > same attaching for your ready ref. I've used only & only formulas to > convert digit into wor