$$Excel-Macros$$- Query

2014-02-12 Thread Atul Kesaria
Hi Team, I need a help in creating a macro for attached sheet Process Brief:- 1) Need to send email to people based of status as per column AE. If status is "Y: then mail should be send to people as per email ID "To" & "CC" and attachement should be done based on file name in column AB, AC & AD.

$$Excel-Macros$$ Re: how to crack Excel VBA password

2014-02-12 Thread elis smith
> > *You can use this Excel Password Recovery software to recover Excel file > password and unlock Excel spreadsheet brilliantly. Excel Unlocker software > easily crack lost Excel ( xls or xlsx ) > file password and unlock Excel sheet within less time. This is g

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

2014-02-12 Thread nitin kumar
Dear Team, U r just share the Excel Password recovery software but its Not working so please Help Regards, Nitin Kumar Pfa, Regards, Nitin Kumar On Wed, Feb 12, 2014 at 2:57 PM, elis smith wrote: > *You can use this Excel Password Recovery software to recover Excel file >> password and unlo

$$Excel-Macros$$

2014-02-12 Thread Jocky Beta
Hi Group, I need excel based inventory sheet for my office purpose, It would be very helpful if anybody share the same as many templates available on Internet very basic and did not contains full information like Vendor Details, material issue, material received etc.. *Regards* *Jocky* -- Are

$$Excel-Macros$$ plz add me to the group thanks

2014-02-12 Thread sudhansu mohan
-- 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 titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ plz add me to the group thanks

2014-02-12 Thread pankaj MBA
i have received and adding you. On Wed, Feb 12, 2014 at 7:19 PM, sudhansu mohan wrote: > > -- > 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 > >

Re: $$Excel-Macros$$ Border Issue in VBA

2014-02-12 Thread priti verma
you can use only these line change range according to yours- Range("a1").CurrentRegion.borders.Weight = 2 Range("a1").CurrentRegion.BorderAround , xlMedium On Wed, Feb 12, 2014 at 5:43 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > am trying to put borders using vba but am

$$Excel-Macros$$ COUNT OF RECOVERY DAYS

2014-02-12 Thread SUDHIR VERMA
Dear All, Please suggest me to prepare recovery days. Better explanation in attachment. thanking you Sudhir Verma -- 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/discussexc

$$Excel-Macros$$ Help on sumif function

2014-02-12 Thread Shrinivas Shevde
Dear All, Please find attached sheet -- Shrini -- 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 thre

$$Excel-Macros$$ CALCULATE DATE FROM THE GIVEN NUMBER - 25th day Date from today

2014-02-12 Thread KATHIRVELAN N
Dear Friends, I have a number i need to calculate Date. For example: I have a number 25 (Dynamic) I need to calculate 25th day Date from today. Please help!!! Thanks, Kathir -- 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 Fa

$$Excel-Macros$$ Re: Help on sumif function

2014-02-12 Thread Nityananda doley
Use below function sir, =SUMIFS($B$2:$B$22,$A$2:$A$22,">="&$D$6,$A$2:$A$22,"<="&$E$6) Regards, Nitya On Thursday, February 13, 2014 9:28:06 AM UTC+5:30, shrini wrote: > > > Dear All, > > Please find attached sheet > > > -- > Shrini > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

RE: $$Excel-Macros$$ CALCULATE DATE FROM THE GIVEN NUMBER - 25th day Date from today

2014-02-12 Thread Ravinder
=TODAY()+A2 DAYS RESULT 20 5-Mar-14 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KATHIRVELAN N Sent: Thursday, February 13, 2014 10:30 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ CALCULATE DATE FROM THE GIVEN NUMBER - 25t

Re: $$Excel-Macros$$ Help on sumif function

2014-02-12 Thread Dileep Kumar
Dear Shrinivas, Use sumifs for summing ranges based on more than one criteria, sumifs will handile number of criterias for summing ranges. Same like countifs also. If your are summing ranges which are located in othere workbooks better to use sumproduct rather usning sumifs, coz sumifs will not w

RE: $$Excel-Macros$$ Help on sumif function

2014-02-12 Thread Ravinder
=SUMIFS(B2:B22,A2:A22,">="&D6,A2:A22,"<="&E6) OR PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Thursday, February 13, 2014 9:28 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on sumif function

Re: $$Excel-Macros$$ CALCULATE DATE FROM THE GIVEN NUMBER - 25th day Date from today

2014-02-12 Thread KATHIRVELAN N
Thank you so much On Thu, Feb 13, 2014 at 10:40 AM, Ravinder wrote: > =TODAY()+A2 > > > > DAYS > > RESULT > > 20 > > 5-Mar-14 > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *KATHIRVELAN N > *Sent:* Thursday, February 13, 2014 10:30 AM >

Re: $$Excel-Macros$$ Help on sumif function

2014-02-12 Thread Shrinivas Shevde
Dear Dileep and Ravindra Very very Thanks for solution Regards Shrinivas On Thu, Feb 13, 2014 at 10:44 AM, Ravinder wrote: > =SUMIFS(B2:B22,A2:A22,">="&D6,A2:A22,"<="&E6) > > > > OR > > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sh

$$Excel-Macros$$ Codes for SubPart

2014-02-12 Thread arvind sharma Rajendra
hi ppl, i need help. for example my input day is 5 days. i need a code to show 1a 1b 1c 1d 2a 2b 2c . . . . . .5d in this orientation? is this possible? -- 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$$ Codes for SubPart

2014-02-12 Thread pankaj sangotra
Please try this hope this will help.. Sub output() Dim i As Integer, k As Integer, j As Integer k = 1 For i = 1 To 5 For j = 97 To 100 Cells(k, 1).Value = i & Chr(j) k = k + 1 Next Next End Sub On Thu, Feb 13, 2014 at 12:52 PM, arvind sharma Rajendra < arveensharm...@gmai