Re: $$Excel-Macros$$ How to count

dear Jayendra Pls find Attached Excel sheet for your ref Regards, Anil Gawli On Wed, Jul 25, 2012 at 10:10 AM, jayendra gaurav <> wrote: > > > > Team, > > How to count a cell based on color . > > file is attached for your's reference. > > > > > -- > J.Gaurav > Call-7838594954 > > -- > -- > FO

$$Excel-Macros$$ How to count

Team, How to count a cell based on color . file is attached for your's reference. -- J.Gaurav Call-7838594954 -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, C

Re: $$Excel-Macros$$ =IF(ISNUMBER($N3),INDEX(Master!$C:$C,N3,1),"")

As there is no data in column N of the Master sheet it is correctly returning the value of a blank cell which is 0 Regards David Grugeon On 24 July 2012 21:16, Zibraan wrote: > > >> Hi Team, >> >> Attached is the sheet but somehow its not working please help me >> regarding this... >> >> >> =IF

$$Excel-Macros$$ Re: transfer data automatically from journal sheet to ledger sheet

dsum formula can help with transactions related to ledger accounts -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick a

$$Excel-Macros$$ Re: Sum on 2 conditions(one in column one in row) to another cell

Hi, Have you thought about a pivot table before going coding a macro? cells(i,j) notation is about 2 dimensional array. If you want to work any values in there, you then need 2 loops. Now, you must know before hand which direction you need to take, are you going by rows or by columns? This is w

$$Excel-Macros$$ Re: Summary Sheet for all Employees

Have you tried managing your data with a pivot table? -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or m

Re: $$Excel-Macros$$ Re: ♍Ɣ President is Dead

Thanks man. He was elected in 2009 and was going to run for the 2nd term in Dec this year The vice president has just been sworn in as President Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: bpascal123 Sender: excel-macros@googlegroups.com Date: Tue, 2

$$Excel-Macros$$ Re: ♍Ɣ President is Dead

He was elected a year ago I think... Should he rest in peace! -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attent

$$Excel-Macros$$ ♍Ɣ President is Dead

Hi Guys Sorry this is not excel related but I needed to share this sad news that the President of the republic of Ghana ♍Ɣ country has just passed away this afternoon. Very sad day here. Sent from my BlackBerry® smartphone from Airtel Ghana -- -- FORUM RULES (986+ members already BANNED for

Re: $$Excel-Macros$$ save excel file to dbf III file in ms excel 2007

http://appscout.pcmag.com/your-questions/274021-excel-2007-can-t-save-as-dbf http://www.dbforums.com/microsoft-excel/1644233-excel-2007-add-save-dbf.html Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Govind Mori Sent: Tuesday, July 24, 2012 12:02 AM To: e

Re: $$Excel-Macros$$ Unable to open other Excel Files when using VBA form

Thanks Paul.. On 24 July 2012 21:38, Paul Schreiner wrote: > It's possible to do what you're asking, but it's not entirely necessary. > > There is a property called "modality". > What it basically refers to is the "mode" of the form you display. > > If the form is "modal" then it is tied to the

Re: $$Excel-Macros$$ back up - vba code

Sub Backup() 'kept in personal.xls & assigned to toolbar button On Error GoTo BackupFile MkDir CurDir & "\Backup" BackupFile: Here are some sub backup() With ActiveWorkbook MyWB = .Path & "\BACKUP\" & .Name .SaveCopyAs MyWB .Save End With End Sub Sub Backup1() FNAME = ActiveWorkbook

$$Excel-Macros$$ back up - vba code

Hi, I want to take backup of excel files periodically from some "specified path" and to "specified path", is there vba code for same. Thank you with regards Raghu -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pl

Re: $$Excel-Macros$$ Unable to open other Excel Files when using VBA form

It's possible to do what you're asking, but it's not entirely necessary. There is a property called "modality". What it basically refers to is the "mode" of the form you display. If the form is "modal" then it is tied to the Excel workbook and must be "dealt with" before anything Excel can proce

$$Excel-Macros$$ Unable to open other Excel Files when using VBA form

Hello Experts, We have created a VBA form. When we have the form open, we are unable to open any other Excel workbooks. Is there any way where we can enable multiple instances parallel to VBA form? Thank you in advance. Regards, Sharath -- -- FORUM RULES (986+ members already BANNED for vi

RE: $$Excel-Macros$$ Some Help

Solution Attached. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.m

$$Excel-Macros$$ Some Help

We want to use data validation... Please see the attachment Ashok Maroti -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

$$Excel-Macros$$ Re: Error Cleaning

This forum is a great place to learn, contributors I closely follow; Noorain, Asa, Don... On Monday, July 23, 2012 5:25:31 PM UTC+1, bpascal123 wrote: > > My Vba coding style is much inspired from Kris who from what I know, > posts here and on excelfox.com. If you can read his code, you should

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 6 Messages in 5 Topics

Hi, Need Help on Vlook Up in Excel 2007:- A Case is assigned to Person 1 (Column B) ...As a back up it is sometimes assigned to Person 2 (Column C) So if Case ID is in Column A , there is always name of Person in Column B. But only some cases are Assigned Person 2 in Column C. I want to lookup

$$Excel-Macros$$ Re: save excel file to dbf III file in ms excel 2007

On Tue, Jul 24, 2012 at 10:32 AM, Govind Mori wrote: > Dear expert > > > I was able to save excel data to DBF III file through save as option in > 97-2003 version, But in 2007 version how could i save excel data to DBF III > format as i am unable find save as to dbf option in 2007 version of Exce

Re: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates.

Dear Sanotsh, If you are using Excel 2007+, Attached sheet will also helpful for you. On Sat, Jul 21, 2012 at 4:38 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > > Hi Group, > > Need another help to count and sum data between two fixed dates. > > > Regards > Santosh > santoshkuma