Re: $$Excel-Macros$$ Date Format Query

2014-06-17 Thread Pravin Gunjal
Yes rightly said. The file which has been downloaded from software isn't having proper systems date format. So I would like to make it in DD.MM. (2.2.4 digits) Kindly do the needful. On Mon, Jun 16, 2014 at 5:19 PM, Paul Schreiner schreiner_p...@att.net wrote: Guys: I started with the

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
Hi, Thanks for the providing me the solution. But I received sheet 1 file on daily basic in new sheet in that case this file is not working. it would be very helpful if you provide me solution on this Regards On 6/17/14, Vaibhav Joshi v...@vabs.in wrote: Hi Use this file. Cheers!! On

$$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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 @

Re: $$Excel-Macros$$ Help Needed

2014-06-17 Thread Dhaval Shah
fyi Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Vaibhav Joshi
I didnt get you what you are trying to say! On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta jocky6...@gmail.com wrote: Hi, Thanks for the providing me the solution. But I received sheet 1 file on daily basic in new sheet in that case this file is not working. it would be very helpful if you

Re: $$Excel-Macros$$ Date Format Query

2014-06-17 Thread Vaibhav Joshi
hi.. if data imported is in date then by using data text t o column you can do easily.. Refer my earlier email.. On Tue, Jun 17, 2014 at 12:19 PM, Pravin Gunjal isk1...@gmail.com wrote: Yes rightly said. The file which has been downloaded from software isn't having proper systems date

Re: $$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
Thanks Brother, But how you Did this. Please explain the process. On Tue, Jun 17, 2014 at 1:02 PM, Dhaval Shah todhavals...@gmail.com wrote: fyi Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Tue, Jun 17, 2014 at 12:51 PM, Rakesh

$$Excel-Macros$$ Needs help in Data validation

2014-06-17 Thread Rakesh kumar
PFA -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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$$ Date Format Query

2014-06-17 Thread Pravin Gunjal
This is working perfectly as per my requirement. Thanks. Regards Pravin Gunjal. On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Hi Pravin ... You can go to Format cell and custom the format of the date which ever result you

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
Hi every time I received new sheet from my colleague in. That situation your sheet not working Regards On 6/17/14, Vaibhav Joshi v...@vabs.in wrote: I didnt get you what you are trying to say! On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta jocky6...@gmail.com wrote: Hi, Thanks for the

$$Excel-Macros$$ Auto update Data, Row Columns

2014-06-17 Thread Rajeev
Dear Experts, Please find attached file and please do the needful as per mentioned in the file. Thanks / Regards, Rajeev -- 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 @

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Vaibhav Joshi
Hi Try second file which i sent today, pl note..either data structure or heading should be unique.. I have prepared second sheet assuming data structure will be same..For working 1st file you need to have same headings in both input output file. Do let me know where exactly you are finding

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-17 Thread Rohan Young
thanks a lot bro, this is awesome and that's i need very-2 thanks bro On Thu, Jun 12, 2014 at 10:22 PM, Vaibhav Joshi v...@vabs.in wrote: PFA You need to customize send key letters to get desired output. Cheers!! On Thu, Jun 12, 2014 at 5:34 PM, Rohan Young rohan.j...@gmail.com wrote:

$$Excel-Macros$$ Urgent required Python Developer - San Jose, CA

2014-06-17 Thread Gary .
Please respond to *gurjant.si...@damcosoft.com gurjant.si...@damcosoft.com* *Position: Python DeveloperLocation: San Jose, CADuration: 6 months, possibility of extension* Required Skills: •4+ years Python experience. •2+ years Django •2+ years JS with experience on MV*

$$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread pankaj khairanar
Hi Expert, I want excel formula for below scenario. Date-9=result If result=saturday or sunday then omit saturday or sunday and consider monday. Extample1 02/June/14 - 9=Saturday, May 24, 2014 Want to omit this saturday and sunday want result as Monday, May 26,2014 Extample2

Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread Paul Schreiner
Here we can make use of a couple of different concepts: #1) Excel stores dates as numbers (the number of days since 1/1/1900).   So, if your date (June 3, 2014) is in cell A1, the date 9 days previous to that is A1-9   #2) The Excel function Weekday() returns the day number of the weekday.  

$$Excel-Macros$$ Urgent required .Net developer - Dublin, OH

2014-06-17 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com gurjant.si...@damcosoft.com* *Position: .Net developerLocation: Dublin, OHDuration: 3 to 6 months (Extendable)* Visa: US/GC/EAD only Revised skills: What we would need: 1. Object Oriented Programming 2. .NET C# a. Generics,

Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread pankaj khairanar
Thanks Paul! Got the solution and as well knowledge! Regards, Pankaj On Tuesday, June 17, 2014 8:43:44 PM UTC+5:30, Paul Schreiner wrote: Here we can make use of a couple of different concepts: #1) Excel stores dates as numbers (the number of days since 1/1/1900). So, if your date (June 3,

Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread hari kumar
Networkdays( stdate, end date,[holidays] Thanks Regards Hari Kumar Our strength grows from our weakness. On Jun 17, 2014 10:28 AM, pankaj khairanar pankajkh...@gmail.com wrote: Hi Expert, I want excel formula for below scenario. Date-9=result If result=saturday or sunday then omit

$$Excel-Macros$$ Urgent required Java developer (Scala) - Indianapolis,IN

2014-06-17 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com gurjant.si...@damcosoft.com* *Position: Java developer (Scala)Location: Indianapolis,INDuration: 6-12 Months* *Position: 10* This is an immediate requirement and interview can happen immediately with next day join date. JD: Strong functional