$$Excel-Macros$$ Sorting a column

Hi All I'm trying to code a worksheet so that when I press a button, it sorts the column in numerical order. I have been using the code Private Sub commandbutton12_click() Range(A71:U1000).Select Selection.Sort Key1:=Range(A71), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1,

$$Excel-Macros$$ Lookup for repetitive items

Hi all, I need to apply lookup for repetitive items, if I use normal vlookup, it returns the value with matches with the first record. Is there any way to get 1st value for 1st record and to skip that record subsequenly. The above problem is explained in the attached sheet. P.S. Would prefer

$$Excel-Macros$$ Calculate total premium amount for a selected person.

Dear Friends, Please, solve my problem Find the attached data.. How to calculate total premium amount for a single personusing formula / function? *Agent Name* *Month * *Colleted Date* *Premium amount* Ramesh Feb 2/8/2008 5,000.00 Satish Feb 2/15/2008 15,000.00

$$Excel-Macros$$ Re: Macor for formatting.

Attention Vinu   Here is the code: Sub Macro1() Dim sht For sht = 1 To Sheets.Count     Sheets(sht).Activate     ActiveWindow.Zoom = 100     Cells.Select     With Selection.Font     .Name = Arial     .Size = 9     End With     Range(A1).Select Next sht Sheets(1).Activate End Sub  

$$Excel-Macros$$ Re: Lookup for repetitive items

I have send you the solution on email. Nishant On Oct 23, 4:56 pm, Nidhesh Dhawan [EMAIL PROTECTED] wrote: Hi all, I need to apply lookup for repetitive items, if I use normal vlookup, it returns the value with matches with the first record. Is there any way to get 1st value for 1st

$$Excel-Macros$$ Re: Calculate total premium amount for a selected person.

You can do a pivot table or try the sumif function Nishant On Oct 23, 11:44 am, Santhosh Kumar M K [EMAIL PROTECTED] wrote: Dear Friends, Please, solve my problem Find the attached data.. How to calculate total premium amount for a single personusing formula / function?    

$$Excel-Macros$$ Re: Sorting a column

This will happen when your numbers are in text. If you can send me a file with example i can try Nishant On Oct 23, 2:36 pm, [EMAIL PROTECTED] wrote: Hi All I'm trying to code a worksheet so that when I press a button, it sorts the column in numerical order. I have been using the code

$$Excel-Macros$$ Re: Sorting a column

Hi, Just formatting a cell as number after the cell has received data, does not change the format of the data. If all your data is numeric, then follow these steps to actually change your data to numbers: 1. Select Range A71:A1000 2. Format as number. 3. Enter 1 into an unused cell, then

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

Thanks dude, It worked wonderfully!! Regards Abhijit _ From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of SINGHAL, ATUL. Sent: Thursday, October 23, 2008 2:36 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ Hi

$$Excel-Macros$$ Re: Calculate total premium amount for a selected person.

Hi, Use Pivot table. check the attachment. On Thu, Oct 23, 2008 at 12:14 PM, Santhosh Kumar M K [EMAIL PROTECTED]wrote: Dear Friends, Please, solve my problem Find the attached data.. How to calculate total premium amount for a single personusing formula / function?

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

Dear Mr. Atul, But formula can not read text comm for taking value of %, it is taking the same on fifo basis. Regards, Kamlesh On Thu, Oct 23, 2008 at 2:35 PM, SINGHAL, ATUL. [EMAIL PROTECTED] wrote: Hi Abhi, I think, the enclosed file can solve your problem. Regards CA. Atul Singhal