RE: $$Excel-Macros$$ Macros needed to run on data change event BUT if there's "na" value na changes should happen

Try this Code: Option Compare Text Public val As Variant Private Sub Worksheet_Change(ByVal Target As Range) If val <> "na" Then Target.Interior.ColorIndex = 6 End If End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error GoTo Err: val = Target.Value Err: End Sub -Ori

$$Excel-Macros$$ Macros needed to run on data change event BUT if there's "na" value na changes should happen

Hi Everybody, I need your smart help again. -- GOAL: I have data with different values and "na" spreaded on she

Re: $$Excel-Macros$$ Need to change Chart's Bar color based on value

http://akoul.blogspot.com/2011/05/color-chart-series-on-basis-of-valeus.html try this macro Sub format_ur_chart() Dim srs As Series For Each srs In Sheets(1).ChartObjects("Chart 2").Chart.SeriesCollection For i = LBound(srs.Values) To UBound(srs.Values) If srs.Values(i) < 0 Then srs.Points(i).I

$$Excel-Macros$$ Need to change Chart's Bar color based on value

Dear Members, Here with this mail I have attached excel sheet in which a simple bar chart prepared, but I won't be able to make bar color change automatically based on data value for that bar I want positive data value bar as blue and negative data value bar to be in red and this s

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Dear Subhash, Please try it... =VLOOKUP(--C5,Sheet3!$A$1:$D$403,4,FALSE) -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav wrote: > When I m trying to use to formula VLOOKUP against a

Re: $$Excel-Macros$$ copy cell value from clicked hyperlink

Hi Vickey, Hyperlink can never copy values from one place to another, hence given a two line code which will help you :) Let me know if this helps you. Regards, DILIPandey On 8/4/11, vickey wrote: > Hi, > > Thanks for the same,but my problem has not yet been solved... > > Please refer att

Re: $$Excel-Macros$$ Request for Directory Audit Macro

http://akoul.blogspot.com/2011/07/print-file-names-in-folder-to-excel-on.html http://akoul.blogspot.com/2011/06/rename-files-in-vba.html On Thu, Aug 18, 2011 at 5:27 AM, XLS S wrote: > Hey Crazybond, > > Please find the attachment ... > > On Thu, Aug 18, 2011 at 2:00 AM, crazybond wro

Re: $$Excel-Macros$$ Request for Directory Audit Macro

Look in the vba help index for DIR From: crazybond Sent: Wednesday, August 17, 2011 3:30 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Request for Directory Audit Macro Hi Experts, Can a vba code/macro be created/ is available in case one needs to do the audit on the directo

Re: $$Excel-Macros$$ Need a Formula or Macro

It would be very helpful if your data could result in an actual case with a real example. You ask to search for data that does NOT exist. -Original Message- From: Baby Patel Sent: Wednesday, August 17, 2011 8:08 AM To: excel-macros Subject: $$Excel-Macros$$ Need a Formula or Macro Hi

Re: $$Excel-Macros$$ Uniques Values

that's Great Haseeb. thnx On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan wrote: > Hi Sundarvelan, > > Since you are dealing with valid numbers use SMALL function. > > in G3 enter, > > =MIN(B:D) > > G4, copy down. > > =IFERROR(SMALL(B:D,COUNTIF(B:D,"<="&G3)+1),"") > > HTH > Haseeb > > For

Re: $$Excel-Macros$$ Uniques Values

Hi Sundarvelan, Since you are dealing with valid numbers use SMALL function. in G3 enter, =MIN(B:D) G4, copy down. =IFERROR(SMALL(B:D,COUNTIF(B:D,"<="&G3)+1),"") HTH Haseeb For free help visit; http://www.excelfox.com/forum/ -- --

Re: $$Excel-Macros$$ Need a Formula or Macro

I can have this done in 3 hours. Email me at excelvbasql@gmail if you want me to start. On Wed, Aug 17, 2011 at 8:08 AM, Baby Patel wrote: > Hi Guys, > > I need an urgent help . Attached is the excel file for your reference. > > Issue : I want the result in the F coulmn of Sheet1. the Sku #from

RE: $$Excel-Macros$$ From Word to Excel

You forgot the attachment ;-) Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Shrinivas Shevde Envoyé : mercredi 17 août 2011 11:04 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ From Word to Excel Dear Daniel

$$Excel-Macros$$ Need a Formula or Macro

Hi Guys, I need an urgent help . Attached is the excel file for your reference. Issue : I want the result in the F coulmn of Sheet1. the Sku #from Coulmn B of Sheet 1 will be searched in A column of sheet2. If the SKU was found then it will check the Currency and Margin (B & C column of Sheet 1)

Re: $$Excel-Macros$$ Uniques Values

Hi Sundarvelan, In 2007 or 2010 Excel ...Try Advanced filter and use option Unique records... *Best Regards,* *Venkat * *Chennai* * * On Wed, Aug 17, 2011 at 4:20 PM, Sundarvelan N wrote: > Hi Freinds, > > Please help me to get the uniques values. > Thanks > N.Sundarvelan > 9600160150 > > -

RE: $$Excel-Macros$$ Workbooks Consolidation Macro

Try this Code : Sub Compile() On Error GoTo Err_Clear: Application.ScreenUpdating = False Application.DisplayAlerts = False Dim Fso As New Scripting.FileSystemObject Dim Path As String Application.FileDialog(msoFileDialogFolderPicker).Title = "Select Folder to Pick Downloaded Bills" A

Re: $$Excel-Macros$$ Workbooks Consolidation Macro

For a simple solution, simply record a macro while doing it manually. From: Satish Bandaru Sent: Wednesday, August 17, 2011 1:06 AM To: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro hi experts please help me.plz find the atachment thanks in adv

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

Use Conditional Formatting formula = =$A2+1>=COLUMN() set patterns to color desired>OK>and copy format Or Simple, just change from drawing a line to coloring the cells. Works when you change the cell. You MUST save the file as an xlsM file for macros and enable macros. Private Sub Worksheet_Chan

Re: $$Excel-Macros$$ UNIQUE values in Array

Dear Yogi, Please see attached sheet for Reverse Vlookup Example =VLOOKUP(G4,CHOOSE({1,2},$B$2:$B$8,$A$2:$A$8),2,0) =LOOKUP(2,1/(B2:B8=G7),A2:A8) -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Aug 17, 2011 at 12:03 PM, y

Re: $$Excel-Macros$$ Uniques Values

Hey Sundarvelan, please try to use multiple range pivot. On Wed, Aug 17, 2011 at 4:20 PM, Sundarvelan N wrote: > Hi Freinds, > > Please help me to get the uniques values. > Thanks > N.Sundarvelan > 9600160150 > > -- > -

Re: $$Excel-Macros$$ UNIQUE values in Array

Hey Yogi, please find the attachment.,... there is a many way to put reverse vlookup.. like..IF count with choose functions,index with match function,lookup function,SUMPRODUCT function On Wed, Aug 17, 2011 at 12:03 PM, yogi yogi123 wrote: > > what is reverse vlookup.can u give one example.

Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

Hey Satish, please see the below link and follow instructions http://support.microsoft.com/kb/214081 On Wed, Aug 17, 2011 at 11:36 AM, Satish Bandaru wrote: > hi experts > please help me.plz find the atachment > thanks in advance > > -- >

Re: FW: $$Excel-Macros$$ Update Data source range & converting "0" to "-"

Hey amit, can you share the example sheet. On Wed, Aug 17, 2011 at 11:00 AM, Amit Desai (MERU) wrote: > Thanks, but this did not worked..I have updated few data in sheet1, after > pressing cltr+shift+S, selected the entire range, than given the name of > sheets where we have Pivots. > > Best Reg

$$Excel-Macros$$ Uniques Values

Hi Freinds, Please help me to get the uniques values. Thanks N.Sundarvelan 9600160150 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

RE: $$Excel-Macros$$ UNIQUE values in Array

HI I think you are talking about Vlookup which can pick the value from left side , You can use this code for that Purpose : Sub VlookupByCodes() Dim ResultRange As Range Dim SearchRange As Range Dim ColNum As Integer Dim LookUpValue As Range Dim cellResult As Range Dim CellSearch As Rang

Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

hi experts please help me.plz find the atachment thanks in advance -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedI

RE: $$Excel-Macros$$ UDF Function for conditoin formetting

Try this If you have some Integer value in A Col. Private Sub Worksheet_Change(ByVal Target As Range) Target.Resize(1, Target.Value).Select Selection.Interior.ColorIndex = xlyellow End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error GoTo Err: Application.

Re: $$Excel-Macros$$ From Word to Excel

Dear Daniel Please Find attached word file Shrinivas On Tue, Aug 16, 2011 at 3:23 PM, Daniel wrote: > Can you please send the word document which provoked the error (the one > which is opened) ? apparently, there are some merged cells in it. > > ** ** > > Regards. > > ** ** > > Daniel**

RE: $$Excel-Macros$$ Update Data source range & converting "0" to "-"

I will Suggest you to make table (by pressing CTRL+T or CTRL+ L) of your source data before making pivot table , because when you will update data in that table and will press Refresh All , Pivot cache of all Pivot table always will refresh with all data in that table . -Original Message-

RE: $$Excel-Macros$$ User Defined formula in Excel

Try this Function Result(a as double,b as double, x as double) as double Result = (a*x)+ b End Function Once you define any Public Function in VBA those are available to Use on WOrkhseet , if you want to make this Function for application You can make add-ins or you can also save this function

Re: $$Excel-Macros$$ Notes : Help

Hello Ashish, Could u pls help on this error. Thanks! On Tue, Aug 16, 2011 at 11:25 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi Ashish, > > Thanks for the reply and patience. I have attached the excel file. I am > facing below errors when I run the macro. > > 1. I am getting e