$$Excel-Macros$$ Re: VBA - Access multiple Excel instances

Hi Paul, I've seen your post in the microsoft news groups, so you may have seen this link, but take a look at it anyway. Multiple instances of XL have always been a problem as far as VBA is concerned.

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

Dear this file have opened in my system and office version 2003 if u want to open 2007 version plese try open as 2003 in 2007 version ok my no. +919466848388 Sandeep Mathur --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

I will try to solve this problem sorry i m late i m not a regular user thats why i cann't rply soon bye have a nice day --~--~-~--~~~---~--~~ -- Some important links for excel users:

$$Excel-Macros$$ Nested Formula

I want these data in the format provided in sheets 510,511 and 512 and in the given format. I have been using autofilter option,by filtering period column and wages column and creating new sheets, then using vlookup formula to pull the data into my reports there any formula wherein I can pull the

$$Excel-Macros$$ Nested Formula

Please let me know how can i send the excel file or where can i upload it --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ Re: Nested Formula

Please reply to this email with the attachment On Sat, Sep 12, 2009 at 4:07 PM, Jitu 7jit...@gmail.com wrote: Please let me know how can i send the excel file or where can i upload it --~--~-~--~~~---~--~~

$$Excel-Macros$$ Excel to MDB... Auto analysis

Hi All Excel Gurus, Help required in below. I have few excel spreadsheets which contains the share rates. (Daywise share rate for all the shares) What I want is... Macro which will copy all the data from all the spreadsheets to mdb (MS access) file. Lateron would like to have a macro which

$$Excel-Macros$$ Pls Help- Div by Zero error

While calculating the IRR this error occurs. Could anyone help   Anup Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Help on formula

Hi Dhananjay, It's perfectly ok, and you are always welcome to seek support. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/12/09, Dhananjay Pinjan dppin...@gmail.com wrote: Hello Dilip,

$$Excel-Macros$$ Re: find replace Suffix / cell

Hi Manoj, Attached workbook has been solved with explanation. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/11/09, Manoj Kukrej manoj...@ocimumbio.com wrote: hi, Pls find the attached

$$Excel-Macros$$ Re: Pls Help- Div by Zero error

Hi Anup, It is happenning because you are dividing some thing (any number) with Zero. To avoid this, you should use ISERROR function. =If(iserror(your divison formula),,your divison formula) For better understanding, attach your spreadsheet. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B

$$Excel-Macros$$ Re: Nested Formula

Hi Jitu, You can use DSUM or SUMPRODUCT to solve your query. For better illustration, you should attache the sample test file. It is very simple to attach the file, just send an email to excel-macros@googlegroups.com and attach the file. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B

$$Excel-Macros$$ Help plz

Hello Frnds I want some solution I want to separate First Name, Middle Name Last Name means if I hav Full name in A1 then i want First name in B1, Middle Name in C2 Last name in C3 -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Help plz

Hi Prashant, Refer to the attached file. I have given two set of nested formulas to achieve the required results. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/12/09, Prashant Bhawar

Fwd: $$Excel-Macros$$ Excel to MDB... Auto analysis

Hi excel gurus.. can someone help me on below problem.. -- Forwarded message -- From: pradeep palande bunty5...@gmail.com Date: Sat, Sep 12, 2009 at 4:37 PM Subject: $$Excel-Macros$$ Excel to MDB... Auto analysis To: excel-macros@googlegroups.com Hi All Excel Gurus, Help

$$Excel-Macros$$ Excel VBA to colorize cell based on another cell

I have approximatedly 34 different desired color combinations I would like to colorize certain cells based on selected value. I.e., in English, it would be something like: Black=0 :White=2:Red=3 :Green=4 Blue=5 :Yellow=6 :Magenta=7 :Cyan=8 Get value of AK40, call it Supply

$$Excel-Macros$$ Classic Excel 2003 Style Menu in Excel 2007 (Free Download)

You will have a classic mode, right? - Bill Gates to Jensen Harris, after seeing the Office 2007 ribbon Bill Gates was smart enough to see that Office 2007 needed a classic mode. But somehow, the Office development team convinced him that a classic mode wouldn't fit with the future direction of

$$Excel-Macros$$ Re: Calculate Latest Value

Hi Mahesh, Attached query has been solved using different formula(s). Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/11/09, mahesh parab mahes...@gmail.com wrote: Dear All in attach sheet i

$$Excel-Macros$$ Re: Lookup Query

Hi Gyanesh, Attached query has been solved using two options. Select which you like. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/8/09, gyanesh jain gyanjai...@gmail.com wrote: Hi friends,

$$Excel-Macros$$ Re: Help plz

Hi Prashant, Please find the attached Excel sheet. Hope this would solve your query. Thanks, Sreevijay 2009/9/12 Prashant Bhawar prashant.aca...@gmail.com Hello Frnds I want some solution I want to separate First Name, Middle Name Last Name means if I hav Full name in A1 then i want

$$Excel-Macros$$ find or extract unique values in a column excel

Hi i want to find unique values form sheet 2 on sheet 1 anyone knws the formula. Thanks, --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA