$$Excel-Macros$$ Formual question (creating budget spreadsheet).

2014-02-15 Thread Jason Nielsen
I am having an issue with a particular formula and wanted to get someone to see where the error is in my formula. Essentially what I am trying to do with this formula is this: C2=1 --due date E29 3/14/2014 (pay period_end) A55 =2/28/14 (pay period start) if the day of the due date is less th

$$Excel-Macros$$ Re: randomly select non-contiguous cells in a range vba excel

2014-02-15 Thread Pascal Scalpa
> i have seen we can send files so i have modified the previous post > > thanks > -- 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: randomly select non-contiguous cells in a range vba excel

2014-02-15 Thread Pascal Scalpa
Yes you can try these link in this work book there are vba code which do the job but sometime cells are randomly choosed next to another and that makes a mess between array and fractions which are not not at the good place under the ruler. thanks . Le vendredi 14

Re: $$Excel-Macros$$ randomly select non-contiguous cells in a range vba excel

2014-02-15 Thread ashish koul
can you please share sample workbook On Sat, Feb 15, 2014 at 2:15 AM, Pascal Scalpa wrote: > Hello, how to randomly select non-contiguous cells in a range vba excel > > I have a range A1:AC1 and i would like to randomly select 10 cells in it > non contiguous and then each of these cells will be

Re: $$Excel-Macros$$ mail merge with Cc options

2014-02-15 Thread ashish koul
can u share sample workbook On Fri, Feb 14, 2014 at 1:12 PM, Vijayendra Rao wrote: > Dear Experts, > > I know basic of mail merge and using from several years. > > Now I need to add cc and bcc in mail merge and is it possible to pick the > subject line from excel itself. I want to use the separa

Re: $$Excel-Macros$$ HOW TO RECORD RECOVERY DAY'S

2014-02-15 Thread ashish koul
try attached file On Sat, Feb 15, 2014 at 5:52 PM, SUDHIR VERMA wrote: > no one reply yet. > > please > > > On 14 February 2014 19:46, SUDHIR VERMA wrote: > >> Dear All, >> >> Please help me. >> >> Thanking You >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ HOW TO RECORD RECOVERY DAY'S

2014-02-15 Thread SUDHIR VERMA
no one reply yet. please On 14 February 2014 19:46, SUDHIR VERMA wrote: > Dear All, > > Please help me. > > Thanking You > > -- > 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$$ Months between two dates.

2014-02-15 Thread Naveen Kumar M N
Hi, see this one could be help.. On Thu, Feb 13, 2014 at 8:15 PM, Ahmed Honest wrote: > Dear All, > > Please see below and kindly help. > > Requirement : How to get no. of years, months and Dates between 2 dates. > > Example : > Start date : 1-Oct-2012 suppose in cell A1, > End Date : 30-Jun-20

Re: $$Excel-Macros$$ Months between two dates.

2014-02-15 Thread Naveen Kumar M N
Hi, See how is this attachment.. it could hep... On Thu, Feb 13, 2014 at 8:15 PM, Ahmed Honest wrote: > Dear All, > > Please see below and kindly help. > > Requirement : How to get no. of years, months and Dates between 2 dates. > > Example : > Start date : 1-Oct-2012 suppose in cell

Re: $$Excel-Macros$$ loop to extract balances

2014-02-15 Thread mrExcel4u
Hi Hilary, Try updated one... PFA On Sat, Feb 15, 2014 at 1:17 PM, Hilary Lomotey wrote: > excellent chief, this is what i needed. thanks all for your assistance > > On 2/15/14, Naveen Kumar M N wrote: > > This message is eligible for Automatic Cleanup! ( > naveenkumarmn...@gmail.com) > > >