$$Excel-Macros$$ Re: Macro to shade every other row

On 29 Jun., Kurt wrote: > I would like to highlight every other row in a range (A5:L40). > I've seen lots of macro samples to shade alternate rows, but can't get > any to work. > > For example, I found this one: > > Sub ShadeAlternateRows(rngTarget As Range, intColor As Integer, > lngStep As Long)

RE: $$Excel-Macros$$ Re: Required Formula

Hi Ahmed, Dilip, The problem is that the passport data in Col E of the 'Raw Data' sheet, is text, which isn't processed properly by SUMPRODUCT. The formulas in columns C:F are ok because they deal with numeric data, but the formulas in Column G will have to be replaced with something else, but

$$Excel-Macros$$ Macro to shade every other row

I'm rather new to Excel macros so any help is appreciated. I would like to highlight every other row in a range (A5:L40). I do not want to use conditional formatting, because I'm already using some in this range. So, I need to use a macro. I've seen lots of macro samples to shade alternate rows,

Re: $$Excel-Macros$$ Cell entry activates code to move line to diff tab

Thanks Paul, works like a charm!! David On Jun 25, 12:47 pm, Paul Schreiner wrote: > First of all, you're disabling the events, then never re-enabling them if the > value is not "yes". > I would first test to see if the changed cell is in the target range, > then test the value, THEN disable the

$$Excel-Macros$$ Re: Exrtact only numbers.

On 29 Giu, 12:05, lucky singh wrote: > Hi All, > > 1. I want to extract all the numbers > 2. I want to trim only the middle name > > Regards, > Jay S > >  Nadine.xls > 18KVisualizzaScarica can you give an example of the result you want Regards r --

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

Thx Gaurav, best regards, Dilipandey On 6/29/10, GAURAV JAIN wrote: > Hi Dilip, > > Discription is nice one. > > Cheers, > Gaurav Jain > > On Sat, Jun 26, 2010 at 11:15 PM, Dilip Pandey wrote: > >> Hi Swapnil, >> >> Below is a little explanation of the formula which I had used:- >> Hope you wil

$$Excel-Macros$$ Pls send examples of complex scenarios using sumproduct formula

Hi All, Can anybody please send me some examples of complex scenarios where the "sumproduct" formula has been used... Kind Regards, Satti Charvak -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ SumIF Sumproduct

I'm resending since I haven't gotten a response.  I'm hoping that it's because it may have gotten lost in the shuffle instead of there being no formula for what I want to do.  :)  Thanks. From: Nadine S To: excel-macros@googlegroups.com Sent: Mon, June 28, 20

Re: $$Excel-Macros$$ Trim first 8 characters off a cell

=MID(A1,9,99), assuming data is in cell A1 On 28 June 2010 19:55, Nadine S wrote: > I have a cell that I'd like to write a formula that returns all but the > first 8 characters. The cell's data can be any length. Thanks. > Nadine > > -- > >

$$Excel-Macros$$ Re: linking between autocad and excel file

Dear friends.., Still no reply... On Jun 23, 5:01 am, sudhir wrote: > Dear ,i m still  wating , there is no reply... > > On Jun 16, 9:36 pm, sudhir wrote: > > > hi friends, > > i have an unique and different problem..., i want to updates my > > excel file automatically as soo

$$Excel-Macros$$ Urgent formula required for Stock forecasting...

Hi All, urgent help required for forecasting stock in warehouse I have 8 products in my warehouse month on month the balance get deducted from it as and when it get sale However I need to know the available stock because it takes 50 days for my order Regards, Jay S 9987337414 -- -

Re: $$Excel-Macros$$ Re: Trim first 8 characters off a cell

Thank you for your solution.  I forgot to mention that some cells have something in the first few characters but not the rest so your solution sometimes results in a #VALUE error.  But if the data had been complete your solution would have worked for me.  Thanks for your help. Nadine ___

Re: $$Excel-Macros$$ Trim first 8 characters off a cell

Please send the example file. Thanks On Mon, Jun 28, 2010 at 10:25 PM, Nadine S wrote: > I have a cell that I'd like to write a formula that returns all but the > first 8 characters. The cell's data can be any length. Thanks. > Nadine > > -- > > ---

$$Excel-Macros$$ Exrtact only numbers.

Hi All, 1. I want to extract all the numbers 2. I want to trim only the middle name Regards, Jay S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

$$Excel-Macros$$ Excel

Dear Rahul, Can you please suggest me from where can i start learning Excel. I know the basic but i will be require more knowledge about it as i have to manage database as well. Please suggest something -- -- Some im

Re: $$Excel-Macros$$ Index match multiple

Hi Nadine, You can use the following formula to achieve your desired results:- =RIGHT(A1,IF(LEN(A1)>=8,LEN(A1)-8,0)) A sample file is also attached. Let me know if it helps you. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan

$$Excel-Macros$$ Re: SumIF Sumproduct

Kindly Share the Sample Sheet or data -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

Hi Dilip, Discription is nice one. Cheers, Gaurav Jain On Sat, Jun 26, 2010 at 11:15 PM, Dilip Pandey wrote: > Hi Swapnil, > > Below is a little explanation of the formula which I had used:- > Hope you will like it :) > > SUMPRODUCT(--($A$2:$A$483=A2),--(D2<$D$2:$D$483))+1 > > Above formula wi

$$Excel-Macros$$ Hide Coloum

Dear All, Is it possible to hide or unhide coloum or row with password without macro ? Thanks in Advance Sachin Shukla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and link