Re: $$Excel-Macros$$ Urgent need Client in Olmsted Falls, OH need Oracle SCM/WMS consultant

2015-11-11 Thread Ankit Mehra
Hi Madhu, Myself Ankit Mehra and I am a non IT individual. I am looking for a non IT related job in US. If you could assist me in contacting the concerned individual, I will appreciate that. Thanks, Ankit Mehra On 12 Nov 2015 12:57 am, "MADHU-GenuineItLlc" <nandimadh...@gmail.com&

Re: $$Excel-Macros$$ I Need help.. need someone to write up a macro for me...please!! lol

2014-02-08 Thread Ankit Mehra
Hi Joe, In order to do so, an user form needs to be created which will ask for a user name and password. Once the individual specifies the credentials, user will be able to work on this. If you could share the file, this can be done. Thanks, Ankit Mehra On 8 Feb 2014 13:32, Joe Rainone rainon

$$Excel-Macros$$ Export table data from outlook body to excel files

2014-02-06 Thread Ankit Mehra
*US015* 20566848 165,797.27 10-Jan-14 14-Jan-14 *US023* 20566852 $120,297.86 10-Jan-14 20-Jan-14 *US077* 20566850 $266,247.26 10-Jan-14 10-Jan-14 Thanks Regards Ankit Mehra -- 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

Re: $$Excel-Macros$$ Export table data from outlook body to excel files

2014-02-06 Thread Ankit Mehra
that those mails information is not copied again in the file. Please suggest. Thanks, Ankit Mehra On 7 Feb 2014 00:01, koul.ash...@gmail.com wrote: Hi Ankit Save the outlook mail as word document and then open the document and copy content and paste it in excel You need to automate above

Re: $$Excel-Macros$$ Un protect the excel file

2013-07-23 Thread Ankit Mehra
, visit https://groups.google.com/groups/opt_out. -- Thanks Regards Ankit Mehra -- 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

$$Excel-Macros$$ Re: Count of Colored Cells

2009-09-15 Thread Ankit Mehra
Hi Pooja, Please find attached the file as per your requirement. Please let me know if you have any questions. Thanks Regards, Ankit Mehra On Tue, Sep 15, 2009 at 11:15 AM, Pooja Sharma vatspoojav...@gmail.comwrote: Hi Friends, I have a query regarding counting of Colored cells. I want

$$Excel-Macros$$ Re: Hii

2009-07-21 Thread Ankit Mehra
Hi Ruchi, Attached is the solution. I am presuming that the data in the yellow cell is extracted with the time inputted in the adjacent cell. Please let me know if you have any questions. Thanks Regards Ankit Mehra On 7/20/09, Ruchi Saxena ruchi.saxe...@gmail.com wrote: Hi friends, i m

$$Excel-Macros$$ Re: Urgent Help required!!!! Please help!!!

2009-06-29 Thread Ankit Mehra
that there is only one sheet (sheet 1 which has the data) and therefore, sheet 3 is created by macro. Please let me know if you have any questions. Thanks a lot again for your support. You Rock!!! Thanks Regards Ankit Mehra On 6/29/09, Dilip Pandey dilipan...@gmail.com wrote: Hi Ankit

$$Excel-Macros$$ Execution of command button in specified column

2009-06-25 Thread Ankit Mehra
or the solution to the above mentioned query. I hope my query is clear. Please let me know if you have any questions. -- Thanks Regards Ankit Mehra --~--~-~--~~~---~--~~ - Some

$$Excel-Macros$$ Re: Detect duplicate values that have the same value except the last digit

2009-06-25 Thread Ankit Mehra
, then this formula is not working. Would request you to kindly provide a formula that is equally applicable for the above mentioned scenario. Please let me know if you have any questions. Thanks Regards, Ankit Mehra On 6/24/09, Dilip Pandey dilipan...@gmail.com wrote: Hi Ankit, Try below

$$Excel-Macros$$ Detect duplicate values that have the same value except the last digit

2009-06-24 Thread Ankit Mehra
not delete 123 and delete 123A,123B,123C. I hope my query is clear. Please let me know if you have any questions. -- Thanks Regards Ankit Mehra --~--~-~--~~~---~--~~ - Some important

$$Excel-Macros$$ Re: vlookup urgent help

2009-06-20 Thread Ankit Mehra
= =IF(VLOOKUP(RC[-2],Sheet1!C[-2]:C,2,0)=RC[-1],VLOOKUP(Sheet2!RC[-2],Sheet1!C[-2]:C,3,0),No Match) Place this code in a cell of Amount. Please let me know if you have any questions. Thanks Regards Ankit Mehra On Sat, Jun 20, 2009 at 2:24 PM, ankur ankurpande...@gmail.com wrote: Dear Members i

$$Excel-Macros$$ Help Required - Urgently

2009-06-03 Thread Ankit Mehra
the selection is changed in Col A. This is very important as by doing this i would be able to save an ample time in my work. Thanks Regards Ankit Mehra --~--~-~--~~~---~--~~ - Some