$$Excel-Macros$$ Fwd: Immediate Joinee required for VBA,EXCELand MACROS in Gurgaon Location

Pvt Ltd| Tel: (040) 39179113|09346062227 **yso...@magna.in* yso...@magna.in* **www.magna.in*http://www.magna.in/ *|* ** ** -- *Deepak Rai* SAS BASE CERTIFIED Programmer Mobile: 9873415255 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ Need ans for 3 que

Hi Rohan, This is really nice. Regards, Deepak Rai On Fri, Dec 17, 2010 at 9:49 AM, Rohan Young rohan.j...@gmail.com wrote: Hi Hanumant, Just hit Ctrl+F go to option and in look in set the criteria on Values u will get that bye for now Deepak (ROHAN) 9818247278 On Thu, Dec 16, 2010

Re: $$Excel-Macros$$ Rectify this Error

Hi, You can also use name range for *Source Data* Parameter. I usually prefer to use this in my reporting if all my input and output data are in same workbook. Regards, Deepak Rai On Sat, Dec 18, 2010 at 1:35 AM, Daniel dcolarde...@free.fr wrote: Hi, Change the pivottable name eg

Re: $$Excel-Macros$$ Problem regarding sum

Hi Santanu, Please find the solved file. Hope this is what you are looking for. :) Regards, Deepak Rai On Fri, Dec 17, 2010 at 1:42 AM, Rahul Kamal Gandhi myname.ra...@gmail.comwrote: Sir, As per my interpretation your output is in Attached file. Regards, Rahul Gandhi +91-9711772297

Re: $$Excel-Macros$$ Need help on dynamic list

Hi, Please find the attached solution. In sheet one I have two validation lists, which is taking data from Sheet2. Sheet2 has named ranges. Hope this will help you. With the help of Named Range and Indirect formula you can do this very easily. Regards, Deepak Rai On Wed, Dec 8, 2010 at 7:33

Re: $$Excel-Macros$$ cumulative sum in pivot table

Hi Alisha, It would be really helpful if you can share a dump file. Regards, Deepak Rai On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi Group, I have one pivot table. In that I want to show the cumulative sum. e.g. Qtr1 sale:- 10 units Qtr2 sale

Re: $$Excel-Macros$$ Problem with Identify WorkSheet

= sTemp Then MsgBox Sheet already exist MsgBox sh.Name Exit Sub End If Next sh MsgBox Sheet doesn't exist ActiveWorkbook.Sheets.Add ActiveSheet.Name = sTemp End Sub Regards, Deepak Rai On Sun, Nov 14, 2010 at 2:17 PM, Krupesh Bhansali krupeshbhans...@gmail.com wrote: Hi Friends

Re: $$Excel-Macros$$ sum duplicate value

Hi, I will also suggest to use sumif function for this purpose. Regards, Deepak Rai On Sun, Nov 14, 2010 at 2:51 PM, ratu elissa masihgadis...@gmail.comwrote: use SUMIF Formula On Sun, Nov 14, 2010 at 2:25 PM, bhavya khanna bhavya...@gmail.comwrote: Hi Everyone. Can someone explain I

Re: $$Excel-Macros$$ how to know the content of a text box of user form

://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards, Deepak

Re: $$Excel-Macros$$ Importing data into excel

Hi Peter, Sure soon I will send you that consolidation macro. Regards, Deepak Rai On Mon, Oct 4, 2010 at 11:08 PM, Peter Konijn peter@gmail.com wrote: Hi, It works, thanks a lot for your support. I am still curious for the macro of Deepak Rai. Regards Peter 2010/10/3

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

Hi Ayush, Congratulations buddy... Keep up the good work. :) Regards, Deepak Rai On Sun, Oct 3, 2010 at 3:47 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am proud to announce that I am awarded Microsoft Most Valuable Professional MVP on October 01, 2010 for providing technical

Re: $$Excel-Macros$$

, Deepak Rai -- -- 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.com/groups?gid=1871310 3

Re: $$Excel-Macros$$ Urgent Querry

Hi Pankaj, In your case the attached formula can also help. Regards, Deepak Rai On Thu, Sep 30, 2010 at 8:58 PM, Venkat venkat1@gmail.com wrote: Dear Pankaj, Look attached resolved formula Best Regards, Venkat On Thu, Sep 30, 2010 at 6:28 PM, Pankaj Kumar rajputpanka

Re: $$Excel-Macros$$ Importing data into excel

Hi Peter, For this you need to have a common folder where you can store all your Data files after that through VBA macro you can consolidate all those N numbers of Data files into a consolidated excel file. You would not able to do this by manual approach. Regards, Deepak Rai On Fri, Oct 1

Re: $$Excel-Macros$$ Importing data into excel

Peter, I have this macro I will customize it as per your need will soon share the same with you. Regards, Deepak Rai On Fri, Oct 1, 2010 at 11:35 PM, Deepak Rai daksh1...@gmail.com wrote: Hi Peter, For this you need to have a common folder where you can store all your Data files after

Re: $$Excel-Macros$$ Need help list box

://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards, Deepak Rai

Re: $$Excel-Macros$$ Time calculation

Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards, Deepak Rai

Re: $$Excel-Macros$$ How can me make dynamic range in vba

Hi Neil, You can use name range for this, for example Range(Test1).select here Test1 is a name range. Hope this will help you. Regards, Deepak On Sat, Sep 11, 2010 at 2:13 PM, neil johnson neil.jh...@googlemail.comwrote: Hi Everyone, How can we make dynamic range in excel vba. Please

Re: $$Excel-Macros$$ Conditional Formating

Hi Pankaj, On internet you can find lots of learning stuffs on conditional formatting with good examples. On you tube as well there are some good video's on conditional formatting. Hope this will help. Regards, Deepak On Mon, Sep 6, 2010 at 12:43 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:

Re: $$Excel-Macros$$ Date series

Hi Kalyan, Please find the attached solved file. Hope this will help. Regards, Deepak On Mon, Sep 6, 2010 at 1:17 PM, Kal xcel kalx...@gmail.com wrote: Dear experts, I am sending a file where I need to show a series of dates after giving start date end date. File is attached . Thanks

Re: $$Excel-Macros$$ Date series

Hi All, Really nice logics. Keep the good work. Regards, Deepak 2010/9/6 सुधीर इंगळे ingal...@gmail.com Dear Kalyan Kindly check the attach file I think it solve your query Regards, Sudhir Ingale On Mon, Sep 6, 2010 at 8:47 AM, Kal xcel kalx...@gmail.com wrote: Dear experts, I

Re: $$Excel-Macros$$ Urgent help....

Hi Ankit, Please find the attached solved file. Column highlighted with yello color has the solution as requested. Thanks, Deepak On Mon, Jul 5, 2010 at 5:59 PM, Ankit Chandna ankit.chan...@yahoo.inwrote: Hi, hi to all ..i need a help PFA and help me to get reqired result. Regards,

Re: $$Excel-Macros$$ Open Excel File

Hi Jonas, Can u share the code so that I can find the solution for you ? Regards, Deepak daksh1...@gmail.com On Tue, Jun 8, 2010 at 1:32 AM, Jonas sun...@yahoo.com wrote: I have code that exports a query from Access to Excel. At times I am unable to open the Excel file that I created.

Re: $$Excel-Macros$$ trying to delete cells that match search criteria

Hi, Give me a sample file I will solve this for you. Regards, Deepak On Tue, Jun 8, 2010 at 8:35 PM, molinari dh0...@gmail.com wrote: I have a list of reports to be printed out Monday - Friday, where each worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made another

Re: $$Excel-Macros$$ Need help on CONCATENATE and SUM function

Hi, You can modify your formula as =CONCATENATE(FY09-Q4,CHAR(10), (,TEXT(SUM(A2:A4),0,000),)) . Regards, Deepak On Tue, Jun 8, 2010 at 8:31 PM, Sharath Sambrani sharath.c.sambr...@gmail.com wrote: thanks Paul, it worked amazingly! :) On Tue, Jun 8, 2010 at 8:19 PM, Paul Schreiner

Re: $$Excel-Macros$$ duplicating data

at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- Thanks, Deepak Rai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Excel 2007 Power Programming with VBA by John Walkenbach.

subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Thanks, Deepak Rai

Re: $$Excel-Macros$$ CONVERT chk it

/subscribe -- Thanks, Deepak Rai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com

Re: $$Excel-Macros$$ formula for showing multiple of a no.

://groups.google.com/group/excel-macros/subscribe -- Thanks, Deepak Rai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group

Re: $$Excel-Macros$$ Relative references

over 6,700 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 -- Thanks, Deepak Rai

Re: $$Excel-Macros$$ Dataform applied to a database not starting in Row 1

subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks, Deepak Rai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

$$Excel-Macros$$ How to use Countif across workbook??

advice or alternative formula for the same. I want to do it by formula only not by VBA. -- Thanks, Deepak Rai -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins

Re: $$Excel-Macros$$ Re: Add brwose button to MS Excel to retrieve data from MS Access 2007

/subscribe -- Thanks, Deepak Rai -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel

$$Excel-Macros$$ How to Protect Access Database from the Users ?

connectivity with Excel. I am using Office 2007. Any help will be highly helpful for me. -- Thanks, Deepak Rai -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins

Re: $$Excel-Macros$$ Re: Add brwose button to MS Excel to retrieve data from MS Access 2007

. Regards, Deepak Rai On Mon, Dec 7, 2009 at 6:44 PM, Paul Schreiner schreiner_p...@att.netwrote: I suspect you'll be waiting quite a while. adding a browse button is quite confusing. You might as well say: I'd like to add a take the dog for a walk button Because you can't do that with Access either

Re: $$Excel-Macros$$ use of macros

of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks, Deepak Rai -- -- Some important links for excel users: 1. Excel and VBA

Re: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range class failed

Hi, Please try this code, Hope this will help. Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Regards, Deepak Rai On Tue, Dec 1, 2009 at 10:03 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, Try doing it manually

Re: $$Excel-Macros$$ Urgent help on simple macro

Hi, As per my understanding I have attached a solution of it. Please find the attached file. Regards, Deepak Rai On Tue, Nov 17, 2009 at 6:45 PM, vinod rao vinod.ma...@gmail.com wrote: Hello Team, I need a macro to change Column B from Tisp to PAT if the Column D is Core Regards, VR

Re: $$Excel-Macros$$ Urgent help on simple macro

Hi, Thanks if my solution helped u, for this problem I need detailed explanation of your problem. Regards, Deepak Rai On Tue, Nov 17, 2009 at 8:56 PM, vinod rao vinod.ma...@gmail.com wrote: Thanks Andy. Plz help me on other file about deleting columns On Tue, Nov 17, 2009 at 8:46 PM

Re: $$Excel-Macros$$ text and date in one cell

Hi, U can use =C3 TEXT(D3,mmm-yy). Regards, Deepak Rai On Thu, Nov 12, 2009 at 7:36 PM, Nayan K Lodaya nayan.k.lod...@jpmorgan.com wrote: =CONCATENATE(C3, ,TEXT(D3,mmm-yy)) Hope this helps *From:* Prashanth Banneni [mailto:praba...@gmail.com] *Sent:* 12 November 2009 18:37

Re: $$Excel-Macros$$ Leave Tracker

Hi Nayan, Please find the enclosed sample tracker. You can customize as per your need. Regards, Deepak Rai On Thu, Nov 12, 2009 at 7:56 PM, Nayan K Lodaya nayan.k.lod...@jpmorgan.com wrote: Hello Anyone , Please can you send / share leave tracker file you have for your organisation

$$Excel-Macros$$ Re: Excel VBA dynamically fill ComboBox?

Hi, I am attaching a file which is based on the same logic. U can use the same logic for your requirement. Hope this will help u. Regards, Deepak Rai On Tue, Nov 10, 2009 at 12:11 PM, RolfJ r...@pacificsound.us wrote: Assuming that your country column is column A, place the following code

$$Excel-Macros$$ Re: Conditional sum problem ( first ns and equal to certain values)

. Regards, Deepak On Sat, Nov 7, 2009 at 6:53 PM, Deepak Rai daksh1...@gmail.com wrote: Hi, Please find the enclosed attachment, hope this will help. Regards, Deepak On Fri, Nov 6, 2009 at 9:35 PM, Tony from Work xerses...@gmail.comwrote: Hello! Given 2 unsorted columns I'm trying

$$Excel-Macros$$ Re: Conditional sum problem ( first ns and equal to certain values)

to a certain label, for example: D 2 B 3 A 1 B 2 C 3 A -1 A 0 A 3 C 2 A 2 A 5 I have to find the sum only of the first 3 A that are greater than zero; in this case the result is 6. Many thanks for your time, Tony -- Thanks, Deepak Rai

$$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 vatspoojav...@gmail.comwrote: 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

$$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

$$Excel-Macros$$ Re: Need Urgent Help (While Statement)

Hi, Why don't you use Select Case instead of IF statement ? Regards, Deepak Rai On Mon, Oct 26, 2009 at 10:47 AM, Anish Shrivastava anish@gmail.comwrote: Hello Experts.. I m using While and Wend statement in my code and it has got more than 100 if conditions. when I run the macro

$$Excel-Macros$$ Re: Insert file path and name into cell

Hi Hemant, Nice logic. It will also be very helpful. Regards, Deepak Rai On Thu, Oct 22, 2009 at 7:41 PM, Deepak Rai daksh1...@gmail.com wrote: Hi JP, Please find the below VBA code for the solution of your problem. Hope this will help you. Private Sub Workbook_SheetSelectionChange

$$Excel-Macros$$ Need help on Concatenate Indirect combination

sheets with same logic . I need it in every sheet. If there is any other alternative or solution please help me. Regards, Deepak Rai --~--~-~--~~~---~--~~ -- Some important links

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

Hi Anil, Please find the attached sheet with answer of your query. Regards, Deepak Rai On Mon, Aug 10, 2009 at 12:07 PM, Sandeep sandymau...@gmail.com wrote: I Need to calculate the range as per the criteria mentioned in attached file please help me. -- Thanks, Deepak Rai

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar

On Tue, Aug 11, 2009 at 2:08 AM, Deepak Rai daksh1...@gmail.com wrote: Hi, In the Developer Tools click on More Controls then select Calender Control 12.0. Please follow the below steps to get the Calender Control: 1. Right Click on Menu Bar 2. Select Customize Quick Access Toolbar.. 3

$$Excel-Macros$$ Re: urgent - How to calculate sum of only positive numbers

Hi Anil, Use this formula for calculating the positive value only in a row: =SUMIF(B1:D1,0,B1:D1) Where B1 = 30 , C2= -20 D2 = 60. Hope this will help you. Regards, Deepak Rai From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ANIL

$$Excel-Macros$$ Re: how to hide #N/A

Hi Harris, You can also use =IFERROR(A1,0) where A1 = #N/A. Regards, Deepak Rai -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Andre Dreyer Sent: Friday, August 07, 2009 1:48 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel