$$Excel-Macros$$ conditional formatting

Hi, If one cell contain a specific Text "On", the whole row from A2 to D2 should be filled with yellow colour. How can it be? -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Run-time error popup message

Hi Lalit, Please see my previous mail attachment of run time error popup message file and in this i have facing some daily basis macro timings problems. You have resolved the query but now i can't able to macro timings properly. please do the needful and i sent too many mails to the group no buddy

$$Excel-Macros$$ conditional formatting

Hi, If one cell contain a specific Text "On", the whole row from A2 to D2 should be filled with yellow colour. How can it be? -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ conditional formatting

Hi, If one cell value is a specific text like "On", the whole row from A2 to D2 should be filled with yellow colour. How can it be? On Thu, Jul 26, 2012 at 12:25 PM, Kuldeep Singh wrote: > > Dear Smitha, > > Please try this. (Sheet - 1 & Sheet - 2) > > Regards, > Kuldeep Singh > Phone.: +91-120-4

$$Excel-Macros$$ Need help on macro Re-organize data from a 2 dimensional grid to a single dimensional grid

Hi Experts I need macro to do the following thing, a. Re-organize data from a 2 dimensional grid to a single dimensional grid - see example below source data: Item Sales MH, GJ, KA A 1 23 B 4 56 C 7 89 reformat to the foll

Re: $$Excel-Macros$$ UDF - to sum range

Hi Experts, I have done this using Indirect(), Can you please help with UDF. I waiting for your valuable reply Regards, Amol J On Sunday, August 19, 2012 2:46:36 PM UTC+5:30, Amol J wrote: > Hi All, > > Please help me with this problem. its related to range reference . When we > dra

$$Excel-Macros$$ PowerPivot in excel 2007

Dear Friends, Is it possible to add PowerPivot feature in Excel 2007? Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the

$$Excel-Macros$$ Re: Run time error "out of memory 7"

Hello, Give more details. At what stage, you are getting the error. When opening the file, When opening a particular form/ running a query / executing a report etc. Also provide The size of access file. Once thing you can try is to condense the access database using compact & repair database

$$Excel-Macros$$ How to learn Excel Macro

Dear Friends, I'm new to excel macros, can anyone send me the excel macro guide for beginners with examples. Thanks Rajasekaran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accur

RE: $$Excel-Macros$$ Business analyst

Check the below link, the same covers latest book BABOK version 2 (Business Analyst Body of Knowledge) by IIBA. http://www.babokonline.org/ Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 18 August 2012 09:08 To: excel-ma

Re: $$Excel-Macros$$ UDF - to sum range

Hi All, Please help me with this problem. its related to range reference . When we drag any formula into columns. it adjust cell accordingly and increase the columns. but what i want is If i drag sum udf into columns it will increase columns as well as rows On Saturday, August 18, 2012 9:

RE: $$Excel-Macros$$ Query - AutoNumber

Hi Hemant, Here is a workaround. Please change it accordingly Sub GenerateAutoNumber() Dim lngPreviousNo as long lngpreviousNo = 1 lngpreviousNo = lngpreviousNo + 1 MsgBox lngpreviousNo End sub Regards, Lal

$$Excel-Macros$$ Need help on a formula

Dear Experts, I am stuck up which my work in an excel. I need a help on a formula in the attached sheet. I have given a complete details & explanation in the attached sheet. Need your help to come out of this situation. For any question or details please revert back. Thanks in advance. Regard