Re: $$Excel-Macros$$ Which cell color and font color combination is suitable to show negative value.

Dear Waseem, Mostly font color should be black and cell color should be red for negative. positive:- font color should be black and cell color should be gree. Warm Regards, Gawli Anil. Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Aug 22, 201

$$Excel-Macros$$ Which cell color and font color combination is suitable to show negative value.

Dear Experts, Please suggest me. I have some negative and some positive values in a range. please tell me which font color and cell fill color combination is suitable to show negative values in that range. Red is use to show negative values, But I also want to know that cell's font color and fi

Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

Dear svenyarl, Pls share a worksheet with us. Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 8:13 PM, wrote: > I sample of the file I receive is as follows: > > 25727861 GM DLT 1 > 20130716 17091432

Re: $$Excel-Macros$$ Extract Names which are not common

Dear Santosh, Pl find attached herewith. Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Aug 22, 2013 at 4:55 AM, santosh subudhi wrote: > Hi Group, > > Is it possible to extract the data which are not common between t

Re: $$Excel-Macros$$ URGENT: Need help converting data in excel to a format attached text file.

Experts! I NEED YOU HELP BADLY. I HAVE A HUNDRED SHEETS I HAVE TO FORMAT. ANY HELP WILL BE APPRECIATED. i AM STILL A NOVICE IN VBA. THANKS IN ADVANCE On Wed, Aug 21, 2013 at 12:51 PM, Mog Godiva-Man wrote: > Hi Experts, > > I have some data in a spreadsheet that I will like to write to a *.t

$$Excel-Macros$$ Extract Names which are not common

Hi Group, Is it possible to extract the data which are not common between two coloums Attached is sample sheet with problem -- Regards Santosh santoshkumar.subu...@gmail.com -- 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) ! Join official Faceb

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

Hello Ravinder, I have installed the Add-In as per your instruction but unfortunately it only works on the *Active Sheet* and not on any other sheet. Please see if you could test your Add-in and fix the problem. Thanks for your time and help once again. Rashid Khan On Wednesday, August 21, 2013 9

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

Thanks De Premor, Your code works on any sheet. Regards Rashid Khan On Wednesday, August 21, 2013 3:22:48 AM UTC+4, De Premor wrote: > > try to replace current code with this > > Function LookForCode(Str As String, Data As Range, Colx As Integer, > Optional Delim As String = "]") > Dim Kode,

$$Excel-Macros$$ Re: clubbing 200 excel files

Try the following macro. Sub Macro1() For i = 2 To 200 Sheets(i).Select Range("A1:M99").Select Selection.Copy Sheets("Sheet1").Select Range("A" & CStr(i * 100)).Select ActiveSheet.Paste Next i End Sub On Saturday, August 17, 201

Re: $$Excel-Macros$$ Microsoft Excel based application that digitizes data from pictures

Yes Thanks guys. this was very helpful. On Wed, Aug 21, 2013 at 1:49 AM, Sam Mathai Chacko wrote: > Did you try http://www.ozgrid.com/Services/excel-charts-digitized.htm > On Aug 21, 2013 11:04 AM, "P.VIJAYKUMAR" wrote: > >> Respected Mog-Godiva, >> >> You can find the digitizer from the foll

Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

I sample of the file I receive is as follows: 25727861 GM DLT 1 20130716 17091432 GM NS 8 20121227 12527740 GM NS 8 20121221 10328906 GM NS 0 89018306 GM NS 12 12617309 GM RB 44 12365265 GM NS 10 20121026 12588318 GM RB 18 20120301 16631629 GM NS 11 the comparing file is on

Re: $$Excel-Macros$$ help needed urgent

thanks.. its done On Wed, Aug 21, 2013 at 4:05 PM, vba wrote: > See any hidden temp file is created or not. > > Try revoking shared access for particular folder n re share. > > Thanks > On 21 Aug 2013 17:26, "thameem" wrote: > >> Dear all, >> file is in server, but no one is using that file, b

Re: $$Excel-Macros$$ How to split Data based on last comm,

Another simple and short =TRIM(RIGHT(SUBSTITUTE(A2,",",REPT(" ",99)),99)) Pada 21/08/2013 16:12, Andrew Mangozho menulis: Another simpler but rather long method to get the same result On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi > wrote: Dear Rajkumar,

Re: $$Excel-Macros$$ help needed urgent

See any hidden temp file is created or not. Try revoking shared access for particular folder n re share. Thanks On 21 Aug 2013 17:26, "thameem" wrote: > Dear all, > file is in server, but no one is using that file, but stil showing file is > use.. please help me wat to do... > > -- > Are you =E

$$Excel-Macros$$ help needed urgent

Dear all, file is in server, but no one is using that file, but stil showing file is use.. please help me wat to do... -- 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) ! Join official Facebook page of this forum @ https://www.facebook.com/discusse

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

Dear Sir, I have querys 1) I have not used Dim Declaration and run below vba it working fine.. is there need to use Dim here? Dim x As ChartObject For Each x In ActiveSheet.ChartObjects x.Activate x.Chart.ChartTitle.Select Selection.Format.TextFrame2.TextRange.Font.Name = "Arial"

Re: $$Excel-Macros$$ How to split Data based on last comm,

Yes, thats great and faster. On Wed, Aug 21, 2013 at 2:36 AM, अनिल नारायण गवली wrote: > Dear Rajkumar, > > > U can use text to columns option . > click on comma checkbox and finish it. > > Warm Regads, > Gawli Anil > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software

Re: $$Excel-Macros$$ How to split Data based on last comm,

Dear Rajkumar, U can use text to columns option . click on comma checkbox and finish it. Warm Regads, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 2:42 PM, Andrew Mangozho wrote: > Another simpler but rather long

Re: $$Excel-Macros$$ Sum between two different data.

Dear Manok, Find attached herewith . Warm Regards, Gawli Anil. Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 2:30 PM, Manoj Kumar wrote: > > Please help me. > > I have a data like details mention below. > > xxx a b

Re: $$Excel-Macros$$ How to split Data based on last comm,

Another simpler but rather long method to get the same result On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi wrote: > Dear Rajkumar, > > Please find attached file with solution. > > Regards, > Waseem Saifi > > > On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar wrote: > >> Dear Group, >> >> We have lo

$$Excel-Macros$$ Sum between two different data.

Please help me. I have a data like details mention below. xxx a b c jan2 3 1 feb1 1 2 jan2 2 1 jan4 1 2 mar 1 3 1 I have a able xxx Jan Feb Mar a 81 1 b

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

Thanks a lot Sir...It working Fine On Wed, Aug 21, 2013 at 1:12 PM, xlstime wrote: > Try This > > Sub Chart_Titles() > > Dim ch As ChartObject > > For Each ch In ActiveSheet.ChartObjects > > ch.Activate > ch.Chart.ChartTitle.Select > Selection.Format.TextFrame2.TextRange.Font.

Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

pls give some example file so we can do somthing.. From: "sveny...@gmail.com" To: excel-macros@googlegroups.com Sent: Wednesday, August 21, 2013 7:09 AM Subject: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

Try This Sub Chart_Titles() Dim ch As ChartObject For Each ch In ActiveSheet.ChartObjects ch.Activate ch.Chart.ChartTitle.Select Selection.Format.TextFrame2.TextRange.Font.Name = "Arial" Selection.Format.TextFrame2.TextRange.Font.Size = 14 Next End Sub

Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?

Eugene, I need to display the images inline. Is there a way to do that with hyperlinks? On Wed, Aug 21, 2013 at 12:18 AM, Eugene Bernard wrote: > Instead of inserting the images, why can't you use hyperlinks !!!. > > Regards > Eugene > > > On Tue, Aug 20, 2013 at 3:39 AM, Chaya Cooper wrote: >