$$Excel-Macros$$ MACRO VBA

hi I am starting with VBA and I'd like to create a macro that group every element of a column in another one by giving them a name. for instance: Year colour 2015 blue 2014 red 2003 yellow 2011 blue 2006 red If the year is 2015 or 2011 the given colour have to be

$$Excel-Macros$$ Pivot Table & Counting Colors w/conditional formatting

Anyone, I have a macro for counting colors that works on a normal worksheet. Problem: Clever created Pivot table with colors(Green, Red, Black..etc) that have numbers and text when you hover over the color Example: When cursor is over the Green value = 5(RED = 3) with text for the

$$Excel-Macros$$ Formula to take the value depends upon the two values

Repected Friends 1] Which formula I should use in E 13 --- I want the value depends upon Risk Group & Table As per B4 :D9 2] First I have to see the Group which I & II then Table A/B/C/D It will take depends upon this two criteria the value 3] I have to caluculate same way in more raws for

Re: $$Excel-Macros$$ MACRO VBA

Can you provide a sample file showing what you'd like?Are you looking for  Conditional Formatting for the column? Are you looking for a macro to highlight the date?or even a Change_Event macro to format the column?Paul- “Do all the good you can, By all the

Re: $$Excel-Macros$$ I need the formula to look up

What version of Windows are you using? In Windows 7, under Control Panel, there is a selection called"Region and Language" Selecting this allows you to change the display format for displaying dates and Times. Excel uses THIS setting to determine the default display for dates. For instance: if

Re: $$Excel-Macros$$ I need the formula to look up

Thanks Paul this is very helpful bless you. Can you help me how do I input the formula find_num in my function list. My excel doesn't recognize this On 5 Nov 2015 12:29, "Paul Schreiner" wrote: > What version of Windows are you using? > > In Windows 7, under Control

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

PFA On Thu, Nov 5, 2015 at 6:20 PM, big smile wrote: > Repected Friends 1] Which formula I should use in E 13 --- I want the > value depends upon Risk Group & Table As per B4 :D9 2] First I have to > see the Group which I & II then Table A/B/C/D It will take depends

Re: $$Excel-Macros$$ Fwd: Hide column as per option choice. - Attach Sheet..

The macro is in the VBA sheet module: Private Sub Worksheet_Change(ByVal Target As Range)     Dim ColNo     If ((Target.Address = "$C$3") _ Or (Target.Address = "$C$4")) Then     Hide_All     For ColNo = 4 To 10     If ((Sheets("Sheet 2").Cells(1, ColNo).Value =

Re: $$Excel-Macros$$ Help with Custom Vlookup

The speed of the worksheet is due to the fact that this UDF would execute for EACH row/cell where you've placed it.and update each time a sheet calculates(which occurs whenever you change a value) This function, run 50,000 times would indeed be slow! I'd suggest creating an alternative. Can I

Re: $$Excel-Macros$$ I need the formula to look up

can you send me your file so I can locate the issue?  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 long as ever you can.” - John Wesley

Re: $$Excel-Macros$$ Help with Custom Vlookup

Paul, You are a real genius. For around 42000 rows and 15000 look up values,* it took less than a minute.* Can't be better than that! Thank you so much. Best regards, Abhishek On Thu, Nov 5, 2015 at 9:53 PM, Paul Schreiner wrote: > Here's my solution. > > It'll be

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

It works on all criteria at my end. Please see that you are entering characters without any spaces (before or after). Try copy pasting the characters for understanding. On Thu, Nov 5, 2015 at 7:01 PM, big smile wrote: > If i put 1A instead of A then it works > > On Thu,

$$Excel-Macros$$ Client in Houston need ClickView Softwarer with Reporting Module

Hi Partner, Hope you are doing great …. Please send me resume to ma...@genuineitllc.com *Title : ClickView Softwarer* *Location :Houston, TX* *JD:-* · Creation of reports against the data that has been captured using ClickView software. · Must have knowledge about using

$$Excel-Macros$$ Urgent need SR.NET Developer(Client Server ) -Oakland, CA--LOCAL preferred

Hi Partner, Hope you are doing great …. Please send me resume to ma...@genuineitllc.com *Title : SR.NET Developer(Client Server)* *Location : Oakland, CA* *Duration : 6 months* Duties to Include: ü •Responsible for designing, programming and supporting various

$$Excel-Macros$$ Search Numbers or Characters in Excel (as in Word)

In MS Word, I can search for any letter using ^$ search for any number using ^# Is there an equivalent in Excel? e.g., if I want to find a number followed by a - (hyphen), is there a way to do this? Thank you. Kannan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ Re: Search Numbers or Characters in Excel (as in Word)

Try This -([0-9]) in find box check the wild card characters. Regards, Mandeep baluja On Friday, November 6, 2015 at 6:25:46 AM UTC+5:30, kannan ramanathan wrote: > > > > In MS Word, I can > search for any letter using ^$ > search for any number using ^# > Is there an equivalent in

Re: $$Excel-Macros$$ Help with Custom Vlookup

Hi Paul, Kindly post the answer for this Query So That we can learn that trick too. On Thursday, November 5, 2015 at 10:33:47 PM UTC+5:30, Abhi wrote: > > Paul, > > You are a real genius. > > For around 42000 rows and 15000 look up values,* it took less than a > minute.* > > Can't be better

$$Excel-Macros$$ Re: How to keep variables constant in a procedure

Kindly Provide the Full code for better understanding as this code doesn't seems to work as per your requirement . Difficult to figure Out where the Num Sell is using as input. Regards, Mandeep -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

$$Excel-Macros$$ Imm Need: Cronacle Architect -TX - 4 M

Hi, I have below requirement for one of our client, let me know if you are comfortable. *Job Title: Cronacle Architect* *Location: Houston TX* *Duration:4 Months* *Job Description:* · Technical skills, Communication and Business knowledge (preferred) Senior Functional

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

Thanks a lot But if i put Table A then it shows 0 only. For Table A -- Both Risk Group I /II not work.. On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain wrote: > PFA > > On Thu, Nov 5, 2015 at 6:20 PM, big smile wrote: > >> Repected Friends 1]

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

If i put 1A instead of A then it works On Thu, Nov 5, 2015 at 6:55 PM, big smile wrote: > Thanks a lot > > But if i put Table A then it shows 0 only. For Table A -- Both Risk Group > I /II not work.. > > On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain

Re: $$Excel-Macros$$ I need the formula to look up

Did you open the file I attached?(here it is again) The find_Num function is in Module1 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