Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-09-02 Thread Prashant Pednekar
please add me 8308800600 On Mon, Aug 8, 2016 at 9:43 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > please add the my number 9811503853 > > On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: >> >> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you >> wants to

Re: $$Excel-Macros$$ Help Required

2015-05-20 Thread Prashant Pednekar
pls check On Wed, May 20, 2015 at 2:58 PM, Neeraj neerajchauhan...@gmail.com wrote: Dear Experts, Kindly find the sheet and do the needful formula -- 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

Re: $$Excel-Macros$$ Query on Extract word

2015-05-20 Thread Prashant Pednekar
This will work =IFERROR(IFERROR(MID(A2,FIND(MOC,A2,8),7),UPPER(MID(A2,FIND(moc,A2,7),8))),UPPER(MID(A2,FIND(Moc,A2,7),8))) However may of the cases it is written like MOC 9 or MOC - 08 hence some garbage is appearing. you can remove by text to coloumn command. Prashant On Wed, May 20, 2015

Re: $$Excel-Macros$$ Re: Help needed

2015-04-16 Thread Prashant Pednekar
from GEOFORCE,.Hence i have given two pivots and minitab box plot analysis. Hope this will solve your query. Prashant Pednekar. On Wed, Apr 15, 2015 at 10:50 PM, kumar skandan1...@gmail.com wrote: Hi, Any one looked at it? On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote: Hi

Re: $$Excel-Macros$$ Re: Need macro help

2015-03-07 Thread Prashant Pednekar
Dear Mandeep, This was wonderful file. I used it for one of my project. However required one improvement. Tried to see the code, but it is lock hence. need your guidance. - I need to select entire data in sheet. currently it is not taking data after black rows. - The color and formating becomes

$$Excel-Macros$$ MS Excel 2003 to 2010

2013-10-14 Thread Prashant Pednekar
Dear friends We are migrating from MS Excel 2003 to Excel 2010 Dose any one of you has Menu and commond by command comparion in both version.s i.e. 2003 2010 Data Validation ??? Else is anyone has related material. Regards Prashant -- Are you

Fwd: $$Excel-Macros$$ MS Excel 2003 to 2010

2013-10-14 Thread Prashant Pednekar
Good morning all. Sorry ! I did not used *Please help.* in my earlier mail. Request you to help me. Thanks Prashant. -- Forwarded message -- From: Prashant Pednekar prashant...@gmail.com Date: Mon, Oct 14, 2013 at 3:21 PM Subject: $$Excel-Macros$$ MS Excel 2003 to 2010 To: excel

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Prashant Pednekar
On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar prash...@gmail.comwrote: Hi Chaya, Prabhu, Done with a simple macro. Use Control + Shift + A at particular cell where you want to transpose. This you have to to for every entry. In case you want it for mulitiple entries there shall

Re: $$Excel-Macros$$ Unlock Cells on Condations

2013-03-15 Thread Prashant Pednekar
Dear Dave, and other friends. I am using belwo code for locking rows. It is not working. Can you let me know where i am going wrong. my date value is in first column. Private Sub Worksheet_Activate() ActiveSheet.Unprotect Rows(5:1200).Locked = True With Range(A5:A1500) Set r

$$Excel-Macros$$ Want to convert on Text in each cell to rows

2010-07-09 Thread Prashant Pednekar
Hi all I want to convert on Text in each cell to rows ? In each Cell has 50 + numbers one below one. e.g. 09:51:18 09:51:31 09:52:04 There are five such columns. Can any one help me to convert to rows? Regards. prashant --

$$Excel-Macros$$ Re: merging worksheet.

2010-06-05 Thread Prashant Pednekar
If Not MWS Is AWS Then FAR = AWS.UsedRange.Cells(AWS.UsedRange.Cells.Count).Row + 1 LR = MWS.UsedRange.Cells(MWS.UsedRange.Cells.Count).Row MWS.Range(MWS.Rows(NHR + 1), MWS.Rows(LR)).Copy AWS.Rows(FAR) End If Next MWS End Sub On Sat, Jun 5, 2010 at 10:57 PM, Prashant Pednekar prashant

$$Excel-Macros$$ Re:Re: Excel Ppt Interface... Please help..Help.

2010-03-29 Thread Prashant Pednekar
On Fri, Mar 26, 2010 at 3:24 PM, Prashant Pednekar prashant...@gmail.com wrote: On Thu, Mar 25, 2010 at 2:32 PM, Prashant Pednekar prashant...@gmail.com wrote: Dear All, I am having presentation (PPT) of 3 slide. Each slide contains one excel sheet. The last slide will have sum of values

$$Excel-Macros$$ pop up calender in excel cell

2009-09-17 Thread Prashant Pednekar
HI Dose any one have pop up calender in excel cell. Regards, Prashant. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free

$$Excel-Macros$$ Re: Filter problem

2009-09-09 Thread Prashant Pednekar
. On Tue, Sep 8, 2009 at 11:56 AM, Prashant Pednekar prashant...@gmail.comwrote: Dear all Thanks for the knowlege enrichment of excel by you all... I am facing problem with Filter. While filtering data I am not able to see the data after specific cell. See the filter range.bmp. In the file