$$Excel-Macros$$ Re: I need your help for the below issue.

2008-11-17 Thread vinu
Thanks Dave.. On Nov 12, 9:01 am, Dave Bonallack <[EMAIL PROTECTED]> wrote: > Hi, > Please see attached. > Regards - Dave. > > Date: Tue, 11 Nov 2008 12:22:33 +0530From: [EMAIL PROTECTED]: [EMAIL > PROTECTED]: $$Excel-Macros$$ I need your help for the below issue. > Hi all, > > I have explained

$$Excel-Macros$$ Re: What is array??

2008-11-17 Thread madhavi rohini
list of characters-array On 11/10/08, ram bhagath <[EMAIL PROTECTED]> wrote: > Hello all, > > Pls explain me what do mean by array in excel?? > > Thanks. > > > > > > > > > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-ma

$$Excel-Macros$$ Re: help needed regarding protecting excel files

2008-11-17 Thread Sunita Paudel
so kind of u Sharad .yeh if u can help me writing macro bt also the fact is m nt so familiar about macros and all. luking forward... On Sun, Nov 16, 2008 at 10:34 PM, Sharad Sharma <[EMAIL PROTECTED]>wrote: > Hi Suneeta, > > One way of protcting all xl files in a folder is to write a macr

$$Excel-Macros$$ Re: VLOOKUP with multiple dependents

2008-11-17 Thread Kamran Haider
I found only one way may it works for you .Please inform me if it solve your problem . Allah Hafiz ,Kamran Haider . Date: Sun, 16 Nov 2008 07:25:42 -0800From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: $$Excel-Macros$$ VLOOKUP with multiple dependents Hi All I have a little query regardin

$$Excel-Macros$$ Re: Formula required

2008-11-17 Thread Samir Agayev
Hi, If you had this "+" sign in every contact I would suggest Data>Text to Column wizard in Excel. But in this situation there is no automatic solution, i think. On Fri, Nov 14, 2008 at 2:51 PM, Ahmedhonest <[EMAIL PROTECTED]> wrote: > Dear All Chill out Greetings for the Day, > > Please see the

$$Excel-Macros$$ Re: Vlookup using multiple dependents (Ractified attachment)

2008-11-17 Thread konark vyas
Hi, Can be done in teh attached manner. Kindly see to the attachment. Regards, Konark Vyas On 11/16/08, Mahreen Ellahi <[EMAIL PROTECTED]> wrote: > > Hi All > > I have a little query regarding VLOOKUP Formula. I have been using it > depending on only one value. But now I want to use for two d

$$Excel-Macros$$ Re: VLOOKUP with multiple dependents

2008-11-17 Thread Ajit Navre
Hi, Pls see the attached file, the formulae you see in vlookup are the array formulae, you need to press CTRL+SHIFT+ENTER, instead of ENTER. If you want to know how the formulae work, please analyze those with Tools->Formula Auditing->Evaluate Formula. Regards ajit From: excel-m

$$Excel-Macros$$ Re: Vlookup using multiple dependents (Ractified attachment)

2008-11-17 Thread Bertone, Joseph S.
Here you go- Great step-by-step (it takes a moment or two to load...) http://blogs.msdn.com/excel/archive/2008/10/23/creating-a-master-detail-view-in-excel.aspx --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.

$$Excel-Macros$$ Re: Excel macro to iterate through rows collection - help please

2008-11-17 Thread Umed Singh
On 11/17/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I'm trying to create a macro that will do the following: > > When the user changes a value or values in column 'B', the macro will > iterate through all cells in columns 'C' to 'AO' but only in the same > row(s) that were changed in col

$$Excel-Macros$$ counting values

2008-11-17 Thread Dean
I have a list of building data. Within that data, there are 15 unique towns. I want to know how many times a building of a certain age group occurs in each town. There are 13 age groups. For example: Los Angeles - 1930 = 34,000 Santa Barbara - 1910 = 670 I have tried COUNTIF and other formulas,

$$Excel-Macros$$ Re: Excel macro to iterate through rows collection - help please

2008-11-17 Thread Tom Jeffries
The attached workbook does what you describe. It uses the Worksheet_Change event for Sheet 1 to capture changes in the target column. I substituted your "Gold" and "Silver" routines with a Print for testing. Uncomment and add whatever modification routine you need. If you have any questions let

$$Excel-Macros$$ Re: help needed regarding protecting excel files

2008-11-17 Thread saurabh jain bombay
Dear sharad, pls write such macro and mail it to us...we ll be grateful to u for this kind act. On 11/16/08, Sharad Sharma <[EMAIL PROTECTED]> wrote: > > Hi Suneeta, > > One way of protcting all xl files in a folder is to write a macro which > will individually set a password you specify for

$$Excel-Macros$$ Code Execution Has Been Interrupted Message

2008-11-17 Thread RSabbara
I have a macro that is running a stored procedure in the back ground and then going on to the next sheet and repeating. The macro works fine when step thru it, when I try and run it all together I get the message the the Code Execution has been interrupted, what am I doing wrong? --~--~-

$$Excel-Macros$$ Re: VLOOKUP with multiple dependents

2008-11-17 Thread Mahreen Ellahi
Hey thanks alot all of you guys .. all the sheets serves my purpose but Ajit I found ur solution more easy to use ... Kamran yous solution is abit complicated but still thanks for the solution I'll try to understand it ... Many thanks to all Regards Mahreen On Mon, Nov 17, 2008 at 12:36 AM,

$$Excel-Macros$$ Question

2008-11-17 Thread anasilvacastro
I am trying to input a loop While/Wend with If statements in between but it's showing me this code as an error: While InputSheet.Cells(iInputRow, 2) <> "" Does anyone have a clue why??? Help would be really appreciated!! Thanks a lot! Ana --~--~-~--~~~---~--~