Re: $$Excel-Macros$$ Report

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

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 v...@vabs.in 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 waseemsa...@gmail.com wrote: Hi Vaibhav, I want

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

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

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 ujjwal1...@gmail.com wrote: Hello , I am in need of a macro which will help me to get a consolidated report of daily data saved

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 ganeshg...@gmail.com wrote: Dear Amar, PFA. Just try now. If you have any concern let me know. Regards, Ganesh N On Fri, Oct 10, 2014 at

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

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

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

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 Pramod On 8