Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

for a honest Friendship. If you wish accept the invitation by replying to this mail and i wish to share with you your experience and knowledge. Waiting in anticipation for your reply. Regards Ahmed Bawazir. On Tue, Jul 13, 2010 at 12:59 PM, Dilip Pandey dilipan...@gmail.comwrote: Hey mr

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

no such units. Regards Ahmed Bawazir On Tue, Jul 13, 2010 at 12:59 PM, Dilip Pandey dilipan...@gmail.comwrote: Hey mr. Soni.. Two Charts has been created as per your requirements 1) Normal chart 2) Pivot Chart Get back to me in case of any queries. -- Thanks Regards, DILIP KUMAR PANDEY

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Profit share assured !! Best regards Rajesh On Tue, Jul 13, 2010 at 6:00 PM, Dilip Pandey dilipan...@gmail.com wrote: Hey Ahmed.. the Honest man.!! :) You are most welcome to share the knowledge and experience(s) and offcourse for a friendship filled with learning - both the sides

Re: $$Excel-Macros$$ rank column

HI Subbu, I hope you have found the solution for this query. Recently I came across a similar kind of query and after solving that I have customized the solution to solve your query. Please find the attached solution and let me know if this helps. Thanks. -- Thanks Regards, DILIP KUMAR

Re: $$Excel-Macros$$ Query - How To Find out Month

Hi Nikhil, Try below formula:- =DATE(YEAR(C3),MONTH(C3)-6,DAY(C3)) Note:- Day portion of Date may vary as per the exact calculation, please revert if you need 31 or 30 as the date every time. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744

Re: $$Excel-Macros$$ Query - How To Find out Month

..I have apply this formula..it working Regards Nikhil Shah On Wed, Jul 7, 2010 at 6:15 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Nikhil, Try below formula:- =DATE(YEAR(C3),MONTH(C3)-6,DAY(C3)) Note:- Day portion of Date may vary as per the exact calculation, please revert

$$Excel-Macros$$ Fwd: Help Accounting

FYI FYNA...!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- Forwarded message -- From: Jitender jitenderdev...@gmail.com Date: Thu, 8 Jul 2010 09:26:57 -0700 Subject:

Re: $$Excel-Macros$$ Re: Required Formula

. Thanks a lot for your time. Regards Ahmed HONEST MAN On Mon, Jun 28, 2010 at 2:45 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Ahmed... the Honest Man.. :) Attached file is solved as per your requirements. Let me know if this helps you, get back in case of queries. -- Thanks Regards

Re: $$Excel-Macros$$ Re: Required Formula

dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, Jun 28, 2010 at 9:03 PM, Dilip Pandey dilipan...@gmail.com wrote: Will check and revert..!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan

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

helpful. I hope I'm not imposing too much. My question: I have a cell that I'd like to write a formula that returns all but the first 8 characters. The cell's data can be any length. Thanks. -- *From:* Dilip Pandey dilipan...@gmail.com *To:* Nadine S

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

Thx Gaurav, best regards, Dilipandey On 6/29/10, GAURAV JAIN jaingaura...@gmail.com wrote: Hi Dilip, Discription is nice one. Cheers, Gaurav Jain On Sat, Jun 26, 2010 at 11:15 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Swapnil, Below is a little explanation of the formula which

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

You are always welcome. . !! Thx, DiLipandey On 6/28/10, Nadine S n8dine4ma...@yahoo.com wrote: Thank you so much for your help!!! From: Dilip Pandey dilipan...@gmail.com To: Nadine S n8dine4ma...@yahoo.com Cc: excel-macros@googlegroups.com Sent: Mon

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

Hi Nadine, Attached file is solved as per your requirements. check the file and revert in case of any questions. :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 6/26/10, Nadine S

$$Excel-Macros$$ Re: Required Formula

Hi Ahmed, I am using Excel 2003 and the pivot is not showing up for me (Actually the data part is missing). It will be useful for members like me if you can present your desired output without pivot, so that we can have a look. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

Thanks Dave...!!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 6/26/10, Dave Bonallack davebonall...@hotmail.com wrote: Hi Dilip,Excellent solution!Regards - Dave Date: Fri, 25 Jun

Re: $$Excel-Macros$$ Inbuilt count is counting an empty cell

-Original Message- From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Saturday, 26 June 2010 8:05 PM To: Matthew Kay Cc: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Inbuilt count is counting an empty cell Yes Matthew, You are right. In Excel, these highlighted cells

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

, India On 6/26/10, Swapnil Palande swapnilp1...@gmail.com wrote: Hi Dilip, This is excellent solution. But I am not able to understand it. Can you explain it. Regards, Swapnil. On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey dilipan...@gmail.com wrote: Thanks Dave...!!! -- Thanks

$$Excel-Macros$$ Re: Suresh Babu :Query

Please send your query and don't forget to mark that email to our Group as well (excel-macros@googlegroups.com) so that everyone gets a fair chance to help and learn :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com

$$Excel-Macros$$ Re: plz help me Its Urgent

Hi Anil, Are you looking out to create pivot table in MS Word OR you want to create pivot table in MS Excel using data source from MS Word ? I think below link might help you:- http://support.microsoft.com/kb/170745/en-us -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile:

Re: $$Excel-Macros$$ Inbuilt count is counting an empty cell

Hi Mat, Would it be possible for you to share that spreadsheet where you have copied cross tab query. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Jun 25, 2010 at 12:08 PM, Mat

Re: $$Excel-Macros$$ Help: powerpoint shortcut

Right...!! And ideally it would work for all the registered programs in windows. Check the attached image which has the name of the program (.exe) and it is the name which should be entered in Start-Run command. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91

Re: $$Excel-Macros$$ Re: Please help - VBA book

Dear Taruna, Try subscribing various online Google / Microsoft forums as well, which will benefit you in your learning. Start with Recording macro and then look out the codes in the visual basic editor. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

, Jun 25, 2010 at 6:12 PM, Dilip Pandey dilipan...@gmail.comwrote: Hey Aindril thanks for your encouraging words... :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri

Re: $$Excel-Macros$$

Hi Iqbal, If your data is scattered, then a macro wld be useful in this task. Sub delrow() Application.DisplayAlerts = False Application.ScreenUpdating = False Cells(1, 1).Select For a = 1 To 65536 Selection.EntireRow.Select If Application.WorksheetFunction.CountA(Selection) 1 Then

Re: $$Excel-Macros$$ Estimating with Excel

Hi, I would suggest you to prepare a sample spreadsheet and forward that to Group as an attachment. For bringing in the large data, you can use Data - Import External Data. MS Query (SQL) will help you to modify the import. For validation, you can use Data- Validation with the use of Offset and

$$Excel-Macros$$ Re: Lookup problem -

Dear Vinu, Attached file is re-formulated as per your criteria. Please get back in case of any help. Suggestion:- Please include Group in such emails, so that every one can get a fair chance to learn and help others. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91

$$Excel-Macros$$ Re: Lookup problem -

Thx Vinu, warmest regards, DiLipandey On 5/12/10, Vinu vinu1sm...@gmail.com wrote: Thanks a lot Dilip, Sure going forward will attach group in the mails. On 12 May 2010 15:29, Dilip Pandey dilipan...@gmail.com wrote: Dear Vinu, Attached file is re-formulated as per your criteria

Re: $$Excel-Macros$$ Fw: Maximum Date

Dheeraj, You are always welcome!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, May 10, 2010 at 1:33 PM, dheerajbank...@punjlloyd.com wrote: Thanks Really it is very good I

Re: $$Excel-Macros$$ VBA DATE

Hi Sundarvelan, Same conditional formatting can be done using vba coding (Macros)...!! @ Deepak, please transform that into vba coding and provide to Sundervelan.. I think that would be helpful for him. Thanks. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91

Re: $$Excel-Macros$$ Fw: Maximum Date

to put at sr. no. 17 (as per attached file), it is showing error. Could u please check what is wrong with this. Regards *Dilip Pandey dilipan...@gmail.com* Sent by: excel-macros@googlegroups.com 05/09/2010 08:07 PM Please respond to excel-macros@googlegroups.com To excel

Re: $$Excel-Macros$$ Maximum Date

Thanks Sandy, @ Dheeraj, I think you have got the answer for your query. Get back, in case of any other queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, May 10, 2010 at

Re: $$Excel-Macros$$ Maximum Date

Already answered thisone let me know in case u missed d same. Thx, diLipandey On 5/9/10, dheerajbank...@punjlloyd.com dheerajbank...@punjlloyd.com wrote: Dear All, I have a spreadsheet containing quite a lot of data, one of the columns is date one of the data. My user would like to see the

Re: $$Excel-Macros$$

. Thanking once again. Regards *Dilip Pandey dilipan...@gmail.com* 05/05/2010 02:17 PM To excel-macros@googlegroups.com cc dbank...@gmail.com Subject Re: $$Excel-Macros$$ Hi Dheeraj, Attached is the solution you require. Further to this, I have also considered the fact

Re: $$Excel-Macros$$ Help needed to calculate incentive

Hi Rajeev, Attached file has been solved as per your requirements. Get back to me in case of any issues. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Wed, May 5, 2010 at 1:10 AM,

Re: $$Excel-Macros$$

Hi Dheeraj, Attached is the solution you require. Further to this, I have also considered the fact that if the data is NOT SORTED, then still it gives right answer. Get back to me in case of any challenge(s). -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91

Re: $$Excel-Macros$$ Help needed to calculate incentive

Dear Rajeev, I can assume that you are using version above then Excel 2003 to apply CountIfs. Alternatively, you can use Countif with Array functionality or some other function like Sumproduct. If possible, share the test file with the Group. -- Thanks Regards, DILIP KUMAR PANDEY

Re: $$Excel-Macros$$ Help me in contitional formating

U r always welcome. Thanks n Best of luck. DiLipandey On 4/30/10, vinod rao vinod.ma...@gmail.com wrote: Hi Dilip, Exactly, i worked. Thank you very much. thanks Vinod On Thu, Apr 29, 2010 at 1:53 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Vinod, Your desired solution

Re: $$Excel-Macros$$ Need Help

Dear Balbir, copy the respective data and press popup key in your keyboard, then s then e and press Enter. (copy-paste special- tanspose Enter) :) Pivot table is also a good option to give a try. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744

Re: $$Excel-Macros$$ Help me in contitional formating

Dear Vinod, Your desired solution is attached with this email. :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Apr 27, 2010 at 11:39 PM, vinod rao vinod.ma...@gmail.com wrote:

Re: $$Excel-Macros$$ Help with Median Formula

notice is that the formula entered by Dilip has a flower Braces start and closed in formula {=MEDIAN(IF($B$3:$B$28=H4,$C$3:$C$28,))} if i try to put flower braces the format of the cell gets changed to Text. Please help or advice... Regards Gopi On Thu, Apr 29, 2010 at 2:30 PM, Dilip

Re: $$Excel-Macros$$ Help with Median Formula

the formula is working. Regards Gopi On Thu, Apr 29, 2010 at 3:33 PM, Dilip Pandey dilipan...@gmail.comwrote: Dear Gopi, After entering the formula, just press Ctrl + Shift + Enter. This will include those brackets for you (Array Functionality) Let me know if you face any challenge(s

Re: $$Excel-Macros$$ Help with Median Formula

dilipan...@yahoo.com New Delhi - 62, India On Thu, Apr 29, 2010 at 4:49 PM, Vinod N nvino...@gmail.com wrote: Boss... You are awesome...!! Kudos to your excel knowledge Luv Vinod On Thu, Apr 29, 2010 at 2:30 PM, Dilip Pandey dilipan...@gmail.comwrote: Dear Gopi, Using Median

Re: $$Excel-Macros$$ SAS

Dear pratap, it is ok for mis analyst. SAS is statistical analysis tool n should be learnt if ur mis profile includes working on models or engineering domains. But yes learning of SAS will b a + point. :) thx, DiLipandey On 4/21/10, pratap sunilpratapsingh1...@gmail.com wrote: Good evening All,

Re: $$Excel-Macros$$ Help with Autofill Increment

Hi Nick, Check the attached solution. It's working great. Let me know in case of any queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Apr 23, 2010 at 12:22 AM, Bunyano

Re: $$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field

Hi Cecilia, Try the solution attached with this email. You need to apply the protection to the spreadsheet and just need to check the checkboxes as shown in the solution. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com

Re: $$Excel-Macros$$ Permutations and combinations

Dear Michael, So do you want only two numbers to sum up - at a time 1+19 or you want scenarios like below:- 5+5+5+5 - means more than two digits. ? -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62,

Re: $$Excel-Macros$$ Permutations and combinations

On Thu, Apr 15, 2010 at 4:55 PM, Dilip Pandey dilipan...@gmail.comwrote: Dear Michael, So do you want only two numbers to sum up - at a time 1+19 or you want scenarios like below:- 5+5+5+5 - means more than two digits. ? -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons

Re: $$Excel-Macros$$ : How to add the current month Date in the header

Hi Sundarvelan, For first of the current month, use following function:- =DATE(YEAR(TODAY()),MONTH(TODAY()),1) For current date, use following function:- =TODAY() -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com

Re: $$Excel-Macros$$ Fwd: Help Required

Hi Venkatesan, Up to Excel 2003, go to Tools- Macro- Record New Macro. Now perform some actions on excel spreadsheet. Press Alt + F11 when you are done. Select modue 1 under your workbook's name in left pane and watch out for the code. These are the codes which excel has created as per your

Re: $$Excel-Macros$$ If condition issue

Hi Raj Kumar Just solved this query for Anil, please check my reply and if not able to find the same do get back to me. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Apr 9, 2010

Re: $$Excel-Macros$$ MATCH question

Hi Tom, Check the attached file and let me know if you face any challenge(s). -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Apr 9, 2010 at 4:36 AM, tomfabtas...@hotmail.com

$$Excel-Macros$$ Re: Plz do the Needful Sir

Dear Anil, Attached file is solved per your requirements. Get back to me in case of any queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Apr 9, 2010 at 4:44 PM, Anil Saxena

$$Excel-Macros$$ Re: Plz do the Needful Sir

, 2010 at 5:07 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Anil, Attached file is solved per your requirements. Get back to me in case of any queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com

$$Excel-Macros$$ Re: Plz Help me urgent

, 2010 at 2:40 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Anil, Attached file is solved as per your requirements. Formula is also there. Let me know if you have any queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com

Re: $$Excel-Macros$$ Re: Plz Help me urgent

: hi,, dear i have one problem. how to copy and paste formula because this is array formula function.. On Thu, Apr 8, 2010 at 2:40 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Anil, Attached file is solved as per your requirements. Formula is also there. Let me know if you have

Re: $$Excel-Macros$$ Urgent Help

Dear Sudhir, Attached file has been solved per your requirements. Get back to me in case of any queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Apr 6, 2010 at 7:44 PM,

Re: $$Excel-Macros$$ Excel Formula Required

Dear Venkatesan, Attached file has two solutions for your query. Let me know in case of any challenge(s). -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Thu, Mar 18, 2010 at 2:31 PM,

$$Excel-Macros$$ Re: FORMULA FOR EXCELL SHEET

-- *From:* Dilip Pandey [mailto:dilipan...@gmail.com] *Sent:* Thursday, March 11, 2010 5:09 PM *To:* MOHAMMED IQBAL IRFANI *Cc:* excel-macros@googlegroups.com *Subject:* Re: FORMULA FOR EXCELL SHEET Hi, Attached sheet is solved per your requirements. let me know if you still face any

Re: $$Excel-Macros$$ Attendance Tracker

Hi, I have checked and I do not have a readymade Attendance Tracker available with myself. Please try to build up the tracker by your own and let the Group know if you face any challenge(s). -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744

Re: $$Excel-Macros$$ How to update excel in network by multiple users

, Nandkumar kakvipure nandkumar.hindust...@gmail.com wrote: Hi, Pls Tell Me office excel 2007 Thanks in Advance On Tue, Mar 2, 2010 at 7:48 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Niraj, First Step. Go to Tools-Protection- Allow users to Edit Ranges. Here you can assign different

Re: $$Excel-Macros$$ How to update excel in network by multiple users

Hi Niraj, First Step. Go to Tools-Protection- Allow users to Edit Ranges. Here you can assign different different ranges to be used by different users and you can also include password, if you wish. Second Step. Now share the spreadsheet with users and share the passwords for different level

Re: $$Excel-Macros$$ Radio Button

Dear Shiv, Please see the attached file. I have achieved the desired result without VBA coding. :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Mar 2, 2010 at 11:51 AM, Shiv Goel

Re: $$Excel-Macros$$ Radio Button

On Tue, Mar 2, 2010 at 8:19 PM, Ramkrishna Padhi padhi.ramkris...@gmail.com wrote: Hi Dilip, That was great. Can you please share how did you do that? Thanks Regards, Ramkrishna T. Padhi On Tue, Mar 2, 2010 at 7:59 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Shiv, Please see

$$Excel-Macros$$ Re: month between two different month..formula

Dear Umesh, I hope that your query has been answered by Mr. Luka, please revert if you still feel unsolved. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, Mar 1, 2010 at 7:48 PM,

Re: $$Excel-Macros$$ Re: Application.commandbars

-- *From: *Dilip Pandey dilipan...@gmail.com *Date: *Thu, 25 Feb 2010 23:30:20 +0530 *To: *excel-macros@googlegroups.com *Cc: *harpreetguj...@gmail.com *Subject: *Re: $$Excel-Macros$$ Re: Application.commandbars Dear Harpreet, I believe this is something related to menu creation

Re: $$Excel-Macros$$ show progres in history diagram

cheers Steen 2010/2/22 Dilip Pandey dilipan...@gmail.com Hi, Please find the attached solution. Let me know in case of any queries. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

Dear all, I would suggest to search internet for free VBA password breakers / crackers, else one can buy the same from open market as well. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India

Re: $$Excel-Macros$$ how to crack Excel VBA password

Dear all, I would suggest to search internet for free VBA password breakers / crackers, else one can buy the same from open market as well. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India

Re: $$Excel-Macros$$ The Best Add-ins.... and that's too freeeee.......

Good one...!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 2/22/10, VIRAL PANDYA pandya@gmail.com wrote: Dear All, I am using the attached addins WST macro. and like to share

Re: $$Excel-Macros$$ How to skip non working days to calculate number of days betewwn dates ??????

Dear Abdul, Use Networkdays function to accomplish this task. An example is attached with this email. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 2/22/10, Abdul Rasheed

Re: $$Excel-Macros$$ Help

Dear Shiv, I believe seeking help for each set by set of the entire code will not help you. You should search these keywords in google or other search engines for explanation. Alternatively, you can connect with the person who has written this code to understand exactly the reasons/ fundas. --

Re: $$Excel-Macros$$ show progres in history diagram

Dear Steen, If the values will be overwritten on each day, then what source will chart (histogram) would use? I belive the chart needs to have the data source to which it can reference. Alternatively, you can use VBA coding to store these values at some other location, but Still these data would

Re: $$Excel-Macros$$ Could you pls help me out

correctly!! Regards, Vinu. On 7 February 2010 20:29, Dilip Pandey dilipan...@gmail.com wrote: Dear Vinu, Formula is revised as per new scenario. Check the attached file and let me know in case of any challenge(s). Thanks Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA

Re: $$Excel-Macros$$ how to get top ten values from a list

nt work . On Sun, Feb 7, 2010 at 10:00 PM, Dilip Pandey dilipan...@gmail.comwrote: You are always welcome Vimal...!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 2/7/10

Re: $$Excel-Macros$$ Histogram frequency like functionality

On Sat, Feb 6, 2010 at 8:40 AM, Dilip Pandey dilipan...@gmail.comwrote: Dear Drew, Attached is the solution which will help you to proceed further. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi

Re: $$Excel-Macros$$ Could you pls help me out

vinu1sm...@gmail.com wrote: Hi Dilip, Thanks for your formula, its really cool. still I am unable to get proper answer from your array formula. Pls look into my v1 attachment. Regards, Vinu. On 6 February 2010 19:39, Dilip Pandey dilipan...@gmail.com wrote: Dear Vinu, Attached

Re: $$Excel-Macros$$ how to get top ten values from a list

saved my lot of manual time . thanks a ton . Cheers, Vimal Barlota On Sun, Feb 7, 2010 at 8:53 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Vimal, Attached file has been formulated as per your requirement(s). Get back to me in case of any queries. Thanks Regards, -- DILIP KUMAR

Re: $$Excel-Macros$$ Converting .xlsm to .xls

Dear Harpreet, Alternatively, you can search and install Compatibility pack of Office 2007. After the installation, whenever you'll open Office 2007 file in Office 2003, the file would automatically convert and open in Office 2003. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA

Re: $$Excel-Macros$$ Help - Sheet protection restricts hide/unhide rows from vba code

Dear Nick, This is because you have used unprotected the sheet -twice in your code, which is reproduced below:- ActiveSheet.Unprotect Password:=(password) at the start of the code and then unprotect at the end. -- - - this line unprotects the sheet you need to correct the your code, else

Re: $$Excel-Macros$$ minimize a userform

Dear Kavi, See the below link. http://www.vbaexpress.com/kb/getarticle.php?kb_id=165 Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Thu, Feb 4, 2010 at 11:42 AM, memonkavi

Re: $$Excel-Macros$$ Single Cell Text Manipulation

was a macro...Thanks again! Steve On Jan 23, 4:30 am, Dilip Pandey dilipan...@gmail.com wrote: Dear Steve, An formulation is done and tested in attached file. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan

Re: $$Excel-Macros$$ Condition macro - please solve

Dear TAIgo, Attached workbook has the scenario mentioned by you alongwith the required macro. Let me know in case of any query. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/25/10, TAlgo

Re: $$Excel-Macros$$ Auto Filter using Macro or Formula

wrote: Hi Dilip, Thanks for your help. But when I tried to use pivot table for my original file, it is not working. Because of its limitation. Regards, Sandip On Sat, Jan 30, 2010 at 11:09 AM, Dilip Pandey dilipan...@gmail.comwrote: Dear Sandip, The format which you desire can

Re: $$Excel-Macros$$ Auto Replace Hyperlink

Dear Sandip, Attached is the customised solution as per your requirement(s). Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 1/31/10, San Pat myitems2...@gmail.com wrote: Hi Friends, I

Re: $$Excel-Macros$$ Pivot table output to pdf with multiple page fields

Dear TheoMa, one suggestion here:- Install Adobe Acrobat professional and then you can convert the each page output as PDF in a single click. Let me know if other information is required on this line. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744

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

Dear Gopi, I am little confused per below points:- 1) Do you want if a user enters the data which is there in Column B, in any of their respective locations at present, then to print the keywords as given by you in column C. For example, if a user enters any of the following in Cell B3 to B7,

Re: $$Excel-Macros$$ Copy Excel Data from sheet and fill in already opened internetexplorer and submit and repeat for 10 similar postings

Dear Alok, I am wondering if jitbit is something similar to workspace macro. Can you explain little bit about it? Thanks for your time. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

Dear Ankur, Would you mind uploading those books in the Files section of the group. This will help lots of users. Connect to manager / admin of the group for necessary help and support. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

Re: $$Excel-Macros$$ Web query return with no data....

Dear Saurabh, Just a little explanation on this:- If you have a database, suppose MS Access Database having sales details of Mon to Fri and you used to query this database from a query (may be Microsoft Query or SQL etc) and someday you quered this database for Sat or Sun data, then you might get

Re: $$Excel-Macros$$ counting number of people who are on shift

Hi Sabby, You can accomplish this taks with some nested Excel functions. Please provide a test scenario in a spreadsheet for the group to help you better. Try including all / most of the complex scenarios to get them covered in the soution. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B

Re: $$Excel-Macros$$ Compare lists and return missing data

Dear Cecilia, I was little occupied in some other month closing deliverables at my office, hence late reply :) Yes, the code is good. VBA will release the variables after end sub. I believe e is the values which automatically finishes up during code execution and a is the range which is set as

Re: $$Excel-Macros$$ Function to return days by month

You are welcome Cecilia, Let me know in case if you stuck somewhere in your project. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/29/10, Cecilia Chiderski cecic...@hotmail.com wrote:

Re: $$Excel-Macros$$ Compare lists and return missing data

Just wanted to share a tip here:- In order to check if the variables used in the code are empty or have some values still left within them, you can use following code just before the End Sub msgbox e Note:- It will show you the value of e in a pop-up message box. Best Regards, -- DILIP KUMAR

Re: $$Excel-Macros$$ Function to return days by month

Replied to that email seperately, let me know if you did'nt find the same. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/30/10, Cecilia Chiderski cecic...@hotmail.com wrote: Thanks!

Re: $$Excel-Macros$$ Macro Help

Dear Maulik, There are some materials uploaded in Files section of this group itself. http://groups.google.com/group/excel-macros/files You can also search google for other learning materials. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744

Re: $$Excel-Macros$$ Re: Password crecker for Excel workbbok

Dear Maulik, I would suggest to search google or other search engines for Free Excel Password Breaker, alternatively you can purchase the Office Password Cracker from open market. There are some paid websites as well, who will charge you some fee and crack the password for you. Best Regards, --

Re: $$Excel-Macros$$ The Aspiring Writer ;)

Dear Ayush, Great piece of information :) Can we know the source of this news or at least the name of that person, if possible? Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/28/10, Ayush

Re: $$Excel-Macros$$ Function to return days by month

Dear Cecilia, If you want to include next year range within that formula set, then you might want to go ahead an include function YEAR with MONTH. For example:- MONTH(T$2)=MONTH($C3) will change to :- AND(MONTH(T$2)=MONTH($C3),YEAR(T$2)=YEAR($C3)) Suggestion:- you should inlclude new year right

Re: $$Excel-Macros$$ Link from one excel file to another excel file

vnsktm...@gmail.com wrote: i will attach 2010/1/23 Dilip Pandey dilipan...@gmail.com Dear Mani, Your message / query is not clear. It would be great if you can attach the spreadsheet along with the target results which you are seeking for. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B

Re: $$Excel-Macros$$ How to assign rank from the list

3 Your futher help or guidance is much appreciated ! Thanks once again Atul On Jan 26, 12:52 pm, Dilip Pandey dilipan...@gmail.com wrote: Dear Atul, Please find the attached solution. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744

<    1   2   3   4   5   6   7   8   >