Re: $$Excel-Macros$$ please add me

Most welcome *Antham *in Excel Macro Groups. You can post your excel macro queries or solve queries of world wide users. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 9, 2012 at 3:26 PM, An Tham wrote: > Dear Sir, > I would like join e

$$Excel-Macros$$ create a multiple workbook - Reg

dear excel members, I want create a multiple workbooks based on conditions column a , different sheets i want stored nos 1 , 2 ,3 Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- FORUM RULES (986+ members already BANNED for violati

Re: $$Excel-Macros$$ create a multiple workbook - Reg

Dear Mothilal, Please explain more, I think you want to create different workbook based on a columns unique No. or other. On Mon, Jul 9, 2012 at 3:48 PM, jmothilal wrote: > dear excel members, > > > I want create a multiple workbooks based on conditions column a , > different sheets i want st

Re: $$Excel-Macros$$ create a multiple workbook - Reg

yes, nos all 1 is one worksheets, nos 2 all another sheets . .. On Mon, Jul 9, 2012 at 3:51 PM, NOORAIN ANSARI wrote: > Dear Mothilal, > > Please explain more, > I think you want to create different workbook based on a columns unique No. > or other. > > > On Mon, Jul 9, 2012 at 3:48 PM

Re: $$Excel-Macros$$ create a multiple workbook - Reg

i want create a based on the column a unique nos only On Mon, Jul 9, 2012 at 3:51 PM, NOORAIN ANSARI wrote: > Dear Mothilal, > > Please explain more, > I think you want to create different workbook based on a columns unique No. > or other. > > > On Mon, Jul 9, 2012 at 3:48 PM, jmothilal wro

Re: $$Excel-Macros$$ create a multiple workbook - Reg

You really should not need to create separate sheets when you can simply use data>filter>autofilter>filter col A for the desired. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: jmothilal Sent: Monday, July 09, 2012 5:18 AM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Re: Nokia PC Suit API !!

Thanks Bajrang It works J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: 09 July 2012 10:35 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Nokia PC Suit API !!

$$Excel-Macros$$ Re: Vlookup or Match formula - regionwise

Hi Sreejit, Please see the attachment i hope this will help you. regards prince 9891472849 On Sunday, 8 July 2012 20:55:24 UTC+5:30, Sreejith K. V wrote: > > Hi Team, > > Can someone please help me with the attached excel sheet. > > Regards > Sreejith > -- FORUM RULES (986+ members already

Re: $$Excel-Macros$$ Unique Name Query

Hi Deba, I found your solution working fine. regards prince 9891472849 On Saturday, 7 July 2012 12:00:10 UTC+5:30, Bhaity wrote: > > Hi Karan, > > PFA... > > Use this formula for unique extraction: > > =IFERROR(INDEX($A$1:$A$11,MATCH(0,COUNTIF($C$2:C2,$A$1:$A$11),0)),"") > > And for counti

$$Excel-Macros$$ Re: Rajan Verma - Most helpful Member(June​'12)

Congrats rajan. regards prince dubey On Wednesday, 4 July 2012 21:46:48 UTC+5:30, Ayush Jain wrote: > > Hello Everyone, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > June'2012. This is third time in row. :) > He has posted 149 posts in June 2012 and helped many p

Re: $$Excel-Macros$$ macros code help

Dear Vijay, Try it Range("A1").Select Set Data = Range(Selection, Selection.End(xlToRight)) Data.Select See attached sheet.. On Mon, Jul 9, 2012 at 10:19 PM, vijayajith VA wrote: > Hi All, > > Set data = Activewkst.Range(Cells(1, 1), Cells(2, data_input_Last_col)) > > > Here *data_Input_last_

RE: $$Excel-Macros$$ need of free e-book

Thanks boss you r great !! From: rajanverma1...@gmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ need of free e-book Date: Thu, 28 Jun 2012 18:42:06 +0530 Download from here http://www.2shared.com/complete/CMFN-eEp/Building_Accounting_Systems_Us.html

RE: $$Excel-Macros$$ need of free e-book

But i still could not be able to read this file because as i open the file amazon open in browser window whereas in pdf shows nothing . From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ need of free e-book Date: Tue, 10 Jul 2012 00:54:11 +05

$$Excel-Macros$$ Re: Unique Name Query

Hello Karan, In C2, with CTRL+SHIFT+ENTER, and copy down. =IFERROR(INDEX(A$2:A$100,MATCH(1,IF(A$2:A$100<>"",IF(ISNA(MATCH(A$2:A$100,C$1:C1,0)),1)),0)),"") If you need Unique Names in *Ascending Order*, In C2, with CTRL+SHIFT+ENTER, and copy down. =IFERROR(INDEX(A$2:A$100,MATCH(0,IF(A$2:A$100<>

Re: $$Excel-Macros$$ Re: Unique Name Query

That was a very useful excel function.  Thanks for sharing this.    Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: Haseeb A To: excel-macros@googlegroups.com Sent: Tuesday, 10 July 2012 4:37 AM Subject: $$Excel

$$Excel-Macros$$ no of sheets in a workbook

Dear Sir, Do we have a shortcut to know the number and name of the sheets in a workbook and also list them in sequence. Amit Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, For

Re: $$Excel-Macros$$ no of sheets in a workbook

Dear Amit, Please use this shortcut key: - Alt+A+A Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 10, 2012 at 11:11 AM, amitkmr wrote:

Re: $$Excel-Macros$$ no of sheets in a workbook

Dear Amit, Try it.. *Application.OnKey "%{+}", "short_key" * Sub short_key() MsgBox Sheets.Count End Sub You can change combination % for Alt (^) for Ctrl (+) for Shift -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 10, 2012 at 1