Re: $$Excel-Macros$$ split text by pipe sign

2014-10-13 Thread Vaibhav Joshi
cheers man... + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 3:46 PM, Waseem Saifi wrote: > thank you vaibhav, > > it's perfect > > On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi wrote: > >> check this... >> >> + >> *I did not do this for

Re: $$Excel-Macros$$ Report

2014-10-13 Thread Vaibhav Joshi
welcome bro.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 3:23 PM, joseph camill wrote: > Thank you Vaibhav > > On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi wrote: > >> Thanks bro... >> On Oct 12, 2014 6:05 PM, "Ashish Kumar"

Re: $$Excel-Macros$$ Sort VBA required

2014-10-13 Thread amar takale
Dear Poul sir Thank you so much for your code, for the effort and time dedicated.Output came as per my mind & now I am very happy. Thanks sir once again Regards On Mon, Oct 13, 2014 at 7:44 PM, Paul Schreiner wrote: > I thought I'd sent this, but it looks like I did not. > If you create an Aut

Re: $$Excel-Macros$$ Job Opening for MIS profile.

2014-10-13 Thread Tarun Verma
Hi Pramod, Please share job location & description. Regards, Tarun Verma On Wednesday, October 8, 2014 10:34:15 AM UTC+5:30, pramodb35 wrote: > > Hi All. > > I have also one Opning in my company. As MIS profile. > > Salary 19 k and pickup and drop and also meals . > > Regards > Pramod > > Pr

Re: $$Excel-Macros$$ Help in Time Tracker

2014-10-13 Thread Paul Schreiner
As you undoubtely noticed, the number 8.45 does NOT represent 8 hours and 45 minutes, but 8 hours and .45 of an hour, which is 8 hours and 27 minutes. you cannot simply subtract these number and interpret the numbers as time. Now, to excel, a DATE is actually the number of days since 1/1/19

$$Excel-Macros$$ Help in Time Tracker

2014-10-13 Thread Vijayendra Rao
Dear Experts, Can you please help me to convert time to numbers. Attached is the my file and my formula is showing some wrong numbers. Request you to help on the same. Regards, Vijayendra 94491 67631 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:O

Re: $$Excel-Macros$$ Sort VBA required

2014-10-13 Thread Paul Schreiner
I thought I'd sent this, but it looks like I did not. If you create an AutoFilter, then your buttons can simply apply the filter (as attached) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At

Re: $$Excel-Macros$$ Sort VBA required

2014-10-13 Thread amar takale
Dear Ganesh Sorry for late reply but Actually I want result Single sheet not another sheet. Regards Amar On Fri, Oct 10, 2014 at 9:32 PM, Ganesh N wrote: > Dear Amar, > > PFA. Just try now. If you have any concern let me know. > > Regards, > Ganesh N > > On Fri, Oct 10, 2014 at 4:38 PM, amar t

Re: $$Excel-Macros$$ Need a macro to get consolidated report

2014-10-13 Thread Vaibhav Joshi
can you share sample for conso file too.. + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 1:27 AM, Ujjwal Desai wrote: > Hello , > > I am in need of a macro which will help me to get a consolidated report of > daily data saved in the folder. >

Re: $$Excel-Macros$$ excel add-in to .exe

2014-10-13 Thread Paul Schreiner
What is it you're trying to do? The reality is: macros in excel are written in VBA Which is Visual Basic for APPLICATIONS. That means, that is initially Visual Basic, with features added depending on the Application. For instance, the all cells of an Excel worksheet are selected using the C

Re: $$Excel-Macros$$ Re: Need Macro enabled Button to select Filter Values

2014-10-13 Thread Paul Schreiner
Why were you not able to change the captions? Do you need help with that? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-13 Thread Waseem Saifi
thank you vaibhav, it's perfect On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi wrote: > check this... > > + > *I did not do this for you. God is here working through me for you.* > > On Sun, Oct 12, 2014 at 11:08 AM, Waseem Saifi > wrote: > >> Hi Vaibhav, >> >> I want through formula. nor

Re: $$Excel-Macros$$ Report

2014-10-13 Thread joseph camill
Thank you Vaibhav On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi wrote: > Thanks bro... > On Oct 12, 2014 6:05 PM, "Ashish Kumar" wrote: > >> Hi Vaibhav Bhai, >> >> Nice Solution. Sheet is working Great. >> >> >> Regards >> Ashish >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And