Re: $$Excel-Macros$$ Excel-Macro-VBA Code

Hi Paul, Thanks for giving me the clue by "DateDiff". Till ur reply i dont know "DateDiff" method since im a leaner it helped to find the solution below is my solution for my requirement. Dim b As Variant Dim d1 As Date Dim d2 As Long d1 = "01-jan-2007" L1: b = ActiveCell.Value

Re: $$Excel-Macros$$ MCA certification help

Dear alok In my knowledge Microsoft not provide any MCA certification by microsoft Following is the list of certification... (1)MCTS:- Microsoft Certified Technology Specialist (MCTS) certifications enable professionals to target specific technologies and to distinguish themselves by demonstratin

$$Excel-Macros$$ Help with Conditionally Formatting

Hi, I need help with conditional formatting. I have a conditional formatting inserted on a sheet which requires a value to be either Yes or No to be updated in the cells. What i want to do is to pop up a message when a user saves the sheet without entering the values Yes or No in the required cell

$$Excel-Macros$$ MCA certification help

require guidance regarding MCA certification by microsoft. Specifically for EXCEL ( 77-602). -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excelda

Re: $$Excel-Macros$$ A Macro that can compare 2 or more then that Excel files

HI Guys Any updates on this ! On 1/28/10, maulik desai wrote: > > Hi, > > I want a macro which can help to compare two or more then two excel sheet > > By row wise > or by column wise or > complete sheet > > or should have options to select the mode like said in above lines > or can more th

$$Excel-Macros$$ Combining data from diff sheets to one mastersheet

Hi Gurus, I am looking for a macro sheet which can help me to create one database from diff excel workbooks Exp: I am having 5 workbooks (Mumbai,delhi,Pune,kolkatta, Surat) Each workbook has two worksheets (sheet1 & sheet2) All 5 workbooks are updated on a daily basis Now what i want is that i

$$Excel-Macros$$ Export data to Outlook Express

Hi, can some one help me, I need a macro which will send selected data from MS-Excel to Outlook. When macro is run pre decided cells should export to outlook. please help. Thank You Mayank -- -- Some important lin

$$Excel-Macros$$ SAS

Good evening All, I want to be an MIS analyst do i need to learn SAS programming. or will it be ok to learn advance excel, vba and macros. Please suggest. Sunil -- -- Some important links for excel users: 1. Follow

$$Excel-Macros$$ Need VBA code

Hi, I am good in excel. But i want to learn vba coding. please provide any vba coding related books. Thanking you all. Regards, Naresh V -- -- Some important links for excel users: 1. Follow us on TWITTER for t

$$Excel-Macros$$ Consolidating Unequal Lists

Hello, I have 2 lists of data in different worksheets of the same workbook similar to below: ProductCity Apples London Oranges Birmingham Pears Manchester I want to create 1 list (2 columns) in 1 worksheet that looks like: Product

Re: $$Excel-Macros$$ Excel-Macro-VBA Code

"Please provide VBA Code"... for WHAT exactly? In your question: "deleted the complete rows":   use: Rows("4:4").EntireRow.Delete  or Range("A4").EntireRow.Delete or cells(4,1).EntireRow.Delete "if the cell contains dates before 1/1/2007" what cell? any cell in the row? the cell in column "a" ? y

RE: $$Excel-Macros$$ Urgent Help Required in a macro

You're welcome. Regards - Dave. Date: Wed, 21 Apr 2010 11:45:50 +0300 Subject: Re: $$Excel-Macros$$ Urgent Help Required in a macro From: chaudhry.zahid@gmail.com To: excel-macros@googlegroups.com Thanks a bundle Dave. This has expedited my work even more. :-) (P.S) Can anyone refer me

Re: $$Excel-Macros$$ Excel-Macro-VBA Code

Hi, Please see attached excel for solution. Regards, Swapnil. On Wed, Apr 21, 2010 at 1:57 PM, Sundarvelan N wrote: > Hi Group Friends, > > > Please help in this regard. I need to deleted the complete rows if the cell > contains dates before 1/1/2007. > > Please provide VBA Code > > Thanks >

Re: $$Excel-Macros$$ Urgent Help Required in a macro

Thanks a bundle Dave. This has expedited my work even more. :-) (P.S) Can anyone refer me to a good course from where I can learn to write macros... On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack wrote: > Hi Zac, > Can I suggest a simpler approach? > Using the Ctrl key, select the 2 cel

$$Excel-Macros$$ Excel-Macro-VBA Code

Hi Group Friends, Please help in this regard. I need to deleted the complete rows if the cell contains dates before 1/1/2007. Please provide VBA Code Thanks N.Sundarvelan -- -- Some important links for excel users

Re: $$Excel-Macros$$ Sumproduct

Chk it,, Multiplies all the components of the two arrays and then adds the products — On Wed, Apr 21, 2010 at 10:10 AM, Jai wrote: > Dear All, Can you tell me that what is the work of sum product. > > -- > Thanks For Mail. > > -- > > -

Re: $$Excel-Macros$$ Sumproduct

Hi Jai, Sum product formula will give you sum of product of two columns or arrays. For ex: Check the following table : A B C Product QtyPrice / unit A 2 45 B 5 50 C 10 35 D