$$Excel-Macros$$ Re: How to findout Duplicate items

Use below code. Sub DupFinder() Dim r As Range, t As Range Cells(1, ActiveCell.Column).Select Range(Selection, Selection.End(xlDown)).Select Set t = Selection For Each r In t v = r.Value If Application.WorksheetFunction.CountIf(t, v) > 1 Then r.Interior.ColorIndex = 3 End If Next End Sub Select

$$Excel-Macros$$ Find Date Macro

Hi, I am trying to create a macro that searches for a specific date in a sheet with many dates. I would like a textbox to come up and ask what date to look for. After inserting the date in the text box up I get an error. Do you know what I need to change to get it to look up the date that was inpu

$$Excel-Macros$$ Date search for inputbox

Hi, I have a sheet with many dates and I am trying to find a specific date after which it should prompt information to be but next to the date. I run a macro that brings up a inputbox and ask for the date but then it is unable to find the specific date. I am not sure what I need to change below is

$$Excel-Macros$$ Autofilters in VBA

I want that i write a code which filters the data say A on field target_group. Ex- i give the criteria in code as target_group='PSY' and i get that filtered list say B in another worksheet or a temperory memory. After that I'll again filtered the list B on the field date ex: (date>=7/1/2006 and da

$$Excel-Macros$$ To get information from a specic cells base don multiple conditions

In the below data my aim is to get information from a specific cell based on a specific conditions. In the data sheet you can see tables for different regions say atlanta and also different product names under them and their shares in different months Ex:Suppose i want to know the share% of prod

$$Excel-Macros$$ Re: Number ranges in a cell

Your question is not quite clear. Make it more understandable. Akhilesh On Thu, Oct 30, 2008 at 8:28 AM, Amanda <[EMAIL PROTECTED]> wrote: > > I have a spreadsheet I would like to upload with the column in > question - how do I upload it? > > > --~--~-~--~~~---~--~--

$$Excel-Macros$$ Re: Concatenate

=A1&B1&TEXT(C1,"HH:MM:SS") Regards Harish Upadhyay On 10/29/08, vinu <[EMAIL PROTECTED]> wrote: > > > How to concatenate the below one. > > A1=India > B1=Bangalore > C1=12:10Am > > Thanks in advance. > Vinu. > > > > --~--~-~--~~~---~--~~ Visit the blog to download

$$Excel-Macros$$ How to findout Duplicate items

Hello All, Could you pls help me out in the below issue. I have 50 amounts in a single column, those are repeated amounts. I would like to know which are all repeated amounts by highlighting or something like that. Thanks -- Vinu (¨`*.*´¨) Always `*.¸(¨`*.*´¨) Keep (¨`*.*´¨)¸.*´ Smiling! `*.¸

$$Excel-Macros$$ Re: how to activate double click

Thanks a lot!! On Oct 31, 1:03 am, "Sumeet Jain" <[EMAIL PROTECTED]> wrote: > Try going to Tools - Options - Edit. On left hand side under Settings, you > would see the option "Edit directly in cell". Enable it by putting a tick > mark and say ok. Now, you should be able to double click directly

$$Excel-Macros$$ Re: Concatenate

Thanks a lot!! On Oct 30, 8:26 pm, "Ajay Varshney" <[EMAIL PROTECTED]> wrote: > =A1&" "&B1&" "&TEXT(C1,"HH:MM AM/PM") > Use the above forlula > > > > On Thu, Oct 30, 2008 at 11:19 AM, vinu <[EMAIL PROTECTED]> wrote: > > > How to concatenate the below one. > > > A1=India > > B1=Bangalore > > C1=12

$$Excel-Macros$$ Re: How to hid formula in a cell or sheet

go to Format Cell ->Protection -> click on Hidden Check Box - > OK then Tools -> Protection -> Protect Sheet -> Enter Password Regards Harish Upadhyay On 10/29/08, vinu <[EMAIL PROTECTED]> wrote: > > > Hi All, > > Could you pls let me know how to hide and unhide only formula in a > particular