Re: $$Excel-Macros$$ need macro add Rows

2014-09-14 Thread Vaibhav Joshi
Hi Chek this, corrected bug & added auto complete method.. Cheees!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 13, 2014 at 4:13 PM, Ashish Bhalara wrote: > Dear experts, > > I have column with heading of SR and fillup with 1 to 10. > I need a macro

Re: $$Excel-Macros$$ Macro to extract information from a text file and paste it into columns in excel

2014-09-14 Thread Vaibhav Joshi
Hey See this, click to run macro, when prompted selct video log file... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 13, 2014 at 6:34 AM, Jordan Rees wrote: > Hello everyone; > > I am looking for a simple macro to extract information from a t

$$Excel-Macros$$ Error in filtering two criteria using Auto filter

2014-09-14 Thread Nitin Balodi
Hi All, I have written a VBA Code to filter out data but somehow it isnt working.Code is as below and screenshot of result filter is attached. Range("N1").Select ActiveSheet.Range("A1:N1").AutoFilter Field:=13, Criteria1:="<>0" _ , Operator:=xlAnd, Criteria2:="<>#N/A" If ActiveS

Re: $$Excel-Macros$$ Error in filtering two criteria using Auto filter

2014-09-14 Thread Vaibhav Joshi
Chode seems to be fine. . Check column no. Is it to be filtered on col 13? I.e. Column M? On Sep 14, 2014 6:04 PM, "Nitin Balodi" wrote: > Hi All, > > I have written a VBA Code to filter out data but somehow it isnt > working.Code is as below and screenshot of result filter is attached. > > Ran

Re: $$Excel-Macros$$ Error in filtering two criteria using Auto filter

2014-09-14 Thread Vaibhav Joshi
Change A1:N1 to A1:M1.. Cheers On Sep 14, 2014 6:33 PM, "Vaibhav Joshi" wrote: > Chode seems to be fine. . Check column no. Is it to be filtered on col > 13? I.e. Column M? > On Sep 14, 2014 6:04 PM, "Nitin Balodi" wrote: > >> Hi All, >> >> I have written a VBA Code to filter out data but som

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-14 Thread Pramod Singh
Hi Ujjawal. U want each tym in earch row and save.. When click button. Pramod On 14 Sep 2014 11:46, "Ujjwal Desai" wrote: > Hi Pramod, > > Can you please advise ??. > > Thanks, > Ujjwal > > -- > 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) ! Jo

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-14 Thread Ujjwal Desai
Yes absolutely right. In order to track time for each document # separately. -- 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, accura

$$Excel-Macros$$ Re: Macro Stop start (pause) Timer

2014-09-14 Thread Bill Q
I unfortunately cannot get it to work. Would it be possible for you to modify the macro and attach ? On Monday, 1 September 2014 13:56:01 UTC-4, Bill Q wrote: > > Hi, > > PSA. > > I am looking for two things to be modified with this macro: > > 1. A timer (in seconds) when it gets into the websi

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-14 Thread Pramod Singh
Hi Ujjwal. PFA... Thanks P -- 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

RE: $$Excel-Macros$$ Error in filtering two criteria using Auto filter

2014-09-14 Thread Nitin Balodi
Hi Vaibhav, Thanks working fine, great. But I have a question, Data is filtered but <>#N/A is still not displayed in custom filter view. Is this an excel error? Regards. Yours Sincerely,Nitin Balodi Date: Sun, 14 Sep 2014 18:34:09 +0530 Subject: Re: $$Excel-Macros$$ Error in filtering two cri

RE: $$Excel-Macros$$ Error in filtering two criteria using Auto filter

2014-09-14 Thread Vaibhav Joshi
Hi If your data in that column does not have N/A then it won't be displayed in filter. Cheers On Sep 15, 2014 8:46 AM, "Nitin Balodi" wrote: > Hi Vaibhav, > > Thanks working fine, great. > > But I have a question, Data is filtered but <>#N/A is still not displayed > in custom filter view. Is th

RE: $$Excel-Macros$$ Error in filtering two criteria using Auto filter

2014-09-14 Thread Nitin Balodi
Hi Vaibhav, Thanks for clearing doubts. Regards. Yours Sincerely,Nitin Balodi Date: Mon, 15 Sep 2014 09:39:54 +0530 Subject: RE: $$Excel-Macros$$ Error in filtering two criteria using Auto filter From: v...@vabs.in To: excel-macros@googlegroups.com Hi If your data in that column does not have

Re: $$Excel-Macros$$ Unique values based on two conditions

2014-09-14 Thread Chandra Shekar
Ohk but am using 2010. On Fri, Sep 12, 2014 at 9:51 PM, Vaibhav Joshi wrote: > hi > > yes, if you have excel 2013 you can try DISTINCT function, this will > reduce length of formula... > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Sep 1