RE: $$Excel-Macros$$ Successfully passed the microsoft digital certification course.

Please provide more details of the certification; 1) From where did you gave exam; 2) What books/materials have you referred, 3) How much is the cost? 4) How much time does it take to complete the certification. Best Regards, Amit Desai +91 98672 32534 From: excel-macros@

Re: $$Excel-Macros$$ Certification

I think not if anyone know send the link here sent from my smartphone On Jan 31, 2013 8:28 PM, "Manjunath Narayanappa" < manjunath.narayana...@aon.co.uk> wrote: > Dear Team, > > > > Is there any online excel exam to get certified. > > > > Thanks > > Manjunath > > -- >

$$Excel-Macros$$

Hi All, I need a macro for the attached file what exactly is to do, merge and center all the cells which are same macro should work on selected cells only and not on complete sheet. Thanx for ur kind help to uplift all us on same platform! Regards, Deepak -- Join official Facebook page of thi

$$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

database.xlsx Hi, Attached is the excel, for which I need some help. I want to paste data from one sheet to another sheet in a different view. I need this to be coded in vba as this is just a sample and my file is much larger th

Re: $$Excel-Macros$$ Certification

There are Microsoft office specialist exams in each product in office. You can just do the excel one. It is not an online exam but is conducted in various centres. See the Microsoft website for details. Regards David Grugeon On 1 February 2013 00:58, Manjunath Narayanappa < manjunath.narayana

Re: $$Excel-Macros$$ How to assign date to a variable in a cell

Hi Santhosh the Where expression is not an assignment expression, nore is it a cell formula. It is a filter clause from a sql statement or other database command. If you want the current date in a cell the formula is =Today() If you are running a VBA procedure and you want to put today's date i

$$Excel-Macros$$ How to assign date to a variable in a cell

Hi, I have the value as below in one cell which should assign the Today's date to particular value WHERE( ImportDate= Today()) How to assign today's date to the variable above? Thanks, Santhosh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RU

Re: $$Excel-Macros$$ Macro to Insert Rows Based on a Cell Value and put in the Value against each row.

*Try this code* Sub SJ() Application.DisplayAlerts = False Dim i As Long, j As Long On Error Resume Next Sheets("Output").Delete Sheets.Add(After:=Sheets(Sheets.Count)).Name = "Output" On Error GoTo 0 For i = 2 To Sheets("before").Range("a65356").End(xlUp).Row

Re: $$Excel-Macros$$ Blank out corresponding column if multiple criteria found

try this Sub Blankitout() Dim lastrow As Integer, i As Integer, j As Integer Dim conds() ' ADD CONDITIONS HERE conds = Array("AL", "AK", "NS", "SJ") lastrow = Range("A" & Rows.Count).End(xlUp).Row For i = 1 To lastrow For j = LBound(conds) To UBound(conds) If Range("A" & i) = cond

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

Hi Aplesh PFA Regards Prince On Thursday, January 31, 2013 6:50:02 PM UTC+5:30, pesh wrote: > > Dear Anil, > > Thank you for your response. However, I have not received the file you > refer to. Only I see the sample file I had submitted originally. > Could you please resend? > > Thank you. > Al

$$Excel-Macros$$ Blank out corresponding column if multiple criteria found

Hello All, I have code that will look through column A for the string AL and if it if found will blank out column B if there is a value in the cell in the same row as column A. What I have been trying to do is perform same procedure but is there a way I can use multiple states, e.g. Look to

Re: $$Excel-Macros$$ Certification

nobody will see excel certificate i think On Thu, Jan 31, 2013 at 7:58 AM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Team, > > > > Is there any online excel exam to get certified. > > > > Thanks > > Manjunath > > -- > > PLEASE CONSIDER THE

$$Excel-Macros$$ Certification

Dear Team, Is there any online excel exam to get certified. Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limit

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

Dear Anil, Thank you for your response. However, I have not received the file you refer to. Only I see the sample file I had submitted originally. Could you please resend? Thank you. Alpesh On Thu, Jan 31, 2013 at 2:25 AM, अनिल नारायण गवली wrote: > Dear Alpeshah, > > Pl find attached Sheet for

$$Excel-Macros$$ Macro to create Template and apply protection

Hello Experts, in the attached workbook, i have two sheets ie template and setup. On the "setup" sheet, when you enter a text in column B, and click create template, the macro for that button will always pick the last text in column B and create a template using the last text entered as the sheetn

$$Excel-Macros$$ Data extract from website & update Automatically

Hi All Experts, Can anybody tell me any website (Example: Nseindia.com) page Data extract in excel as it same view format (at least data extract that’s sufficient) & update it when refresh from external data link toolbar. If I refresh Sheet then automatically Datasheet refresh That is possible in

$$Excel-Macros$$ Re: How to order data in rows into distinct column sets

Hi Alpesh, May be if this can help you. Sub TransposeData() Dim rngdata As Range With ThisWorkbook.Worksheets("Sheet3") Set rngdata = .Range("A1").CurrentRegion rngdata.Copy ThisWorkbook.Worksheets("sheet4").Range("A1").PasteSpecial Paste:=xlPasteAll, Operatio