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

2014-09-15 Thread Chandra Shekar
Ohk but am using 2010. On Fri, Sep 12, 2014 at 9:51 PM, Vaibhav Joshi v...@vabs.in 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

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

2014-09-15 Thread Vaibhav Joshi
Check this, you will be prompted to add only no. of rows new rows will be added at the end! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 12:45 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Thanks to reply Vaibhavji, There

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

2014-09-15 Thread Vaibhav Joshi
Great.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 9:54 AM, Nitin Balodi nitinbal...@live.com wrote: Hi Vaibhav, Thanks for clearing doubts. Regards. Yours Sincerely, *Nitin Balodi* --

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

2014-09-15 Thread Vaibhav Joshi
Ok, then you got to use this since there is no default formula in excel./ Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 12:23 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Ohk but am using 2010. On Fri, Sep 12, 2014 at

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

2014-09-15 Thread Ashish Bhalara
Thank you very much Mr.Vaibhav, ones again u do a marvelous job for me. I also learn new things from your code. Cheers :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Sep 15, 2014 at 1:52 PM,

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

2014-09-15 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 2:42 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Thank you very much Mr.Vaibhav, ones again u do a marvelous job for me. I also learn new things from your code. Cheers :)

$$Excel-Macros$$ Need macro

2014-09-15 Thread Murali Nagarajan
Dear All,I need your valuable help which will be reduce my time to compile data without any errorRequirementMonth on month I received huge data base from my Head office to compile and send the same to Respective managerAll Sheets data

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

2014-09-15 Thread Vaibhav Joshi
HI can you highlight in your code where you want break.. CHeers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 1:25 AM, Bill Q ronsmith...@gmail.com wrote: I unfortunately cannot get it to work. Would it be possible for you to modify the

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

2014-09-15 Thread Mandeep Baluja
Use this if you have data for this month only small and simple =SUMPRODUCT(--((DAY($B$2:$B$15)=DAY(D2 Regards, Mandeep baluja On Friday, September 12, 2014 2:34:42 PM UTC+5:30, Chandru wrote: Hello, How to get unique values based on two conditions. Could you help me in the

$$Excel-Macros$$ For Information

2014-09-15 Thread Mandeep Baluja
Who is Vabz and how much experience he' having ? -- 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$$ Re: Unique values based on two conditions

2014-09-15 Thread Vaibhav Joshi
Hi, This formula will fail to give correct result when you are matching criterion for diff months.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 4:41 PM, Mandeep Baluja rockerna...@gmail.com wrote: Use this if you have data for

Re: $$Excel-Macros$$ Need macro

2014-09-15 Thread Vaibhav Joshi
Hi Check this..Open workbook, Click button to run macro open folder in which you have files to import data you are done.. PS: Keep all excel file in one folder macro will port data one by one from all sheets all workbook. Do let us know if any error.. Cheers!! + *I did not do this

Re: $$Excel-Macros$$ For Information

2014-09-15 Thread Vaibhav Joshi
Hi Myself Vaibhav (vabs), i started working on excel since 2001 learning from that day. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 5:41 PM, Mandeep Baluja rockerna...@gmail.com wrote: Who is Vabz and how much experience he'

Re: $$Excel-Macros$$ Need macro

2014-09-15 Thread Murali Nagarajan
Dear Vaibhav, Thanks for ur reply will revert for clarification. On Monday, September 15, 2014, Vaibhav Joshi v...@vabs.in wrote: Hi Check this..Open workbook, Click button to run macro open folder in which you have files to import data you are done.. PS: Keep all excel file in one

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

2014-09-15 Thread Bill Q
The third break is not needed. The following highlighted in yellow is where I would like the 2 breaks Sub Button1_Click() Dim i As Long, j As Long, k As Long, s As String i = 1 j = 1 Do s = Cells(i, 4).Value If s = Then Exit Do Worksheets(DATA).Select Cells(j, 1) =

$$Excel-Macros$$ Documents for web scraping

2014-09-15 Thread Ganesh N
Dear team, I am learning web scraping where I can find the advanced documents/pdf books or file. Thanks Regards, Ganesh N -- 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 @

$$Excel-Macros$$ Get photographs name

2014-09-15 Thread Deepak Rawat
Hi, I need to get photograph names in excel I tried , i insert all the pictures in to excel and run the below macro but its givint names like Picture 1, Pcture 2.. But i need the actural picture name (I think we say it caption name) Kindly provide the solution Sub GetShapeNames() Dim