Re: $$Excel-Macros$$ Summary for a Weekly report-Urgent

dear team, Require you urgent help.. Thanks On Thu, Jan 12, 2012 at 12:16 PM, lucky singh wrote: > > Dear Team, > > Require a dashboard or a summary sheet for the attached weekly resource > planning report. > > The format should be simple and better to understand. > > Thanks in Advance, > Re

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

Kindly try this formula =COUNTIF(B2:D5,">=4000")-COUNTIF(B2:D5,">6000") Regards Priyanka On Thu, Jan 12, 2012 at 12:47 PM, Vijayendra Rao wrote: > Dear All, > > I want to put countif range between 4000 to 6000. Please find attached > file for your reference. > > > Region Jan Feb Mar North 5

Re: $$Excel-Macros$$ costing sheet automation

Dear all can any one help me its need very urgent ple Chandru On Thu, Jan 12, 2012 at 11:59 AM, chandra sekaran wrote: > Dear all > > i need this excell automation, Sheet 1 data sheetand Out need like > this we need macro any one help me > > Regards > chandru > > > -- >

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

In Case of Excel 2003 you can use... *=SUMPRODUCT(--($B$2:$D$5>4000)*($B$2:$D$5<=6000))* Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Jan 12, 2012

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

Dear Vijayendra, Please use below formula and see attached sheet. *=COUNTIFS($B$2:$D$5,">"&4000,$B$2:$D$5,"<="&6000)* -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ RISING LAGNA

Thanks Kris, the formula is working, bit i am facing problem as in my sheet as the Time and Date is entered as =now() in formula and hence getting result #NA. if i am putting the date as 11-1-2012 and time as 11:03 , then the result comes. But i have to put the date and time as =now() only. So sho

$$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

Dear All, I want to put countif range between 4000 to 6000. Please find attached file for your reference. Region Jan Feb Mar North 5000 6000 4500 South 5800 7000 3000 East 3500 2000 1 West 12000 4000 6000 Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for

$$Excel-Macros$$ Summary for a Weekly report

Dear Team, Require a dashboard or a summary sheet for the attached weekly resource planning report. The format should be simple and better to understand. Thanks in Advance, Regards, Lucky -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor t

Re: $$Excel-Macros$$ Excel VBA interview questions

Awesome! Thanks :) On Wed, Jan 11, 2012 at 11:15 PM, NOORAIN ANSARI wrote: > FYI > > > On Wed, Jan 11, 2012 at 11:04 PM, NOORAIN ANSARI > wrote: > >> Dear Experts, >> >> Please use below link for excel-vba interview questions.. >> >> http://www.coolinterview.com/type.asp?iType=220 >> >> Kindly s

$$Excel-Macros$$ Re: Looping through two columns

Hi, May be Sub kTest() Dim k, i As Long, r As Range, c As Range Dim wksActive As Worksheet, wksNew As Worksheet Set wksActive = Worksheets("Data") Set r = Intersect(wksActive.UsedRange, wksActive.Range("b:f")) k = Intersect(wksActive.UsedRange, wksActive.Range("h:h")

Re: $$Excel-Macros$$ Looping through two columns

Is this the same problem answered by myself, and others??? What do you want? Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: jagan mohan Sent: Wednesday, January 11, 2012 2:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Looping throu

Re: $$Excel-Macros$$ Looping through two columns

Hi I was checking out your mail i have a similar problem..could u help me out...i want the solution to be on the lines of what you have shown in your attachment data1.xlsm. I am sending an attachment of the problemcould you please help me out??? On Tue, Jan 10, 2012 at 2:57 PM, Pranav N

$$Excel-Macros$$ Excel VBA interview questions

Dear Experts, Please use below link for excel-vba interview questions.. http://www.coolinterview.com/type.asp?iType=220 Kindly share with group if any one have other links or Excel-VBA Interview questions.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Fwd: $$Excel-Macros$$ how to create a user form return with vlookup query

On Wed, Jan 11, 2012 at 10:07 PM, NOORAIN ANSARI wrote: > Dear Prabhat, > > See attachment in 2003 version. > > > On Wed, Jan 11, 2012 at 9:46 PM, prabhat.shrivasta...@gmail.com < > prabhat.shrivasta...@gmail.com> wrote: > >> Thanks for your kind help, Pls provide excel in 2003 format. >> >> >> >>

Re: $$Excel-Macros$$ Conditional Chart

Or even this or incorporate a select case Sub Chart_formating_KaranSAS() Dim x As Long With Sheets("SAS").ChartObjects("Chart 1") _ .Chart.SeriesCollection(1) For x = 1 To .Points.Count .Points(x).Interior.Color = vbBlue If .Points(x).DataLabel.Text > 40 Then _ .Points(x).Interior.Color

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Hi Rajan, Here you go. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post

RE: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Ok.. we can use Paste List option for that. it was new for me.. Thanks. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Wed/2012 08:03 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ List of Dynamic & named ra

Re: $$Excel-Macros$$ RISING LAGNA

Hi Try this array formula. =INDEX(D4:O4,,MATCH(MIN(ABS(R3-INDEX(D5:O28,MATCH(Q3,INT(C5:C27),0),0))),ABS(R3-INDEX(D5:O27,MATCH(Q3,INT(C5:C27),0),0)),0)) Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

RE: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Hi Krishna.. Can you send the screenshot where this option is available in Excel.. Thanks Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Jan/Wed/2012 07:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ List of Dyn

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Hi Why VBA ?? In XL 2007, go to Formulas > Use in Formula > Paste Names In Xl 2003, Insert > Names > Paste Names Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

$$Excel-Macros$$ Re: Conditional Chart

Hi Here is non-VBA method. Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2)

RE: $$Excel-Macros$$ RISING LAGNA

Try this: =IFERROR(OFFSET($C$4,,MATCH(R3,INDIRECT("C"&ROW(INDEX($C$4:$C$28,MATCH(Q3,C4 :C28,0),1))&":O"&ROW(INDEX($C$4:$C$28,MATCH(Q3,C4:C28,0),1))),0)-1,1,1),"Not Found") From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nemi Gandhi Sent: Jan/Wed/2012

RE: $$Excel-Macros$$ how to create a user form return with vlookup query

See the form in attached file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of prabhat.shrivasta...@gmail.com Sent: Jan/Wed/2012 09:36 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ how to create a user form return with vlook

RE: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Try this: Sub listnames() Dim n As Name Dim i As Long i = 1 For Each n In ThisWorkbook.Names Range("E" & i) = n.Name Range("F" & i) = "'" & n.RefersToR1C1 i = i + 1 Next n End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of C

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congratulations, Rajan! Amol Jadhav On 11 January 2012 17:39, Finos Edavanna wrote: > welcome back .. sam... > > On 1/5/12, KAUSHIK SAVLA wrote: > > Congrats Rajan. > > > > Many thanks for devoting your valuable time daily from your busy > schedule. > > > > Regards, > > Kaushik Savla > > > >

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

welcome back .. sam... On 1/5/12, KAUSHIK SAVLA wrote: > Congrats Rajan. > > Many thanks for devoting your valuable time daily from your busy schedule. > > Regards, > Kaushik Savla > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor th

$$Excel-Macros$$ psExcel remote call to VBS script - problems saving excel workbook on 2008R2

I'm calling a bat file using psExec from one 2008r2 server to another. The bat file calls a VBS file that creates a excel file and saves the file in the same location as the VBS file. This all works when run locally, but remote using psExec the vbs file won't save the excel file. 11/01/2012 2:20

$$Excel-Macros$$ Looking to commission specific Macros solutions

Hello all: I am the owner of a small business in Texas and we are launching a new branch of service in our marketplace. Ultimately I plan to have some custom built software made to provide a long term solution. However we aren't there yet. We have been through the custom software process before and

$$Excel-Macros$$ RISING LAGNA

Please provide formula. sheet attached. -- Nemi Gandhi 98204 92963 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick att

$$Excel-Macros$$ Conditional Chart

Dear All, Is there any way to make a conditional chart. I need to make a conditional chart. Kindly help me in this. conditions 1. If value is Less than 40 = bar graph colour : Blue 2. If value is 41-70 = bar graph colour is Green 3. if value is 71-100 = Red I'v attached the file for the sampl

$$Excel-Macros$$ Visual Basic, Expert in VBA for MS Office(Mainly for excel) Requirement

Fwd::: Required Profile = *Skill set :* Visual Basic, Expert in VBA for MS Office(Mainly for excel), Good knowledge of Excel Macro Years of experience : 4-6 yrs Role : Developer Date of Joining : ASAP ** ** *Location:* Bangalore (Domestic Onsite) ** ** ** **

Re: $$Excel-Macros$$ Macro to send Email various recipients

Ok it's done On Wed, Jan 11, 2012 at 3:27 PM, NOORAIN ANSARI wrote: > Dear Priyanka, > > Try it and see attached sheet, hope it will help to you. > > Sub send_Email() > Dim olApp As Outlook.Application > Dim olMail As MailItem > Dim mailbody As String > For j = 2 To Sheet1.Cells(Rows.Count, "A").

Re: $$Excel-Macros$$ Macro to send Email various recipients

Dear Priyanka, Try it and see attached sheet, hope it will help to you. Sub send_Email() Dim olApp As Outlook.Application Dim olMail As MailItem Dim mailbody As String For j = 2 To Sheet1.Cells(Rows.Count, "A").End(xlUp).Row mailbody = "" & _ "Name " & _ "Amount " & _ "Count " & _ ""

Re: $$Excel-Macros$$ how to create a user form return with vlookup query

Dear Prabhat, See attached sheet, hope it will help to u. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Jan 11, 2012 at 9:35 AM, prabhat.shriva

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Dear Cab, Please use.. Sub listnames() Dim n As Name Dim i As Long i = 1 For Each n In ThisWorkbook.Names Range("E" & i) = n.Name Range("F" & i) = "'" & n.RefersToR1C1 i = i + 1 Next n End Sub -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*