$$Excel-Macros$$ formula issue

2014-04-28 Thread L.K. Modi
Dear Sir I have downloaded a file from the net but unable to understand the logic in column Q AND R as the file is read only only so can anyone say me how that delay had been calculated and interest is calculated... thanks in advance regards LKM -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc

$$Excel-Macros$$ Regarding copy of BORDER LINE

2013-05-01 Thread L.K. Modi
Dear Brothers I am facing problem in the matter of Format borders as i have excel sheet containing many rows and columns and i have to give border each column manually so its takes a lot of time. is there any way by which we can copy only border format in other columns as i have tried paste specia

Re: $$Excel-Macros$$ Re: Sum on the basis of colour formula

2013-04-11 Thread L.K. Modi
Brother, There is any formula based on the conditional formating or sumif based in which we can recognise about the colour so i want to know that brother -- Forwarded message -- From: Prince Date: Thu, Apr 11, 2013 at 5:13 PM Subject: $$Excel-Macros$$ Re: Sum on the basis of c

Fwd: $$Excel-Macros$$ Sum on the basis of colour formula

2013-04-11 Thread L.K. Modi
Dear All I need formula for this particular query so please provide me any any formula instead of macro Dear All In the given sheet i want sum on the basis of colour , is there any formula to solve my problem regards L.K.Modi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w

$$Excel-Macros$$ Sum on the basis of colour formula

2013-04-11 Thread L.K. Modi
Dear All In the given sheet i want sum on the basis of colour , is there any formula to solve my problem regards L.K.Modi -- 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/d

$$Excel-Macros$$ due date formula

2013-04-04 Thread L.K. Modi
Dear all can any one suggest any formula so that due date get automatically seven of next month . means if the date is 5-10-12 then due date should be 7-11-12 Regards L.K.Modi -- 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 Face

Fwd: $$Excel-Macros$$ Need Excel Formula for Color Count

2013-02-19 Thread L.K. Modi
Dear Brother, What is this xlsm file as this formula is not working in my excel sheet. On Tue, Feb 19, 2013 at 11:57 AM, अनिल नारायण गवली wrote: > Dear ikhan, > > Pl find attached herewith. > > Warm Regards, > Gawli Anil > > On Tue, Feb 19, 2013 at 11:47 AM, Imran khan wrote: > >> Hi, >>

Fwd: $$Excel-Macros$$ Formula for Loan amount

2013-02-18 Thread L.K. Modi
Bro.. if u are using Excel 2007 it is bulid template named Loan Amortization.. To get this template : Go to Home page : New: Installed template and u will get what you are looking for .. Hope this is helpfull to U.. Enjoy ur day.. Thanks Pankaj Sangotra On Tue, Feb 19, 2013 at 6:09 AM, L.K

$$Excel-Macros$$ Formula for Loan amount

2013-02-18 Thread L.K. Modi
Dear All I want to Know about the formula to calculate the installment amount: If loan amount is : 10/- Years: 3Years Rate of Interest : 14.50% P.A. Mode of Insallment :Monthly. 1)What will be the installment amount . Pls suggest by formula 2) If we

Re: $$Excel-Macros$$ size of mail

2012-09-03 Thread L.K. Modi
sir thats a song file.. On Mon, Sep 3, 2012 at 3:44 PM, अनिल नारायण गवली wrote: > how can we understand what file u r attaching dude... > just elaborate and explain... > > On Mon, Sep 3, 2012 at 3:40 PM, L.K. Modi wrote: > >> sir >> >> thats a long song dedic

Re: $$Excel-Macros$$ size of mail

2012-09-03 Thread L.K. Modi
onth valid only. > > Regards, > Kuldeep Singh > > On Mon, Sep 3, 2012 at 3:28 PM, L.K. Modi wrote: > >> Dear all >> >> as i m uploading file containing size of 25 mb at gmail to send but its >> shows error so suggest how can we short the size of a fold

$$Excel-Macros$$ size of mail

2012-09-03 Thread L.K. Modi
Dear all as i m uploading file containing size of 25 mb at gmail to send but its shows error so suggest how can we short the size of a folder. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Split text in cell

2012-03-21 Thread L.K. Modi
Dear All, Its good to see this resolution but can anyone explain this in simple way Regards Modi On Thu, Mar 22, 2012 at 4:51 AM, dguillett1 wrote: > Option Explicit > Sub getmiddleSAS() > Dim c As Range > Dim fs As Long > Dim ls As Long > For Each c In Range("a2:a10") > c = Applic

$$Excel-Macros$$ how can i download files from group

2012-01-05 Thread L.K. Modi
Dear Sir, Earlier i was able to download file from the excel group. I want to download some useful files from there . can any one send me that link. Regards LKModi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pleas

$$Excel-Macros$$ Query related to subtotal and condition

2011-11-11 Thread L.K. Modi
Dear All members, I am attaching herewith a file regarding tds and the requirement is mention in that file related to subtotal and conditions. Please solve my problem . Thanks to all in advance Regards LKModi 9309243685 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise

$$Excel-Macros$$ Regarding Excel formulas and addins

2011-07-12 Thread L.K. Modi
Dear Members I want to know about the new advanced excel formulas and addins. Please send me some useful links or files by which i can know about that by downloading all that.Specially if those links also having finance related funcion or addins that will great for me also. Thanking you Regard

$$Excel-Macros$$ Help regarding bank statment

2011-07-07 Thread L.K. Modi
Dear Members, Thanks for your valuable support. I have an querry in which i have to check interest calculation for banks. Me attaching a sheet in which column A have date that is in different format. and in column B the balance as on the respective dates. As the bank charges interest on the clos

Re: $$Excel-Macros$$ help regarding date formula

2011-07-06 Thread L.K. Modi
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS REGARDS LKMODI On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote: > Dear Members, > > Me attaching a sheet which relates to Excise duty payment.The result should > be 5 of the next of the month of Invoice.We are cur

$$Excel-Macros$$ help regarding date formula

2011-07-06 Thread L.K. Modi
Dear Members, Me attaching a sheet which relates to Excise duty payment.The result should be 5 of the next of the month of Invoice.We are currently doing it manually. But is there any formula by which we can do that fast and in less time. Hope you wil surely help me. Regards LKModi --

$$Excel-Macros$$ Sum based on conditional formatting

2011-07-06 Thread L.K. Modi
Dear Members I have a query regarding conditional formating: 1. I have a sheet in which some cells containg amounts out of those some cells are coloured. Is there any way to coloured only those coloured cells. One way i have by filter on the basis of colour but everytime to use that is hectic so

$$Excel-Macros$$ Regarding LME and Commodoties Updation

2011-07-04 Thread L.K. Modi
Dear Members, with reference to the above dear member i want a excel sheet. Earlier i have downloaded a sheet that updates automatically bse and nse prices. Similary is there any way by which when i would run macro the LME prices and Commodities Prices update automatically. May be its a challengin

$$Excel-Macros$$ EXCEL FILE CONTAINING IP ADDRESS

2011-07-01 Thread L.K. Modi
Dear Group Members I need an excel file in wihch by running macro we can see our IP ADDRESS. Please provide me that file by which we can know the IP address of our System Regards LKModi -- -- Some important links

Re: $$Excel-Macros$$ work books name in a folder

2011-06-30 Thread L.K. Modi
ru all file in files collection >For Each MyFile In FOL > If LCase(Right(MyFile.Name, 4)) Like "*xl*" Then > r = r + 1 > Range("B6").Cells(r, 1) = r > ' - get the name and write to cell > Range("B6").Cells(r, 2) = MyFile

$$Excel-Macros$$ work books name in a folder

2011-06-30 Thread L.K. Modi
Dear GroupMembers, I want to list the file name that are in closed folder .Means any way by which i can get the files or workboooks name that are in a particular folder. Thanks in advance Regards LKModi -- -- S

Re: $$Excel-Macros$$ How to send mail with excel

2011-03-30 Thread L.K. Modi
this add in is not working On Wed, Mar 30, 2011 at 10:42 AM, ashish koul wrote: > try this addin see if it helps > > http://www.rondebruin.nl/mail/add-in.htm > > > > > On Tue, Mar 29, 2011 at 8:02 PM, shariq khan wrote: > >> Can any one help me? >> >> >> >> I looking for code to send an emai

Re: $$Excel-Macros$$ Fwd: insert a blank row

2010-12-08 Thread L.K. Modi
).Select > Selection.End(xlUp).Select > > k = ActiveCell.Row > > > > >For i = 5 To k + z Step 1 > > > >If (i Mod j = 0) Then > >ActiveSheet.Cells(i + z, 1).Select > >Selection.EntireRow.Insert > > > z = z + 1 > > > En

$$Excel-Macros$$ insert a blank row

2010-12-08 Thread L.K. Modi
Dear all can any one help me in inserting black rows after line no.5 like 5 then blank row then 6 and then again blank row and again regards LKModi -- -- Some important links for excel users: 1. Follow us on TWIT

$$Excel-Macros$$ IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT JAIPUR

2010-11-17 Thread L.K. Modi
IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT JAIPUR. PLEASE SUGGEST ME. AWAITING FOR YOUR RESPONSE. REGARDS AMIT -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Excel Utilities

2010-11-13 Thread L.K. Modi
pls send some new utility and asap and power utils are older more than 1 years if u can pls send some new utilities we all be greatful to you. thanks in advance Regards LKModi On Sat, Nov 13, 2010 at 3:44 PM, Vishal Angre wrote: > use this addin for all excel version > > http://www.asap-u

$$Excel-Macros$$ UPDATION OF LME (LONDON METAL EXCHANGE PRICES)

2010-08-05 Thread L.K. Modi
Dear All Earlier i had got an excel file in which bse prices are automatically updated like that way i need to track lme prices. can any one help on this . Regards LKModi -- -- Some important links for excel users:

$$Excel-Macros$$ Radio button gets protected

2010-06-27 Thread L.K. Modi
Dear all As per your mail i am unable to find what is the radio buttons. as i m new to excel. can any one suggest the entire procedure regarding these radio buttons and use. pls ignore the mail if i have already sent the mail. I want to know the step by step procedure regarding these buttons Th

Re: $$Excel-Macros$$ Radio button gets protected

2010-06-27 Thread L.K. Modi
Dear all As per your mail i am unable to find what is the radio buttons. as i m new to excel. can any one suggest the entire procedure regarding these radio buttons and use. Thanks in advance hope i wil get the reply fast. Regards LKModi On Sun, Jun 27, 2010 at 9:34 PM, ayush jain wrote:

Re: $$Excel-Macros$$ Index match multiple

2010-06-26 Thread L.K. Modi
Dear all Group Members I have joined this group for my development and i have learnt a lot from here. Really this is group is one of the best groups to learn for going ahead. I m an accounting person and i have to give my top management many type of reports like fund position,debtors,creditors,sal

Re: $$Excel-Macros$$ Re: popup on s sheet ?

2010-06-09 Thread L.K. Modi
Dear Sir (Regarding Pop up on a sheet) > May i know how u do this step by step.I am a great fan of this group. > because in the sample sheet i m unable to know the process.Hope i will get > answer shortly > > Regards > LKModi > > > > > > > On Wed, Jun 9, 2010 at 6:43 AM, Harpreet Singh Gujral < >

Re: $$Excel-Macros$$ Re: popup on s sheet ?

2010-06-09 Thread L.K. Modi
Dear Sir May i know how u do this step by step.I am a great fan of this group. because in the sample sheet i m unable to know the process.Hope i will get answer shortly Regards LKModi On Wed, Jun 9, 2010 at 6:43 AM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Swapnil, > > You

Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)

2010-05-07 Thread L.K. Modi
sorry did not get select the funcion and presss tab can u expalin this dear friend On Fri, May 7, 2010 at 11:54 AM, Sandeep Kumar Maurya wrote: > Select the function and press tab. > > Thanks & Regards > Sandeep > > > On Thu, May 6, 2010 at 11:38 PM, Michael wrote: > >> I posted a picture

Re: $$Excel-Macros$$ Pivot Problem

2010-04-13 Thread L.K. Modi
> Dear all group Members, > > I am also a member of your very good group. > I am very pleased to be in this group becasue i have learned a lot of excel > from here. > i would like to mention that in these days there is no mail i had received > that contains attachment file from where i can understa

Re: $$Excel-Macros$$ Pivot Problem

2010-04-13 Thread L.K. Modi
Dear all group Members, I am also a member of your very good group. I am very pleased to be in this group becasue i have learned a lot of excel from here. i would like to mention that in these days there is no mail i had received that contains attachment file from where i can understand the proble

Re: $$Excel-Macros$$ Need Passward Cracker

2010-04-09 Thread L.K. Modi
may i know what is the use of this password cracker Actually me new to this group. Pls dont take otherwise this group is very good and i have learned many things from here that i thought can not be possible. Thanks for ur much good support thanks to all member of group Regards LKModi On Fri,

Re: $$Excel-Macros$$ Network days with a tweak

2010-04-07 Thread L.K. Modi
Dear Aindril As i m seeing this mail there is no link at all in your mail. Is there any way to calculate networking days Regards LKModi On Wed, Apr 7, 2010 at 2:20 PM, Aindril De wrote: > Hi Roopesh, > > The process given in the link below will be a good start. > Regards, > Aindril > On W

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

2010-04-06 Thread L.K. Modi
Dear Sir May i know how can we use that excel tool tip file. sry i m new to excel but like this group much its help me a lot pls tell me the way how can we use that as i m clicking on that there is some id type is there and nothing else please suggest me Regards On 4/6/10, rf1234 rf1234 wrote

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

2010-04-06 Thread L.K. Modi
Dear Sir May i know how can we use that excel tool tip file. sry i m new to excel but like this group much its help me a lot pls tell me the way how can we use that as i m clicking on that there is some id type is there and nothing else please suggest me Regards LKmodi On 4/6/10, rf1234

$$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

2010-03-31 Thread L.K. Modi
Dear All if there is a coloum containg mix of nos and alphabets like ram12 moh12345an 132shyam we need only alphabets what can we do like ram mohan shyam Here we can seprate only nos. but what can we do if we want alphabets sepreately. Help in this query. Thanks in advance Regards LKModi

Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

2010-03-31 Thread L.K. Modi
Dear All if there is a coloum containg mix of nos and alphabets like ram12 moh12345an 132shyam we need only alphabets what can we do like ram mohan shyam Here we can seprate only nos. but what can we do if we want alphabets sepreately. Help in this query. Thanks in advance Regards LKModi