$$Excel-Macros$$ Re: Quarter Wise Amount Distribution

2016-04-24 Thread glong
This what you need? On Wednesday, March 30, 2016 at 9:48:27 AM UTC-7, SridharBL wrote: > > Dear Experts. > > I have attached file with explanation. > > I need to equally distribute the Contract Amount, based on "Expected Close > Date" and "Contract period in months" the "Contract Amount". > >

$$Excel-Macros$$ Re: Formula to extract date from cell

2016-04-24 Thread glong
Post a sample spreadsheet pls On Monday, April 4, 2016 at 2:27:31 AM UTC-7, Excel ka Keeda wrote: > > Dear Experts, > > I have some text in a cell like "Date Range: 3/31/16 - 3/31/16" > > I want to extract the date in a another cell like date not as text only. > > Can any one help me with any dyn

Re: $$Excel-Macros$$ OVERFLOW message in VBA

2016-04-24 Thread glong
Just replace this line in the code: *Dim count As Byte* with: *Dim count As Long* On Saturday, April 9, 2016 at 8:56:07 AM UTC-7, GENIUS wrote: > > Sir >> >> you are right but I'm not so expert in the macro, I'm in the learning > process, and as per the following note I don't know what is

$$Excel-Macros$$ Re: Get particular text within text from one cell

2016-04-24 Thread glong
You'll need to submit a sample spreadsheet I think On Monday, April 4, 2016 at 1:58:20 AM UTC-7, vickey wrote: > > Hi, > > I have following text in A1. > > Neha Shah is a Consultant in Laparoscopic & Bariatric Surgery. She has > rich experience in this field. > > I want to extract only "Consultan

$$Excel-Macros$$ Re: Conversation required

2016-04-24 Thread glong
Hi Rohan, How's this? All the best, Graham, -- 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