Re: $$Excel-Macros$$ Top Poster of the month :- Dave Bonallack

Congrats Dave. . . !! Best Regards, DILIPandey On 9/3/10, Ayush wrote: > Hi Group, > > I am glad to announce that Dave Bonallack has topped in posting for > the month of Aug'10 with 67 Posts (9% of group posts). He has done it > repetitively for two months. Thank you , Dave > > I encourage you a

$$Excel-Macros$$ Top Poster of the month :- Dave Bonallack

Hi Group, I am glad to announce that Dave Bonallack has topped in posting for the month of Aug'10 with 67 Posts (9% of group posts). He has done it repetitively for two months. Thank you , Dave I encourage you all to make your contribution by sharing tip , tricks and solutions. This is your group

$$Excel-Macros$$ cells resize

Hi can some one help me on the attached worksheet query -- Thanks Rajesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our L

Re: $$Excel-Macros$$ IF(OR(ISERROR challenge

Your formula is perfect. But the Calculation Options are set to "manual", so you need to press F9 to calculate (or go to "calculation options" and check "automatic") Regards, Bruno On Wed, Sep 1, 2010 at 1:19 PM, Kurt wrote: > Posted it to the file list. It's called ISERROR Example.xls. > > > O

$$Excel-Macros$$ Formula for Military Time Calculations

I need to determine time increments from postings in Excel in the 24 hour mode (commonly called military time). I can't come up with a formula to give me decimal hours from military time subtractions. Help please! JohnA -- ---

$$Excel-Macros$$ Question about excel report

Hi: I am new to excel and I was wondering hiw I would do the following. I have an excel worksheet with names of people in a sheet going from column A to X and row 1 to 10. I would like to get a worksheet showing the location and then name. Ex: A1=John, A2=Smith and so on. Is this easily done? a

Re: $$Excel-Macros$$ sumif kinda formula needed

Just for curiosity, do you really want to put all the information in the same cell? For example, instead of putting in the "this month" cell [*A Swanepoel, D Michaels, E Fielies, F Ntinga, G Deafe*], don't you think it would be better if you had 1 name per cell? Or is this way of displaying names n

Re: $$Excel-Macros$$ which events should i use in textbox .

I think you're looking for the _Change event. For example, if your criteria for the first textbox be complete is it having 2 numbers, you could use: Private Sub TextBox1_Change() If Len(TextBox1.Value) = 2 Then TextBox2.SetFocus End Sub Regards, Bruno On Thu, Sep 2, 2010 at 5:17 AM, neil johnson

Re: $$Excel-Macros$$ sumif kinda formula needed

Formula for AGE and UDF for SUMMARY see attachments On Thu, Sep 2, 2010 at 7:23 PM, Phillip Swanepoel wrote: > Hi > > This posting relate to a earlier one regarding birthdays on a excel > sheet. > > in column b i got the /mm/dd > column c i got the person name and last name > column d i got

Re: $$Excel-Macros$$ extract only product name

Put *ARRAY FORMULA* =LEFT(A2,MAX((MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)=" ")*(ROW(INDIRECT("1:"&LEN(A2)-1) into cell B2; copy B2 and paste to B3:Bn On Wed, Sep 1, 2010 at 5:11 PM, Kal xcel wrote: > Dear Experts, > I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits Inst

$$Excel-Macros$$ I love excel because.......

Dear All, I love Excel more than any Software in the World, I'm not alone, millions and millions of people around the world use it too and, more or less, Love it. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 0

Re: $$Excel-Macros$$ I love excel because.......

I am Insurance Advisor I my self has more then 2000 clients i have made excel as my base software which helps me to solve my all daily updates. Even the LIC Private Software is not giving that much satisfaction & need base soultion which Excel gives me. Even I love this group also from which

Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

Hi, 1. You need to press Alt+F11, and open the visual basic editor. 2. Double click on "This Workbook" 3. Paste the code. *Private Sub Workbook_Open()* Sheets("Sheet2").Select Range("A494").Select *End Sub* 4. Save the file (For XL 2003 as .xls , or for XL 2007 as .xlsm) 5. Close the file and tr

Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

Sir. Thanks for your fast reply. I have put this in View Code. -- but stil it does not work until i press run in view code. I have another function also in that as follows Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True Target.EntireRow

$$Excel-Macros$$ sumif kinda formula needed

Hi This posting relate to a earlier one regarding birthdays on a excel sheet. in column b i got the /mm/dd column c i got the person name and last name column d i got the age of the person in h10 i need every one that has birthday today with theiry respective age next to the name. since the

$$Excel-Macros$$ Re: Help Needed!

Hi Vasant, I am trying to create a macro to do this below task to avoid manual efforts. For more details please refer the below email. Here is my code- Sub Movefiles() Dim a As Integer Dim fso, f2 With Application.FileSearch .LookIn = "C:\LLF\" & Range("A1").Value .FileType =

RE: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

gt;<><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe __ Information fro

Re: $$Excel-Macros$$ How to create Speedometer chart in Excel

Hi Pankaj, Pl go through this link http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm Regards, Andy On Thu, Sep 2, 2010 at 12:39 PM, Intelligent But Crazy wrote: > Hi Experts, > > > -- > Pankaj Pandey > Bhopal > > -- > > --

$$Excel-Macros$$ VB excel code throwing up error, out of my zone ..

Hi, I have a user who has approached me with an Excel coding issue. Here is the problem and the code. If anyone can run through this and fix then it would be most appreciated. I simply do not have the knowledge or skill in this area to assist. Run-time Error ‘9’: Subscript Out of Range which pop

Re: $$Excel-Macros$$ I love excel because.......

I like excel because "All office/home work can be put in ONE ie., Excel !!! Elizabeth On Thu, Sep 2, 2010 at 10:05 AM, johnson john wrote: > One can run a Billion Dollars company with Excel without any ERP support. > > On Wed, Sep 1, 2010 at 9:41 PM, kamal shah wrote: > >> Simp

Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

Hi, Please use the following code: *Private Sub Workbook_Open()* Sheets("Sheet2").Select Range("A494").Select *End Sub* Cheers! Andy On Thu, Sep 2, 2010 at 9:58 AM, big smile wrote: > Respected Excel Guru's > > How to make the macro so that > > When ever i start the file my cursor goes into

$$Excel-Macros$$ How to create Speedometer chart in Excel

Hi Experts, -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin