Re: $$Excel-Macros$$ Need some help in excel

Dear Mahesh, Thanks a lot for your reply :)[?] again Thanks a lot for solving my problem i have found my ans in this link Regards Abhishek On Wed, Feb 19, 2014 at 12:17 AM, Mahesh Parab wrote: > Hi Abhishek > > Try : UDF mention on below link > http://jonvonderheyden.net/excel/displayi

$$Excel-Macros$$ find and move the duplicate values in another sheet

Hello, I have a file with many values, distributed across multiple columns. >From sheet1 i want to find and move all the duplicate values in the sheet 2 and I need a macro,a code macro to work at the level of the sheets, Sheet1-Sheet2 I want to move cut/paste all values duplicates 2 times 3 ti

Re: $$Excel-Macros$$ Query for Macro

Try this Sub query() Dim rng As Range Dim cel As Range Set rng = Range("A1:a10") For Each cel In rng If cel = "Yes" Or cel = "No" Or cel = "Correct" Then cel.Offset(0, 1) = "Ok" End If Next cel End Sub Thanks & regards, www.MrExcel4U.com O

Re: $$Excel-Macros$$ Date of Retirement.

thanks its working fine On Tuesday, February 18, 2014 9:59:44 PM UTC+5:30, Mahesh wrote: > > Hi Prabhakar > > perhaps you can use, > =DATE(YEAR(H2)+60,MONTH(H2),DAY(H2)) > > Regards > Mahesh > > > On Tue, Feb 18, 2014 at 3:54 PM, Ashish Bhalara > > > wrote: > >> Dear Prabhakar, see the attached

$$Excel-Macros$$ Query for Macro

Dear All, I have made one macro for search word in column like "NO" "YES" "Correct" if this words are in cell then write the "OK" in next cell . I have query that I have used elseif many time. Is there any other way in which i can write macro in one line for example if A1 contain words like "NO",Y