$$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.

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,

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

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-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,

$$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$$ 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

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 drag

$$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

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 naukrikuld...@gmail.comwrote: Dear Smitha, Please try this. (Sheet - 1 Sheet - 2) Regards, Kuldeep Singh