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 wrote: > Thanks to reply Vaibhavji, > There are some error occur if

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 wrote: > Hi Vaibhav, > > Thanks for clearing doubts. > > > > Regards. > > Yours Sincerely, > *Nitin Balodi* > > > -- > Date: Mon,

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, 201

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, V

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 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 :) > > Regards. > Ashish Bhalar

$$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 forma

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 wrote: > I unfortunately cannot get it to work. Would it be possible for you to > modify the macro and attach ?

$$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 thread

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 wrote: > Use this if you have data for this month only small

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 t

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 wrote: > Who is Vabz and how much experience he' having ? > > -- > Are

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 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 folder &

$$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) = Worksheets("U

$$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 @ https://www.facebook.com/d

$$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 shp

Re: $$Excel-Macros$$ Get photographs name

2014-09-15 Thread Vaibhav Joshi
can you share sample excel file + *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at 11:10 AM, Deepak Rawat wrote: > 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

Re: $$Excel-Macros$$ Get photographs name

2014-09-15 Thread Deepak Rawat
there is no sample file i have I will import some pictures from a folder n get the name of that images Regards, On Tue, Sep 16, 2014 at 11:58 AM, Vaibhav Joshi wrote: > can you share sample excel file > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, S

Re: $$Excel-Macros$$ Get photographs name

2014-09-15 Thread Vaibhav Joshi
Is your pic stored in folder & you want to list name of that pics?? + *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at 12:20 PM, Deepak Rawat wrote: > there is no sample file i have > I will import some pictures from a folder n get the name of tha