Re: $$Excel-Macros$$ Kindly help on multiplication table macro

check the attachment see if it helps On Sun, Jun 3, 2012 at 3:57 PM, Aruna jayaram wrote: > Hi > > I want help to create a macro where in the first sheet A1 cell we specify > the number for which the multiplication table should be generated (i.e., 5 > means 5 multiplication ) and in the 2nd shee

$$Excel-Macros$$ Kindly help on multiplication table macro

Hi I want help to create a macro where in the first sheet A1 cell we specify the number for which the multiplication table should be generated (i.e., 5 means 5 multiplication ) and in the 2nd sheet A1 specify the range ( 10 i.e, 5*1 till 5*10) and in the 3rd sheet display the table. Kindly help.

RE: $$Excel-Macros$$ Kindly help me with my question on Excel

HI, Do you want this : Format : HH:MM:SS =TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())+20) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aruna jayaram Sent: Mar/Fri/2012 12:27 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Kindly

RE: $$Excel-Macros$$ Kindly help me with my question on Excel

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Friday, March 02, 2012 2:05 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Kindly help me with my question on Excel Suppose you Enter actual date on D2 Cell

Re: $$Excel-Macros$$ Kindly help me with my question on Excel

Suppose you Enter actual date on D2 Cell enter this formula where you want this result =IF(VALUE(TEXT(D2,"SS"))>30,TIME(TEXT(D2,"HH"),MOD(TEXT(D2,"[m]"),60)+1,0),TIME(TEXT(D2,"HH"),MOD(TEXT(D2,"[m]"),60),0)) On Fri, Mar 2, 2012 at 12:26 AM, Aruna jayaram wrote: > Kindly help me with my ques

$$Excel-Macros$$ Kindly help me with my question on Excel

Kindly help me with my question on Excel i.e., I have time in the format 01:02:40 ( hh:mm:ss) but I want the time to be shown as 01:03 i.e., seconds to be rounded off to minutes. And if you have any files on visual basic 2008 with examples that I can use to learn with screenshots and codes. Please

Re: $$Excel-Macros$$ Kindly Help

Hi Vijay, See attached if helps... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Thu, Nov 17, 2011 at 2:24 PM, vijayKumar wrote: > Dear Friends, > > Request you to help me on a Query of Open Office Excel. > > The Query is

$$Excel-Macros$$ Kindly Help

Dear Friends, Request you to help me on a Query of Open Office Excel. The Query is as fallows. 1. Can we protect the sheet as we do protect worksheet in XL. 2. Request you to help me in creating a macro to consolidate 40 files(Open Office Excel) in a XL sheet(2007). 3. All Heading o

Re: $$Excel-Macros$$ Kindly Help

= Mid(c, f1, f2 - f1) Next End Sub Don Guillett SalesAid Software dguille...@gmail.com From: XLS S Sent: Friday, October 21, 2011 10:21 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Kindly Help please send the example... On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 wrote:

Re: $$Excel-Macros$$ Kindly Help

if this is a fix. then use countif see the attachment On Fri, Oct 21, 2011 at 8:51 PM, XLS S wrote: > please send the example... > > > On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 wrote: > >> Dear All, >> >> Need your help to extract some specific text. >> >> Exam. >> Govt I Grade College, Pasha

Re: $$Excel-Macros$$ Kindly Help

please send the example... On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 wrote: > Dear All, > > Need your help to extract some specific text. > > Exam. > Govt I Grade College, Pashachapur Tq Hukkeri Dist Belgaum (2007) A/S/C/ > BBA. Enrol 139, Teacher 1, Principal-Dr S F Tangade. > > I need to ext

Re: Fwd: $$Excel-Macros$$ kindly help in modifying attached macro

t existing code can be used > > aju v chacko > > > > -- Forwarded message -- > From: aju chacko > Date: Feb 10, 2010 5:44 PM > Subject: $$Excel-Macros$$ kindly help in modifying attached macro > To: excel-macros@googlegroups.com > > > *Dear vb

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

hi ashish good work Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jan 14, 2010 at 6:52 PM, kvc praveen kumar wrote: > Thanks Vinod.. Glad that it was helpful!! > > On Thu, Jan 14, 2010 at 5:51 PM, vinod rao

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

Thanks Vinod.. Glad that it was helpful!! On Thu, Jan 14, 2010 at 5:51 PM, vinod rao wrote: > Hello Praveen, > > Excellent!!! this was really great. > With Regards, > Vin > On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar > wrote: > >> Hello Vinod, >> >> PFA the soln to fill your column c us

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

Hello Praveen, Excellent!!! this was really great. With Regards, Vin On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar wrote: > Hello Vinod, > > PFA the soln to fill your column c using VBA. Please let me know in case > you have any queries. > > Regards, > Praveen > > On Thu, Jan 14, 2010 at 1

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

hi check it On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar wrote: > Hello Vinod, > > PFA the soln to fill your column c using VBA. Please let me know in case > you have any queries. > > Regards, > Praveen > > On Thu, Jan 14, 2010 at 1:34 PM, vinod rao wrote: > >> Hello Friends, >> Can i ge

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

Hello Friends, Can i get a help for said query?. Thanks in advance. On Wed, Jan 13, 2010 at 3:13 PM, vinod rao wrote: > Hello Friends, > Can i get a help for said query?. Thanks in advance. > > On Wed, Jan 13, 2010 at 1:18 PM, vinod rao wrote: > >> Hi Ankur, >> >> This dont work because i have

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

Hello Friends, Can i get a help for said query?. Thanks in advance. On Wed, Jan 13, 2010 at 1:18 PM, vinod rao wrote: > Hi Ankur, > > This dont work because i have 25 thousands of lines items one below another > and it takes long time to refresh page. > So better have vba programmed for getting

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

Hi Ankur, This dont work because i have 25 thousands of lines items one below another and it takes long time to refresh page. So better have vba programmed for getting result. Plz help. Thanks for your quick reply. Regards, On Wed, Jan 13, 2010 at 11:22 AM, ankur wrote: > hi Vinod > > I try to

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

hi Vinod I try to Slove the your Query Without The help of VBA Please Check the Attached File , male me for any other clarifcation thanks On 1/12/10, vinod rao wrote: > HI Team, > > > > I want a vba for Sum if and finding duplicate values. Plz find attached with > highlighted columns/rows. >

$$Excel-Macros$$ Kindly help!! Sumif vba needed.

HI Team, I want a vba for Sum if and finding duplicate values. Plz find attached with highlighted columns/rows. Is this possible? Regards, Vin -- -- Some important links for excel users: 1. Follow us in TWITTER