Re: $$Excel-Macros$$ Login & password in excel

Dear Vabs There are problem of password,it show wrong password.Pls can you see sheet. Regards Amar On Fri, Apr 25, 2014 at 9:23 PM, Vabs wrote: > Thanks!!! > > PFA > > Cheers!! > > > On Fri, Apr 25, 2014 at 7:06 PM, amar takale wrote: >> >> Dear Vaibhav >> >> Mind Freaking !!! Awesome!!! >> >>

Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

It works perfectly in my workbook. Row 6 is unhighlighted in sheet1 and 6 and 13 are unhighlighted in sheet2.   better check to make sure the macro was copied correctly, here it is from my workbook:   Option Explicit Public Dict_Data1, Dict_Data2 Sub Compare()     Dim Sht1, Sht2     Dim nRows, r, s

Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

Must be something I changed when I went to test my large sample.   I'll take a look at it. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As

Re: $$Excel-Macros$$ Login & password in excel

Dear Vaibhav Mind Freaking !!! Awesome!!! Perfect,You are done it……… I am really thankful for its wonderful Coding. One thing small issue that if I login sheet & save it & close sheet.When again open that sheet then Login & Password (AMAR & AMAR) show everyone who open this sheet.I think it wil

$$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

> > Hi Paul, > Thank you so much for your time and effort into problem. The code is very well structured, but I am sorry to inform, that code highlighted every row in sheet1, as the correct output would be highlighting every row in sheet1 besides row 6, as its not the same as sheet2 row6.

Re: $$Excel-Macros$$ find duplicate rows of data between sheets macro

I threw this together and tested it. it works on your sample data.   I then tested it on a sample file of 135000 records.   it took about 6 minutes to do 135,000 records.   I tested a variation that puts a "flag" into column J, then, once complete, filters on this column and highlights the rows.  

Re: $$Excel-Macros$$ Time Stamp Limited to Target Cells Within a Specic Range

Try testing to see if the selected target "intersects" the specified range:   If (Not Intersect(Range(Target.Address), Range("D5:G10")) Is Nothing) Then Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places y

Re: $$Excel-Macros$$ Time Stamp Limited to Target Cells Within a Specic Range

Hi PFA Cheers! On Fri, Apr 25, 2014 at 4:47 PM, Mark Lefcowitz wrote: > I want to be able to point-and-click to individual cells within a > specified worksheet range and inset a now() timestamp: > > Option Explicit > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > If Target.

Re: $$Excel-Macros$$ Re: Rank formula_complex process

Thanks very much madhu kumarji. On Wed, Apr 23, 2014 at 7:27 PM, madhu kumar wrote: > in Formula 5 = Start row number & 36 = last row number > > > > On Wed, Apr 23, 2014 at 6:37 PM, amar takale wrote: >> >> Dear Muddan >> >> Excellent ,mind blowing formula thats great work.Sorry for

$$Excel-Macros$$ Time Stamp Limited to Target Cells Within a Specic Range

I want to be able to point-and-click to individual cells within a specified worksheet range and inset a now() timestamp: Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count <> 1 Then Exit Sub Application.EnableEvents = False If Target = "

$$Excel-Macros$$ find duplicate rows of data between sheets macro

I have a large amount of data in two worksheet. I would like the macro, to search the two sheets and look for duplicate rows of data by comparing columns A, B, C, D, F, H, I between the two worksheets. Show the results by highlighting the duplicate rows in both sheets. I have attached a sample