$$Excel-Macros$$ need for some worksheet a1 value for abstract purpose

2021-05-29 Thread jmothilal
file attached -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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 FORU

$$Excel-Macros$$ macro file reg

2020-04-13 Thread jmothilal
Dear any one i am using spellrupee command in my excel file , whenever i open this file i import Rupees-words.bas each time. how to solve -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w

Re: $$Excel-Macros$$ Formula to convert Text into Number

2017-04-06 Thread jmothilal
first letter is not zero is "O" , so Remove the first letter "O", On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: > Hi Experts, > > I am stuck with one problem. I have one file which have numbers in it. but > while capturing they got stored as Text. > > Now i want any formula to convert into

$$Excel-Macros$$ help to concatenate function.

2015-12-02 Thread jmothilal
Dear Friends pls help to merge one by one rows in one cell file attached -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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 pag

Re: $$Excel-Macros$$ Fwd: Microsoft Excel Re: vlook up button for single click

2013-09-01 Thread jmothilal
attachment missing On Sat, Aug 31, 2013 at 10:46 PM, Pravin Gunjal wrote: > > > -- Forwarded message -- > From: veeru > Date: Fri, Aug 30, 2013 at 8:15 PM > Subject: Microsoft Excel Re: vlook up button for single click > To: microsoft-office-2...@googlegroups.com > > > no one s

Re: $$Excel-Macros$$ Re: need to change to print area settings - Reg

2013-08-18 Thread jmothilal
dear sir, Thanks for replying . it is selected page by page , but i need select the print areaupto end of row. Thanks with Mothilal On Sun, Aug 18, 2013 at 8:24 PM, Basole wrote: > Try this .. > > Sub ActivAreaPrint() > 'defines the print area as selected cells > ActiveShe

$$Excel-Macros$$ need to change to print area settings - Reg

2013-08-18 Thread jmothilal
Dear Any one, i want change the print area based on datas. some time 10 rows , 20 rows , 40 rows -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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) ! Joi

Re: $$Excel-Macros$$ need basic macro commands - Reg

2013-08-16 Thread jmothilal
thanks On Sat, Aug 17, 2013 at 10:22 AM, xlstime wrote: > try below link > > http://www.excel-pratique.com/en/vba.php > > . > > Enjoy > Team XLS > > > > On Thu, Aug 15, 2013 at 1:13 PM, jmothilal wrote: > >> Dear All >

$$Excel-Macros$$ need basic macro commands - Reg

2013-08-15 Thread jmothilal
Dear All Request to send basic macro commands like for loop, assigning value , detecting row and column value .. etc i know the c programming , foxpro commands. Thanks with Mothilal.J -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- Are you

Re: $$Excel-Macros$$ macro need

2013-08-09 Thread jmothilal
Dst.Offset(, 4).Formula = "=D" & iRow + 6 & "+C" & iRow + 6 > Next > Range("C" & [E3] + 7).Formula = "=SUM(C7:C" & [E3] + 6 & ")" > Range("D" & [E3] + 7).Formula = "=SU

$$Excel-Macros$$ macro need

2013-08-09 Thread jmothilal
dear any one, I need generate the no on installments based on paid amount m file attached -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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 offici

Re: $$Excel-Macros$$ i want fix the given value in the rows

2013-07-06 Thread jmothilal
Thanks sir it working what i am expecting . Thanks with mothilal On Sat, Jul 6, 2013 at 2:50 PM, ravinder negi wrote: > PFA,...please advise if any changes needed. > > --- On *Sat, 7/6/13, jmothilal * wrote: > > > From: jmothilal > Subject: Re: $$Excel-Macros$$ i want f

Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-15 Thread jmothilal
t;>> understanding.. but u done it...really great.. :) >>> >>> >>> >>> >>> On 14 May 2013 18:45, priti verma wrote: >>> >>>> If u want you do this with excel formula you can use this one. >>>> See the attachment >

Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-14 Thread jmothilal
t; >> >> >> >> On 14 May 2013 18:45, priti verma wrote: >> >>> If u want you do this with excel formula you can use this one. >>> See the attachment >>> >>> >>> >>> On Mon, May 13, 2013 at 8:24 PM, jmothilal wrote:

Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-13 Thread jmothilal
l the people you can, > As long as ever you can.” - John Wesley > *----- > > > -- > *From:* jmothilal > *To:* excel-macros@googlegroups.com > *Sent:* Mon, May 13, 2013 10:55:39 AM > *Subject:* $$Excel-Macros$$ split address one bye on

$$Excel-Macros$$ split address one bye one based on "," comma

2013-05-13 Thread jmothilal
Dear any one i want split address column wise based on comma file attached Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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 officia

Re: $$Excel-Macros$$ Interest formulae

2013-01-07 Thread jmothilal
use ((amount* int/100)/365) * no of days On Tue, Jan 8, 2013 at 11:43 AM, Hari wrote: > > > -- Forwarded message -- > From: Hari > Date: 8 January 2013 11:43 > Subject: Fwd: Interest formulae > To: excel-macros@googlegroups.com > > > > > > -- Forwarded message --

Re: $$Excel-Macros$$ dbf conversions

2013-01-07 Thread jmothilal
Thanks Raja sekar On Tue, Jan 8, 2013 at 11:24 AM, RAJA SEKAR wrote: > Hi, > > You have to use Excel 2003 to convert excel into dbf... Excel 2007 doesnt > having option to export excel into DBF > > > > On 8 January 2013 10:52, jmothilal wrote: > >> dear any o

$$Excel-Macros$$ dbf conversions

2013-01-07 Thread jmothilal
dear any one how to convert to excel 2007 to dbf files. Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thre

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-04 Thread jmothilal
Thanks with Congrats Noorain. Mothilal.J On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 wrote: > Good work! > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* Ayush Jain > *Sent:* Friday, August 03, 2012 12:40 PM > *To:* excel-macros > *Subject

Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-20 Thread jmothilal
spellnumber function working only number to text only On Fri, Jul 20, 2012 at 5:17 PM, Ashish kumar wrote: > Dear All, > > Greetings for the day...! > > > I have trying to convert Text to numbers (digits), and I h've apply the > formula (spellnumber), but this is not working. please

$$Excel-Macros$$ page number - Reg

2012-07-15 Thread jmothilal
Dear Any one My work sheet1 have 50 Pages. if I fix the page No in column footer page no assign with 1 to 50, but i want start 51 to 100, in ms word page no start with is available but excel i don't know , guide me any one. Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16,

Re: $$Excel-Macros$$ Re: column width - Reg

2012-07-15 Thread jmothilal
Thanks sir it's working macro as my expecting Thanks with Mothilal.J On Thu, Jul 12, 2012 at 10:31 PM, Paul Schreiner wrote: > Are you wanting to do this manually? > or with a macro? > > To do it manually, > 1. Select the sheets you want updated. > 2. Select Sheet1 > 3. Right-click on the first

$$Excel-Macros$$ column width - Reg

2012-07-12 Thread jmothilal
Dear any one I am using sheet1 worksheet column a to n , Column width is differents based on datas. same data format different places up 20 sheets. i want align sheet 2 to 20 column width based on sheet1. Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex

Re: $$Excel-Macros$$ Round The Value as User Defined.

2012-07-12 Thread jmothilal
i learn lot of command, thanks noorainansari sir. On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI wrote: > Dear Ashish, > > You can also use.. > > *=ROUND(A2/5,0)*5 > * > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspo

Re: $$Excel-Macros$$ create a multiple workbook - Reg

2012-07-09 Thread jmothilal
i want create a based on the column a unique nos only On Mon, Jul 9, 2012 at 3:51 PM, NOORAIN ANSARI wrote: > Dear Mothilal, > > Please explain more, > I think you want to create different workbook based on a columns unique No. > or other. > > > On Mon, Jul 9, 20

Re: $$Excel-Macros$$ create a multiple workbook - Reg

2012-07-09 Thread jmothilal
Mon, Jul 9, 2012 at 3:48 PM, jmothilal wrote: > >> dear excel members, >> >> >> I want create a multiple workbooks based on conditions column a , >> different sheets i want stored nos 1 , 2 ,3 >> >> Thanks with >> >> -- >> >&g

$$Excel-Macros$$ create a multiple workbook - Reg

2012-07-09 Thread jmothilal
dear excel members, I want create a multiple workbooks based on conditions column a , different sheets i want stored nos 1 , 2 ,3 Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- FORUM RULES (986+ members already BANNED for violati

Re: $$Excel-Macros$$ Zip Files in Folder with password

2012-07-06 Thread jmothilal
use pkzip software with batch file help pkzip/? On Thu, Jul 5, 2012 at 7:46 PM, Venkat CV wrote: > Dear All, > > I want to Compress all the files(.zip) to the specified folders with the > password..Where i will have a passwords towards that file names.. > > have attached sampl

Fwd: $$Excel-Macros$$ page setup - Reg

2012-06-30 Thread jmothilal
-- Forwarded message -- From: jmothilal Date: Sat, Jun 30, 2012 at 6:51 PM Subject: Re: $$Excel-Macros$$ page setup - Reg To: excel-macros@googlegroups.com Sir , I WANT TO FIX ALL WORKSHEETS LEFT,TOP,BOTTOM,RIGHT 0.5 MARGIN When i run BELOW code margin goes to

Re: $$Excel-Macros$$ page setup - Reg

2012-06-30 Thread jmothilal
t; wksSheet.PageSetup.RightMargin = 0.5 > > Next wksSheet > > ** ** > > End Sub > > ** ** > > ** ** > > *Regards,* > > *Lalit Mohan* > > *www.excelfox.com/forum* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > e

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread jmothilal
s = combine_cells + CStr(cell.Value) & Chr(10) >> Next cell >> End Function >> >> see attached sheet >> -- >> Thanks & regards, >> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> On Fri, Jun 29,

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread jmothilal
Thanks so much its working . Thanks with Mothilal.J On Fri, Jun 29, 2012 at 9:55 PM, Aditya Tyagi wrote: > > > On Sat, Jun 30, 2012 at 5:21 AM, jmothilal wrote: > >> i am using office 2003, are u send sample worksheet >> Thanks >> Mothilal >> >>

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread jmothilal
i = 1 To Sheets(1).Range("a65356").End(xlUp).Row >> splitdata = Split(Sheets(1).Range("a" & i).Value, Chr(10)) >> Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value = >> splitdata >> Next >> End Sub >> >> >> O

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread jmothilal
On Fri, Jun 29, 2012 at 9:19 PM, ashish koul wrote: > can you attach the sample file > > > On Fri, Jun 29, 2012 at 9:18 PM, jmothilal wrote: > >> Dear any one >> >> I want 3 cell values in 1 cell line by line >> >> Thanks in advance >> >&g

Re: $$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-27 Thread jmothilal
use Text(a1,"d") Mothilal On Wed, Jun 27, 2012 at 12:52 PM, Lalit_Mohan wrote: > Hi, > > Try this revised formula as my last post contain some error > Evaluate("=Text(Day(""" & Sheets("Sheet1").Cells(count, BarDate).Text & > """), """")") > > Hope it helps you > > Regards, > Lalit Mohan

Re: $$Excel-Macros$$ age month days calculations - Reg

2012-06-24 Thread jmothilal
l+1 and type in > custom yy mm dd > > See attached sheet > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Fri, Jun 22, 2012 at 12:55 PM, jmothilal wrote: > > > > > > Dear any on

Re: $$Excel-Macros$$ age month days calculations - Reg

2012-06-23 Thread jmothilal
> Noorain Ansari >> www.noorainansari.com >> www.excelmacroworld.blogspot.com >> >> On Fri, Jun 22, 2012 at 12:55 PM, jmothilal wrote: >> > >> > >> > Dear any one >> > >> > i want find age month days calculations in between two days

Re: $$Excel-Macros$$ age month days calculations - Reg

2012-06-22 Thread jmothilal
date or date from which you want to > calculate, > and in cell B1, type the newest date or date till which you want to > calculate. > > > > On Fri, Jun 22, 2012 at 12:55 PM, jmothilal wrote: > >> >> Dear any one >> >> i want find age month days calcu

$$Excel-Macros$$ age month days calculations - Reg

2012-06-22 Thread jmothilal
Dear any one i want find age month days calculations in between two days. pls help me thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titl

Re: $$Excel-Macros$$ MACRO

2012-05-30 Thread jmothilal
Sir , pls send me my email id jmothi...@yahoo.com Thanks with Mothilal.J On Wed, May 30, 2012 at 8:25 AM, NOORAIN ANSARI wrote: > Hi Joseph,aruna,lupinskip and anjali, > > I have send VBA Ebook 2007(O'Rellay) on your email ID. > > Pls check and confirm. > > -- >> Thanks & regards, >> Noora

Re: $$Excel-Macros$$ Re: $$Excel-Ma​cros$$ $$Excel-Ma​​cros$$ Formula Need for accounting entries

2012-04-27 Thread jmothilal
file not attached On Fri, Apr 27, 2012 at 11:09 PM, who wrote: > > > =SUMIF($G$7:$G$135,$G$142,I7:I135) - can copy this across. Will have to > change to copy down =SUMIF($G$7:$G$135,G142,$I$7:$I$135) > > > On Friday, April 27, 2012 7:43:04 AM UTC-7, Vijayendra wrote: > >> Dear All, >> >> I need

Re: $$Excel-Macros$$ Stock position - Reg

2012-04-15 Thread jmothilal
*** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *Sent:* Apr/Sun/2012 02:31 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Stock position - Reg > > ** ** > >

Re: $$Excel-Macros$$ Stock position - Reg

2012-04-15 Thread jmothilal
Thanks i am updating Mothilal On Sun, Apr 15, 2012 at 2:24 PM, Haseeb A wrote: > You can get this with just one SUMPRODUCT, > > =SUMPRODUCT((B$2:B2=B2)*(A$2:A2={"P","S"}),C$2:C2*{1,-1}) > > Which is on the file in the last reply. > > > ___ > HTH, Haseeb > > -- > FORUM RULES (986+ members

Re: $$Excel-Macros$$ Stock position - Reg

2012-04-15 Thread jmothilal
Thanks it working . also i find this formula =SUMPRODUCT(--(($A$2:A2="P")*($B$2:$B2=B2))*$C$2:C2)-SUMPRODUCT(--(($A$2:A2="S")*($B$2:$B2=B2))*$C$2:C2) On Sun, Apr 15, 2012 at 2:16 PM, Haseeb A wrote: > Hello Mothilal, > > See the attached. if you are on XL 2007 or later use SUMIFS > > _

Re: $$Excel-Macros$$ Stock position - Reg

2012-04-15 Thread jmothilal
Monitor 1 0 S 500 GB Hard disk 1 0 Thanks with On Sun, Apr 15, 2012 at 12:11 PM, Maries wrote: > Hi, > > Find the attachment... > > > > On Sun, Apr 15, 2012 at 10:27 AM, jmothilal wrote: > >> >> PURCHASE / SALES ITEM QTY STOCK >> P LG DVD WRITER 1 1 >

Re: $$Excel-Macros$$ printing doubt

2012-03-28 Thread jmothilal
> ws.PrintOut > Next ws > End Sub > > > On Wed, Mar 28, 2012 at 9:28 AM, jmothilal wrote: > >> Dear Sir, >> >> How can i print all sheets ? >> >> >> >> Thanks with >> >> >> >> Mothilal.J >> >> >&g

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread jmothilal
Congratulation Noorain. Mothilal.J Universal Computer\ Vellore -2 On Thu, Mar 15, 2012 at 11:36 AM, Dilip Pandey wrote: > Congratulations Noorain > > Keep up the good work and keep helping :) > > Regards, > DILIPandey > > > On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain wrote: > >> Ma

Re: $$Excel-Macros$$ Help me with a macro

2011-11-27 Thread jmothilal
Dear son Here with i attached excel file using sumif command. Mothilal On Sat, Nov 26, 2011 at 8:23 PM, son nguyen wrote: > Dear all, > > > I have problem of calculating sheet.Detail as sheet attached. > I want to have a macro to sum value within qty, and downtime column then > delete produc

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread jmothilal
THANKS SO MUCH J.MOTHILAL On Fri, Nov 25, 2011 at 11:46 AM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached some tips to learn Excel. > > - > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.b

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread jmothilal
gt; surbhi.agarwal0...@gmail.com> wrote: > >> Hi, >> >> These files need password. Please tell me the password. >> >> Thanx >> Surbhi >> >> On Thu, Nov 24, 2011 at 4:18 PM, jmothilal wrote: >> >>> Herewith i attache 42 excel files. i

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread jmothilal
Sir , if possible send me also, Thanks in advance. Mothilal.j On Fri, Nov 25, 2011 at 10:58 AM, smitha.kumari wrote: > Hi Noorain, > > ** ** > > Expecting the Training material at the earliest. > > ** ** > > Regards > > Smitha > > *From:* smitha.kumari [mailto:smitha.kum...@spe

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread jmothilal
Pls send the that training material for me. Thanks sir. On Fri, Nov 25, 2011 at 11:02 AM, wrote: > Hi Noorian- appreciate if you can send it to the entire group... It will > be very helpful.. > > Thanks in advance > > Warm Regards! > Sent on my BlackBerry® from Vodafone >

Re: $$Excel-Macros$$ exls

2011-11-24 Thread jmothilal
Thanks for sending shortcut keys. Mothilal On Thu, Nov 24, 2011 at 2:17 PM, mangesh bavalekar wrote: > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Prob

Re: $$Excel-Macros$$ Cell Formatting

2011-11-22 Thread jmothilal
use this =LEFT(A1,2)&":"&RIGHT(A1,2) Mothilal.J On Tue, Nov 22, 2011 at 2:57 PM, hemant wrote: > Hi all > > I am supposed to enter data in say "22:11" format in Excel 2007. > > Is there any method by which i will enter only "2211" and cell shows > it as "22:11". > > Thus it will save my time

Re: $$Excel-Macros$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

2011-11-17 Thread jmothilal
Dear Any one, How can I want print all notepad files in landscape left 0.5 right 0.5 margin in one time Thanks with On Wed, Nov 16, 2011 at 6:49 PM, dguillett1 wrote: > http://forums.techguy.org/**business-applications/485943-** > printing-multiple-files-**folder.html

Re: $$Excel-Macros$$ SUM Reg.

2011-11-12 Thread jmothilal
named range > InputCell > > > Regards, > Sam > > > On Sat, Nov 12, 2011 at 9:12 PM, dguillett1 wrote: > >> A simple macro to clear the ranges >> >> Range("D6:D25,F6:G25,J6:P25,T6:W25,Z6:Z25").ClearContents >> >> Don Guillett >&g

Re: $$Excel-Macros$$ SUM Reg.

2011-11-11 Thread jmothilal
THANKS SO MUCH , ITS WORKING FINE GET THE RESULTS. THANKS WITH MOTHILAL.J On Fri, Nov 11, 2011 at 10:31 PM, NOORAIN ANSARI wrote: > Dear Mothilal, > > try this one.. > =SUMPRODUCT(--($D$2:$D$21=D22)*($E$2:$E$21)) > On Fri, Nov 11, 2011 at 8:23 PM, jmothilal wrote: > >

Re: $$Excel-Macros$$ SUM Reg.

2011-11-11 Thread jmothilal
Thanks for sending immediate answer. Thanks , Thanks ... Mothilal.J On Fri, Nov 11, 2011 at 8:30 PM, dguillett1 wrote: > Look in the help index for SUMIF > > =SUMIF($D$2:$D$21,"stock",$G$2:$G$21) > > Don Guillett > SalesAid Software > dguille...@gmail.com

$$Excel-Macros$$ SUM Reg.

2011-11-11 Thread jmothilal
DEAR EXCEL MEMBERS , I WANT TO SUM OF SPECIFIED ROWS , HERE WITH I ATTACHED FILES. I.E STOCK , SALES. THANKS WITH -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread t

Re: $$Excel-Macros$$ Re: formula

2011-11-10 Thread jmothilal
Here =VLOOKUP(A1,Sheet3!A:B,*2,0) , 2 is 2nd column, 0 is exact match * * * *Mothilal.J * * * * * On Thu, Nov 10, 2011 at 1:14 PM, smitha.kumari wrote: > Thanks Ashish. > > ** ** > > Please specify why 2 ,0 is used > > ** ** > > =VLOOKUP(A1,Sheet3!A:B,*2,0)* > > ** ** > >

Re: $$Excel-Macros$$ Remove Zero using vba function

2011-11-10 Thread jmothilal
u want to remove entire row i.e a=0 like On Wed, Nov 9, 2011 at 8:08 PM, Abhijit Mitra wrote: > Dear all > Can you help me out how to remove zero from a sheet: > Example: > > A=0 > B=0 > C=0 > D=2 > E=3 > F=56 > G=0 > H=67 > I=9 > J=0 > K=0 > > I just want to remove zero from start and end (A,B,

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-10 Thread jmothilal
20Logo] > > World Class Solutions to Power Global Businesses > > Office: 0471-2527525/2700526 > > smitha.kum...@speridian.com > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *S

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-09 Thread jmothilal
Use This command [image: image.png] Thanks with Mothilal.J -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention o

Re: $$Excel-Macros$$ Rounding Method

2011-11-09 Thread jmothilal
use this command =floor(a1,5) Mothilal.J[image: image.png] On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj wrote: > Dear Experts, > > I want rounding method in excel 2003 > when i typed 124.90 the rounding should come 120 & > when i typed 125.10 the rounding should come 125 & > when i type

Re: $$Excel-Macros$$ Indian formats

2011-11-08 Thread jmothilal
://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > On Sat, Nov 5, 2011 at 3:05 PM, jmothilal wrote: > >> dear Any one >> >> I want Indian format lik

Re: $$Excel-Macros$$ NEED ROWS HIGHLIGHT - REG

2011-11-07 Thread jmothilal
> > > Similarly, for sheet 2157, A8:P105, and used formula =$Q8<30. Same > logic as above. > > Regards, > > Sam Mathai Chacko > > On Nov 7, 7:22 pm, "dguillett1" wrote: > > You did NOT say if Sam guessed what you wanted. > > > > Don Gu

Re: $$Excel-Macros$$ NEED ROWS HIGHLIGHT - REG

2011-11-07 Thread jmothilal
formula he used. > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* jmothilal > *Sent:* Monday, November 07, 2011 4:05 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ NEED ROWS HIGHLIGHT - REG > > Dear Friend , > >

Re: $$Excel-Macros$$ Indian formats

2011-11-07 Thread jmothilal
Dear Friend when i try 2 this #\,##\,##\,###.00 format i get it following, [image: image.png] On Sat, Nov 5, 2011 at 10:21 PM, xlstime wrote: > try this > > #\,##\,##\,###.00 > > > > On Sat, Nov 5, 2011 at 3:05 PM, jmothilal wrote: > >> dear Any one >

Re: $$Excel-Macros$$ NEED ROWS HIGHLIGHT - REG

2011-11-07 Thread jmothilal
> column Q > > Regards, > > Sam Mathai Chacko > > On Sat, Nov 5, 2011 at 7:13 PM, dguillett1 wrote: > >> Surely you can give me DETAILED examples as requested or I give up >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >>

Re: $$Excel-Macros$$ NEED ROWS HIGHLIGHT - REG

2011-11-06 Thread jmothilal
Q > > Regards, > > Sam Mathai Chacko > > On Sat, Nov 5, 2011 at 7:13 PM, dguillett1 wrote: > >> Surely you can give me DETAILED examples as requested or I give up >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >&

Re: $$Excel-Macros$$ NEED ROWS HIGHLIGHT - REG

2011-11-05 Thread jmothilal
ich column > should change to what and why_ > Also, you did not explain the totals request. > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* jmothilal > *Sent:* Friday, November 04, 2011 11:36 PM > *To:* excel-macros@googlegroups.co

$$Excel-Macros$$ Indian formats

2011-11-05 Thread jmothilal
dear Any one I want Indian format like 1,23,45,678.00, how can i define format cells. Thanks with -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor threa

Re: $$Excel-Macros$$ NEED ROWS HIGHLIGHT - REG

2011-11-04 Thread jmothilal
g what you want. Please > explain the logic. > less than 30 or 31 days > === > What does I want page total in each page mean? Example>>>>>’ > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* jmothilal > *Sent:*

Re: $$Excel-Macros$$ Need help on String Matching

2011-09-21 Thread jmothilal
*Dear friend, =VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0) please help me after vlookup"*",&a1&"*" Thanks with Mothilal * On Tue, Jul 12, 2011 at 7:31 PM, Anish Shrivastava wrote: > Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :) > > > On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Ve

$$Excel-Macros$$ vlookup , index - Reg

2011-09-20 Thread jmothilal
Dear Friends, Any limit is there vlookup and index. because i fix the array a1: a300 =index(b1:b300,match(a1,a1:a300,0)) some time its not work. if lesser array its working. i am using office 2003. -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 --

Re: $$Excel-Macros$$ Books

2011-07-13 Thread jmothilal
if any one have pdf file pls send me J.Mothilal On Wed, Jul 13, 2011 at 2:56 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > I need book for learning chart itself. If anything is there pls send it to > me. > > Thanks, > > Chandra Shekar B > > On Wed, Jul 13, 2011 at 9:28 AM, Rajan_Ve

Re: $$Excel-Macros$$ Convert number to Text

2011-06-10 Thread jmothilal
here with i attached macro file ( add macro - tools - macro - visual basic - import ) use the command =spellrupee(20) or =spellrupee(a1) Thanks with On Fri, Jun 10, 2011 at 10:59 AM, Rushiraj Patel < rushiraj.pa...@in.aegisglobal.com> wrote: > If help you in any way…… > > > > Rg

Re: $$Excel-Macros$$ i want 2 or more copies print when i press print button - Reg

2011-06-07 Thread jmothilal
Thanks its working Worksheets("sheet2").PrintOut Copies:=2 On Mon, Jun 6, 2011 at 8:09 PM, ashish koul wrote: > try this > > Worksheets("sheet2").PrintOut Copies: 2 > > > On Mon, Jun 6, 2011 at 4:58 PM, jmothilal wrote: > >> Sir >> >

$$Excel-Macros$$ i want 2 or more copies print when i press print button - Reg

2011-06-06 Thread jmothilal
Sir i want print 2 copies for my selected areas i am using print push button Worksheets("sheet2").PrintOut any one help Thanks with Mothilal.J -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- ---

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread jmothilal
Congratulations! , J.Mothilal, Vellore On Fri, Jun 3, 2011 at 4:04 PM, SANJAY SONI wrote: > Dear Ashish G, > > Congratulations on a great success. It is really appreciable for winning > consecutive 6 times as "MOST HELPFUL MEMBER". > > * > Best Regards, > * > *Sanjay ** > * > ** > *From:* Ayus

Re: $$Excel-Macros$$ database concept - Reg

2011-05-17 Thread jmothilal
how to create custom list , pls help me On Tue, May 17, 2011 at 5:15 PM, Rajan_Verma wrote: > Make a Custom List for all names > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *Sent:* Tuesday, May 17, 2011

$$Excel-Macros$$ database concept - Reg

2011-05-17 Thread jmothilal
Dear Excel Experts I am typing name and place name different worksheets. like anand babu kumar anand kumar babu same worksheet it' shows previous typing names , i want to store all the names in worksheets . when ever i need type get this name for any worksheets just like database -- J.M

Re: $$Excel-Macros$$ no of days in the month ?

2011-05-15 Thread jmothilal
this month* is = the *0*th day of the Next Month !! > > > > On Sat, May 14, 2011 at 7:03 PM, rajan verma > wrote: > > find attached Sheet > > > > > On Sat, May 14, 2011 at 3:36 PM, jmothilal wrote: > >> Dear Friends > >> i want find total no

$$Excel-Macros$$ no of days in the month ?

2011-05-14 Thread jmothilal
Dear Friends i want find total no days in the month i.e January = 31 days Feb = 29 days march = 30 days like -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -

$$Excel-Macros$$

2011-05-11 Thread jmothilal
Dear Experts, I am typing Name and place name day 2 day different excel files, what is easy method i type these names and place names. -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -

Re: $$Excel-Macros$$ Help required in average if - Excell 2003

2011-05-01 Thread jmothilal
OPEN AND RUN THE FILE ANYTHING NEED CONDUCT ME j.mOTHILAL vELLORE On Sun, May 1, 2011 at 2:34 AM, N.Shivkumar wrote: > It is easy in exel2007. Kindly show how the same is to be worked in excel > 2003 > Thanx in advance > > > > N.SHIVKUMAR > Mobile : +919422613567 > Office : +912332301775 > A

$$Excel-Macros$$ help macro commands need -reg

2011-04-29 Thread jmothilal
Dear any one i want to learn macro commands , can u help me send the macro commands -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1.

Re: $$Excel-Macros$$ Excel spell out word from number

2011-04-28 Thread jmothilal
cel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *Sent:* Monday, April 25, 2011 12:05 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Excel spell out word from number > > > > Dear Vikram > >

Re: $$Excel-Macros$$ Excel spell out word from number

2011-04-25 Thread jmothilal
to get this > add to new workbook. > > > > Kindly help in this regard. > > > > Regards, > > > > Vikram > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *Sent:* Saturday, April 23,