$$Excel-Macros$$ How to calculate Interest Using VBA In excel

> Dea All > Could you please help me > > On 10/29/09, grlinks-karthik wrote: >> >> I need to calculate in interest excel sheet could any one help me with? >> >> >> >> Its like insurance calculation method, user will pay premium yearly >> basis, Period 20 years >> >> Conditions >> >> 1.Bo

$$Excel-Macros$$ Re: Help with user defined function

Could you please attach one example of using the function i.e. left lookup function using the user defined function. Regards, C.G.Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Paul Schreiner Sent: Thursday, October 29, 2009 8

$$Excel-Macros$$ Re: Extracting Specific string and corresponding and so on.

I am not sure what you mean by fetch, but the easiest way to obtain a list of just the items that contain "PIPE" or "ELL" would be the following: Step 1: Enter the following formula into Cell E4 =IF(ISNUMBER(SEARCH("PIPE",A4)),"PIPE",IF(ISNUMBER(SEARCH ("ELL",A4)),"ELL","")) Step 2: Copy the fo

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

good luck friend ! :) Hemant Hegde 2009/11/1 karthikeyan sankaran > I have download this data from PDF.Now I want to create pivotTable through > this data. > > > > --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Need a function or formula

Pooja, Try the following formula in cell D6, then copy down: =IF(ISERROR(FIND("e",B6)),"",RIGHT(B6,((LEN(B6))-(FIND("e",B6)))+1)) Norman On Sat, Oct 31, 2009 at 10:55 AM, Pooja Sharma wrote: > Hi All, > > I need your help in extracting some words (having defined format) from one > cell in anoth

$$Excel-Macros$$ Re: Need help regarding entering date

Hi Pooja, I would suggest to use custom category in the format cells window. In the Type: option please type "HH:MM:SS" & apply this on the selected cell. Now whenever u will change the time it will come in HH:MM:SS format. Regards, Deepak Rai On Sun, Nov 1, 2009 at 12:03 AM, Pooja Sharma wrote:

$$Excel-Macros$$ Need help to save data from one file to another

Hi, PFA the sample file in which I enter the data in the form and when I click on the Save button, the data is being saved on the Data sheet of the same file. I would like to save the data on a different file for eg. “QMF Data.xls”. Could anyone help me with the same? Thanking you in anticipat

$$Excel-Macros$$ Extracting Specific string and corresponding and so on.

Dear All, Greetings of the day! I have an excel file with bulk of contents in following format. Col A contains description, Colc Contains (Size inches to the corresponding description) Col D contains the Qty. to the corresponding Description. I want to fetch form ColA i.e( Only Pipe and ELL

$$Excel-Macros$$ Re: Need a function or formula

Hi Pooja Pls find the attached sheet Hemant Hegde 2009/10/31 Pooja Sharma > Hi All, > > I need your help in extracting some words (having defined format) from one > cell in another cell. Attached is a sheet where I have mentioned the case > and the solution I require. > > Hope you will help

$$Excel-Macros$$ Re: Need a function or formula

Hi Pooja, Please find the enclosed file with the solution. Regards, Deepak Rai On Sat, Oct 31, 2009 at 9:25 PM, Pooja Sharma wrote: > Hi All, > > I need your help in extracting some words (having defined format) from one > cell in another cell. Attached is a sheet where I have mentioned the ca