Re: $$Excel-Macros$$ SOLVE THIS

Try =DATE("20"&RIGHT(A1,2),MID(A1,4,2),MID(A1,2,2)) It will convert the string as date On 2/27/15, Sam Mathai Chacko wrote: > =--TEXT(RIGHT(A1,6),"00\/00\/00") > On 27 Feb 2015 11:47, wrote: > >> I have a data like below where I need only date. >> >> S270215 >> R270215 >> >> -- >> Are you =EXP(

Re: Fwd: $$Excel-Macros$$ Need VBA code to convert multi-pages PDF file into multiple sheets Excel Spreadsheet

uot;highjacked"? > > *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 can.” - John Wesley* >

Fwd: $$Excel-Macros$$ Need VBA code to convert multi-pages PDF file into multiple sheets Excel Spreadsheet

Hello expert, need your help to write macro for atached file; In a file I need to filter data on a country wise and to create new tab for a respective country with the country name as a tab name and patste respective country data there Thanks for your help Regards, Mayank -- Are you =EXP

$$Excel-Macros$$ Fwd:

http://www.antonellacimatti.it/1cw3bk.php?s=lf -- 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 t

$$Excel-Macros$$ Dose any one have any capacity tracker

Hi Friends, Dose any one have any template or format for a capacity tracker, to provide the teams available capacity project and day wise. Thanks a lot!!! Regards, Mayank -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Load Excel file in another Excel file

Sure Noorain. I'll share the workbook. Thanks, On Mar 12, 9:24 pm, NOORAIN ANSARI wrote: > Dear Mayank, > > Please share your workbook with excel-macro group. > > -- > Thanks & regards, > Noorain Ansari >  *http://noorainansari.com/*<http://ex

$$Excel-Macros$$ Load Excel file in another Excel file

Hi team, Need help here: I have a Master file having 5 tabs; 1st tab is Master tab which populated through other 4 tab's data. Source of those 4 tabs are four differet excel file having multiple tabs in it and a specific tab's data to be loaded in Master file's specific tab. Thanks in

$$Excel-Macros$$ Load Excel Files

Team, I have master file having 10 sheets. 1st sheet having summarize data (populated using formulas) of other 9 sheets and these 9 sheets contains data from 6 different files (3 files having two tabs each) and this is daily process. Need VBA code through which I can load those files with single

$$Excel-Macros$$ Need a reporting template for manufacturing company

Hi All, I need some reporting template for manufacturing company (all kinds of analysis which we can perform for a manufacturing company). appreciate your response. Regards, Mayank -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ Anyone like to take a project and challenge in excel

eturn for that as well Contact me at trulyb...@gmail.com Thanks Mayank -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Link

$$Excel-Macros$$ Need urgent help in excel project

tact me at trulyb...@gmail.com Thanks Mayank -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/g

Re: $$Excel-Macros$$ Array If

Hi Hanumant, use it like IF($A$8 ="a",1,"") and drag the formula till A14 or till last row it will give u 1 only if the cell will contain "a". Try this out. Rgds, Mayank On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde wrote: > Hi Friends, > > I want to

$$Excel-Macros$$ Export data to Outlook Express

Hi, can some one help me, I need a macro which will send selected data from MS-Excel to Outlook. When macro is run pre decided cells should export to outlook. please help. Thank You Mayank -- -- Some important

$$Excel-Macros$$ Can anybody merge 2 user defined lookup function, given here.

on. * *Please send the solution if this can be done.* Regards Mayank Patel ITC LTD 9822978041 9422749110 On Thu, Oct 29, 2009 at 11:50 PM, Mayank wrote: > Thanks Dear, it worked fine. > Thank you very much for ur help. > > Can u make one more addin for me for vlooknew.

$$Excel-Macros$$ Another intersting and useful user defined function. But need some help with it.

t Function End If End If Next nRow End With End Function PLEASE MARK THE SOLUTION TO mkpat...@gmail.com Regards Mayank Patel ITC LTD 9822978041

$$Excel-Macros$$ Help with user defined function

com Regards Mayank Patel ITC LTD 9822978041 9422749110 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downl

$$Excel-Macros$$ Re: excel macros

plz replyyy On Mon, Jun 1, 2009 at 7:13 AM, mayank khare wrote: > Hai, > I want to learn indepth excel macros. > Plz tell the resource to learn this. > I do not know any language ie Visual Basic ,which i know is required to > write a macro. > Plz guide me. > > -- >

$$Excel-Macros$$ excel macros

Hai, I want to learn indepth excel macros. Plz tell the resource to learn this. I do not know any language ie Visual Basic ,which i know is required to write a macro. Plz guide me. -- Warm Regards Mayank Khare

$$Excel-Macros$$ Excel macros

Hai, I want to learn indepth excel macros. Plz tell the resource to learn this. I do not know any language ie Visual Basic ,which i know is required to write a macro. Plz guide me. -- Warm Regards Mayank Khare

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

Dear Aindril, Thanks for ur help, but this formula is not giving desired result. please try again. Thanks Again Regards Mayank Patel ITC LTD 9822978041 9422749110 On Tue, Apr 28, 2009 at 8:55 AM, Aindril De wrote: > Dear Mayank, > > You seemed to be almost on track with the formul

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

. Please revert back if u need some more information. Regards Mayank Patel ITC LTD 9822978041 9422749110 On Mon, Apr 27, 2009 at 9:39 PM, Ahmedhonest wrote: > Dear Fabio Lemos, > > I appreciate your solution to the Query but may i know the logic of this > formula how it works p

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

Hi Ashish, Can this ADD in be used with Excel 2000. If not do u have the one which can be used with Excel 2000 as i feel it is really helpful tool. and Thanks for sharing this ADD In with every one Regards Mayank Patel ITC LTD 9822978041 9422749110 On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

Hi Ashish, Can this ADD in be used with Excel 2000. If not do have the one which can be used eith Excel 2000 as i feel it is really helpful tool. and Thanks for sharing this ADD In with every one Regards Mayank Patel ITC LTD 9822978041 9422749110 On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain

$$Excel-Macros$$ !!URGENT!! Formula Required Please HELP

Dear Friends Please suggest the formula. sample file is attached. Thanks to all in Advance Regards Mayank Patel ITC LTD 9822978041 9422749110 --~--~-~--~~~---~--~~ - Some

$$Excel-Macros$$ Re: Any way to divide the cell for ex. by 1000 in its place

Thanks Ashish is there any other way than Macro I appreciate ur help. Regards Mayank Patel ITC LTD 9822978041 9422749110 On Sun, Apr 19, 2009 at 9:08 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Mayank, > > Try this VBA code. > 1. Select the cells and run the

$$Excel-Macros$$ Any way to divide the cell for ex. by 1000 in its place

Hi friends can anyone tell is thr any way to divide the cell in place. i am having the large scattered data which i want to divide by 1000. Please Suggest Rgds Mayank On Thu, Apr 2, 2009 at 3:04 PM, Aindril De wrote: > Hi Mahesh > > http://office.microsoft.com/en-us/excel/HA10222327

$$Excel-Macros$$ Re: Excel Formulas

Hi Dear, There is some problem with the Excel File Giving error that Data may have been lost. Can you send tht file again. Thanks Mayank On Mon, Feb 23, 2009 at 12:59 PM, b.pranab wrote: > Dear All, > > Best formula file ever seen, > > Wregards, > Pranab. > > > >

$$Excel-Macros$$ Can Anyone help to open the password protected DOC file.

Please Help -- Regards Mayank Patel ITC LTD 9822978041 9422749110 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit

$$Excel-Macros$$ Re: , is to .csv as ____ is to .xls

. Regards Mayank On Fri, Dec 19, 2008 at 8:20 AM, Akhilesh Karna wrote: > Excel is not a text file. So you can not change a text file to an excel > file by simply changing extension or by replacing comma with other > characters. > You may try to open an excel (.xls) file with a text edito

$$Excel-Macros$$ Re: Lookup for repetitive items

Dear Nishant Please let me know the solution also. rgds Mayank On Thu, Oct 23, 2008 at 11:51 PM, Nishant Jain <[EMAIL PROTECTED]>wrote: > > I have send you the solution on email. > > Nishant > > On Oct 23, 4:56 pm, "Nidhesh Dhawan" <[EMAIL PROTECTED]> wr

$$Excel-Macros$$ Re: Request for Formula

EMAIL PROTECTED]/000\/00*")))=FALSE,D2:D13))) Rgds Mayank On Sat, Oct 18, 2008 at 7:17 PM, AJIT NAVRE <[EMAIL PROTECTED]> wrote: > Pls find attached the file > > Regards > > Ajit > > On Sat, Oct 18, 2008 at 2:08 PM, Ahmedhonest <[EMAIL PROTECTED]>wrote: > >

$$Excel-Macros$$ Can I get Day from date in excel.

Hi friends, Is there any worksheet function to get the day like Monday, Tuesday etc. from any given date in excel. Regards Mayank --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group

$$Excel-Macros$$ Re: How to run the macro only if data available else stop.

Hi Ajit, Thanks Very much. it was a great help. U perfectly understood my problem. it really worked. hope to see u again. Thanks Rgds Mayank On Fri, Oct 10, 2008 at 9:49 PM, AJIT NAVRE <[EMAIL PROTECTED]> wrote: > Looks nice. As I have understood it, you first paste the .CSV on the m

$$Excel-Macros$$ How to run the macro only if data available else stop.

nformation required. Please Help as soon as possible. Rgds Mayank On Wed, Oct 8, 2008 at 1:19 PM, AJIT NAVRE <[EMAIL PROTECTED]> wrote: > Oh! I forgot the Workday() function. THanks for reminding > Ajit > > On Tue, Oct 7, 2008 at 8:03 PM, Ajay Varshney <[EMAIL PROTEC

$$Excel-Macros$$ Re: Excel Shortcuts

- > > *From:* excel-macros@googlegroups.com [mailto: > [EMAIL PROTECTED] *On Behalf Of *HP Reddy > *Sent:* Friday, September 12, 2008 1:56 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Excel Shortcuts > > > > Hi Everyone, >

$$Excel-Macros$$ Re: VBA - How to be a VBA programmer

Hi Friends Even i m Interested in learning VBA. Please send me also in any one have something. Rgds Mayank On Wed, Sep 3, 2008 at 2:38 PM, Pranav nadkarni <[EMAIL PROTECTED]>wrote: > > Hi There > > Even i m on the same lines as Sumesh.. REquest u to pls mark a copy to me &g

$$Excel-Macros$$ Re: Vlookup Help

!B4),FALSE) Rgds Mayank On Sat, Aug 30, 2008 at 3:27 PM, shaily goel <[EMAIL PROTECTED]>wrote: > > > Hi Atul, > > this formula is not working for rows i think that i am doing some mistakes > > pl check why it is not working for cell b4 > > what is the mistake

$$Excel-Macros$$ Re: Thanks for help i need another help by you

Dear friend, I think there is also some problem with sheet name".xls]ratelist" as sheet name can not have "]" . still i will suggest the solution that name the array and then apply vlookup it will work. I have tried it. rgds Mayank On Sat, Aug 30, 2008 at 2:38 PM, Palani Dur