Re: $$Excel-Macros$$ Need Help

See if it helps : https://sheet.zoho.com/excelviewer On Tue, Oct 4, 2011 at 9:33 AM, syed aliya raza hashim wrote: > Can excel file such as reports be access from web or can be acccess as web > pages suppose we have 10 sheets but from some url we want to see the reports > > -- > syed aliya > > -

Re: $$Excel-Macros$$ Need Help

Not clear as to what you want. Pls provide sample sheet and urls and what you need. From: syed aliya raza hashim Sent: Monday, October 03, 2011 11:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Help Can excel file such as reports be access from web or can be acccess as

Re: $$Excel-Macros$$ Need help with forecast formula

It looks like you are forecasting daily ship $ correctly. Is the problem in summing up the total for the month or in showing cumulative totals in your month-to-date (column L)? If the latter is the case, you can simply use an "if" function to grab from column M when column E has a null value. Stev

Re: $$Excel-Macros$$ Need Help

Simply deleting the un-needed rows and columns reduced the file by one half. Combining like sheets with an extra column and using autofilter would help. Etc. From: syed aliya raza hashim Sent: Sunday, September 25, 2011 1:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Hel

Re: $$Excel-Macros$$ Need help with forecast formula

Thank you Sam for your suggestion but I still can't get the formula to work. In case it makes a difference, I'm using Excel 2002 with SP3 installed. What am I missing? Steve On 9/25/2011 2:48 PM, Sam Mathai Chacko wrote: Try =FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down HTH, Sam Ma

Re: $$Excel-Macros$$ Need help with forecast formula

Try =FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down HTH, Sam Mathai Chacko (GL) On Sun, Sep 25, 2011 at 11:12 PM, Steve Weaver wrote: > Each day I update the attached spreadsheet with with our previous days > shipments. I would like to use the daily ship data to forecast the total > monthly

Re: $$Excel-Macros$$ Need help to locate data on same row each time i click OK

Thanks noorain, It solved my prb... -- -- 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.c

Re: $$Excel-Macros$$ Need help on String Matching

You could use a combination of Haseeb's formula and this array formula =INDEX(Sheet1!$A:$A,MIN(IFERROR(MATCH(RIGHT(A2,ABS(LEN(A2)+1-ROW(INDEX($A:$A,1):INDEX($A:$A,LEN(A2)&"*",Sheet1!$A:$A,0),""))) The trick would be to identify *when* you would use either... Sam Mathai Chacko (GL) On Wed, S

Re: $$Excel-Macros$$ Need help on String Matching

*Dear friend, =VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0) please help me after vlookup"*",&a1&"*" Thanks with Mothilal * On Tue, Jul 12, 2011 at 7:31 PM, Anish Shrivastava wrote: > Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :) > > > On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Ve

Re: $$Excel-Macros$$ Need help to locate data on same row each time i click OK

Dear Rashmiv, Please see attached automated Sheet.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Sep 21, 2011 at 1:13 PM, Rsh wrote: > Hi

Re: $$Excel-Macros$$ Need help to locate data on same row each time i click OK

You've created the userform, but it looks like you don't have ANY of the code behind it. I thought your question was how to ensure that each trip is entered sequentially, now I am not so sure. Are you familiar with VBA? Are you wanting specific assistance? or are you looking for some one to writ

Re: $$Excel-Macros$$ Need help on String Matching

Hi Haseeb, Thanks for you help on this query but recently I noticed onething, this formula works when we have to match strings from left. In this case it works fine. But when I have the below scenario, it doesnt work properly. For example, in source sheet I have "Analex Corporation" and in Destin

Re: $$Excel-Macros$$ Need help with advance filter

Thank you dguillett!! I'm not real sure how this works or what to do with it. Could you please explain to me each step in "baby talk" ? Thank you! Steve On 9/10/2011 10:31 AM, dguillett1 wrote: From what I can see, it

Re: $$Excel-Macros$$ Need help with advance filter

Did you get what I sent? From: Steve Weaver Sent: Saturday, September 10, 2011 1:56 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help with advance filter Thank you very much Ashish!!! How would you modify the code below to place the appropriate data from the

Re: $$Excel-Macros$$ Need help with advance filter

try this select any rep name in col a and run the macro Sub filter() Application.ScreenUpdating = False If ActiveCell.Column = 1 Then Z = Sheets("Input Data").Range("a1").End(xlDown).Row On Error Resume Next Sheets("Input Data").AutoFilterMode = False Sheets("Input Data").Range("$A$1:$I" & Z).A

Re: $$Excel-Macros$$ Need help --------

Hey Jocky, please find the attachment. On Sun, Aug 28, 2011 at 7:08 PM, jocky Beta wrote: > Hi, > > Can you create same for me? > > The Formula is given below. > >*FORMULA - A = P* (1 + r/12)12 > >*P* is the principal (the initial amount you borrow or deposit) - * >

Re: $$Excel-Macros$$ Need help --------

Hi, Can you create same for me? The Formula is given below. *FORMULA - A = P* (1 + r/12)12 *P* is the principal (the initial amount you borrow or deposit) - *TextBox1* *r* is the annual rate of interest (percentage) - *TextBox2* *n* is the number of years the amount is deposited or b

Re: $$Excel-Macros$$ Need help --------

Your Worksheet Doesnt have any Code to Calculate on Click. On Sun, Aug 28, 2011 at 12:20 PM, jocky Beta wrote: > > Hi Team, > >I had create Compound Calculator in Excel VB sheet , i had already set > the Formula in VB but when i Click on the Calculate Button it shows error, > hence i request

Re: $$Excel-Macros$$ Need help in maro

Or simply use data validation with a list of sheet names and select the one to show and tie to a worksheet_Change event From: Rajan_Verma Sent: Tuesday, August 23, 2011 2:00 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need help in maro Hi Prasad, Ashish’s Code working

RE: $$Excel-Macros$$ Need help in maro

Hi Prasad, Ashish's Code working fine..See the attached Sheet. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Suryaprasad Sent: Tuesday, August 23, 2011 10:56 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help in maro Hi All,

Re: $$Excel-Macros$$ Need help in maro

: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help in maro add this macro to each box Sub test() Application.DisplayAlerts = False Application.ScreenUpdating = False ' method 1 in this u have to change the shape names as per the sheet names 'Fo

Re: $$Excel-Macros$$ Need help in maro

add this macro to each box Sub test() Application.DisplayAlerts = False Application.ScreenUpdating = False ' method 1 in this u have to change the shape names as per the sheet names 'For i = 2 To Sheets.Count 'Sheets(i).Visible = True 'If Sheets(i).Name <> Application.Caller Then ' 'Sheets(i).Vi

RE: $$Excel-Macros$$ Need Help With an Imput Box in VBA

Try this Sub INputDate() Range("A1").Value = Application.InputBox("Please Enter YOur date", , , , , , , 1) Range("A1").NumberFormat = "mm/dd/yy" End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Erick C Sent: Friday, August 1

Re: $$Excel-Macros$$ Need Help With an Imput Box in VBA

Hi Erick, Look attached..see if helps... *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 12, 2011 at 12:34 AM, Erick C wrote: > Hi everybody - > > I am hoping someone can help me out. I have a spreadsheet that I am > currently making a macro in VBA. I would like to have an imput box

Re: $$Excel-Macros$$ Need Help With an Imput Box in VBA

Hi Erick, Please see attached sheet... -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Aug 12, 2011 at 12:34 AM, Erick C wrote: > Hi everybody - > > I am hoping someone can help me out. I have a spreadshe

RE: $$Excel-Macros$$ Need help in Meeting room booking system

Hope it will help you Add this in Your code If Day(Me.DTPicker1.Value) >= Day(Now()) And Month(Me.DTPicker1.Value) >= Month(Now()) And Year(Me.DTPicker1.Value) >= Year(Now()) Then If Hour(Me.DTPicker2.Value) >= Hour(Now) & Minute(Me.DTPicker2.Value) >= Minute(Now) Then MsgBox

RE: $$Excel-Macros$$ Need help on Email from Excel

Team, Can you please help me on my query. I want you to work on attached file itself. Waiting for your response Regards, -- Forwarded message -- From: hemant shah Date: Wed, Aug 3, 2011 at 9:26 PM Subject: $$Excel-Macros$$ Need help on Email from Excel To: excel-macros Dear

Re: $$Excel-Macros$$ Need help on Email from Excel

try this http://akoul.wordpress.com/category/email-through-excel-using-outlook/ On Wed, Aug 3, 2011 at 9:26 PM, hemant shah wrote: > Dear Team, > > I need a help on emailing from excel itself. > I have explained all the steps in the attached excel. > > Regards, > > -- > -

RE: $$Excel-Macros$$ Need Help for Sumif

Attached a sheet with data . its not clear data as pasted in Mail -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkatesh Narla Sent: Tuesday, July 26, 2011 4:40 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ Need Help for Sumif

can you attach the sample sheet On Tue, Jul 26, 2011 at 4:39 PM, Venkatesh Narla wrote: > Hi All, > Need help for SUMIF Function i am doing time sheet conslidation i am > not able sum up all days for one resource in other TAB > Example: > > > Resource7/1/20117/2/2011

Re: $$Excel-Macros$$ need help

l > *Sent:* Friday, July 22, 2011 9:37 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ need help > > ** ** > > > cjeck the attachment have applied conditional formatting > > ** ** > > ** ** > > ** ** > > On Fr

Re: $$Excel-Macros$$ Need help on String Matching

Hey Haseeb, This formula is AWESOME man... Tooo goood.. helped me big time.. A big THANK YOU :) Thanks, Anish On Tue, Jul 12, 2011 at 8:25 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello, Try this Array Formula. Must hit CONTROL+SHIFT+ENTER, rather than > ENTER. > > > =INDEX(

Re: $$Excel-Macros$$ Need help on String Matching

Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :) On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Verma wrote: > *=VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0)* > > *Use this* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Anish Shrivastava > *Se

RE: $$Excel-Macros$$ Need help on String Matching

=VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0) Use this From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anish Shrivastava Sent: Monday, July 11, 2011 3:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help on String Matching Hello Experts,

Re: $$Excel-Macros$$ Need help on String Matching

Hi Ashish, This one looks great but it will only help if few of the characters at the end of the text is missing. For Example - "Guitar Center, ." (row # 1650) in the 2nd sheet is not able to find the value because it's "Guitar Center, Inc." in sheet one. *I wanted something like which matches t

Re: $$Excel-Macros$$ Need help on String Matching

try this VLOOKUP(A1&"*",Sheet1!$A:$A,1,0) On Mon, Jul 11, 2011 at 3:42 PM, Anish Shrivastava wrote: > Hello Experts, > > I am writing this mail with a great hope. > > Please see the attached file where I have 2 sheets with data populated > column "A". > > I want to find the best possible match i

Re: $$Excel-Macros$$ need help

Hi,Thanks for taking initiative , See there are two Clients:-> 1 Genentech 2 Lifetech Both have three tabs Open,closed,Rejection that means total 6 tabs but i want only three tabs named Open,close,Rejection,in Open tab i want to put all Genentech&Lifetech Open data same in closed tab i want to pu

Re: $$Excel-Macros$$ need help

*can u explain ur requirement with a sample file?, i m not getting it properly *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sun, Jul 10, 2011 at 10:10 PM, Rajan_Verma wrote: > *Which is the Column of Client Name.?

RE: $$Excel-Macros$$ need help

Which is the Column of Client Name.?? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of syed aliya raza hashim Sent: Saturday, July 09, 2011 1:10 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need help Hi, Hi , I have the two client s

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

el-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* samedi 9 juillet 2011 13:01 > *À :* excel-macros@googlegroups.com; dcolarde...@free.fr > > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in > user from by loop > > ** ** > &

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

shariq khan Envoyé : samedi 9 juillet 2011 00:32 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user from by loop Daneil, that is what i want but the same code is not working.in my sheet. what is Me.contol ? On Fri, Jul 8, 2

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user from by loop Daneil, that is what i want but the same code is not working.in my sheet. what is Me.contol ? On Fri, Jul 8, 2011 at 10:22 PM, Daniel wrote: Give a try at the attached

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

ps.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 18:17 > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in > user from by loop > > ** ** > > Dan

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

> > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* shariq khan > *Envoyé :* vendredi 8 juillet 2011 13:11 > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

o:excel-macros@googlegroups.com] De la part de shariq khan Envoyé : vendredi 8 juillet 2011 13:11 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user from by loop Hi Daneil, Thanks but it didnt worked.. Run-time error '

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

Which line gets the error ? Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de shariq khan Envoyé : vendredi 8 juillet 2011 13:11 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user from by

Re: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

Hi Daneil, Thanks but it didnt worked.. Run-time error '-2147024809 Could not find the specified object Thanks, Shariq On Fri, Jul 8, 2011 at 11:12 AM, Daniel wrote: > Hi, > > ** ** > > Try : > > ** ** > > For num = 1 To 22 > > txtbox_val = Me.Controls("TB" & num).

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

You have to make a loop through each OleObject Embaded on Worksheet, See if it helps. Sub LoopWsCntrl() Dim OLECont As OLEObject Dim lRow As Long, lCol As Long For Each OLECont In Sheet1.OLEObjects If OLECont.progID = "Forms.TextBox.1" Then Variable = OLECont.Object.Val

RE: $$Excel-Macros$$ Need Help Help Help.....Putting value in user from by loop

Hi, Try : For num = 1 To 22 txtbox_val = Me.Controls("TB" & num).Value txtbox_num = num Next num Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de shariq khan Envoyé : vendredi 8 juillet 2011 11:00 À : excel-macros@go

Re: $$Excel-Macros$$ Need Help

Thanks for helping. On Sun, May 8, 2011 at 6:31 AM, STDEV(i) wrote: > Sub ExpandTable() >' by siti Vi / jakarta, 8 may 2011 >Dim SrcRng As Range, ResRng As Range, pDate As Date >Dim i As Long, r As Long, u As Integer > >Set SrcRng = Cells(1).CurrentRegion >Worksheets.Add A

Re: $$Excel-Macros$$ Need Help

dear Mr. Verma, et us try both macros with the NEW source table (as New Input) like this please find attached: ** a workbook containing this data ** a workbook containing both macros X1 1.7 11/11/2008 01/11/2010 X2 2.4 11/12/2009 01/11/2010 X3 3.8 11/01/20

Re: $$Excel-Macros$$ Need Help

hi STDV(i) Your macro only working with 3 Rows.. if he want to add more data in that table it will not expend all table.. On Sun, May 8, 2011 at 1:40 PM, rajan verma wrote: > hi > find attached File > > > > On Sat, May 7, 2011 at 11:33 AM, anvesh.gw...@gmail.com < > anvesh.gw...@gmail.com> wrote:

Re: $$Excel-Macros$$ Need Help

hi find attached File On Sat, May 7, 2011 at 11:33 AM, anvesh.gw...@gmail.com < anvesh.gw...@gmail.com> wrote: > Hi, > > I need help in VBA code. > I have excel sheet on which data is write as below mention > > > Input > > A BC D > 1 X1 1.51

Re: $$Excel-Macros$$ NEED HELP - GET PIVOT

When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks & regards On 5/6/11, mayur wrote: > Tha

Re: $$Excel-Macros$$ NEED HELP - GET PIVOT

Thank you all... Have a great Weekend :) On Fri, May 6, 2011 at 8:54 AM, rajan verma wrote: > Find the attached File.. > > On Fri, May 6, 2011 at 5:20 PM, mayur wrote: > >> Hi All, >> >> I need help on get pivot formula for getting average of last three days >> score. >> Please find attached she

Re: $$Excel-Macros$$ NEED HELP - GET PIVOT

try this (VLOOKUP(MAX(G:G),G:K,5,0)+VLOOKUP(MAX(G:G)-1,G:K,5,0)+VLOOKUP(MAX(G:G)-2,G:K,5,0))/3 On Fri, May 6, 2011 at 5:20 PM, mayur wrote: > Hi All, > > I need help on get pivot formula for getting average of last three days > score. > Please find attached sheet, is more self explanatory. > >

Re: $$Excel-Macros$$ Need Help

Create a Object of Excel in Access...the work with that Object. On Mon, May 2, 2011 at 5:44 PM, rohit gupta wrote: > Dear, > > pls let me know how i can create excel macros in MS ACESS 2003. > > thanks in advance... > > regards, > > > > -- > >

Re: $$Excel-Macros$$ Need Help urgent Please

Try ths code Private Sub Workbook_Open() Dim i, j, k As Long Dim SWA1, SWA2, SWA3 As String SWA1 = "" SWA2 = "" SWA3 = "" Sheets("UPS").Activate For j = 2 To Sheets("UPS").Range("a1").End(xlDown).Row If Sheets("UPS").Cells(j, 2).Value <= DateSerial(Year(Now), Month(Now), Day(Now)) Then SWA1 = SW

Re: $$Excel-Macros$$ Need Help urgent Please

Hi Ashish, Thanks for replying but it is showing for only 28-April-2011 see what i want to display the meassage which date has been expired eg.today date is 27 april ,so the message display for less than the today date or system date for example Product Date 1001 3-May-2011 1002 26-

Re: $$Excel-Macros$$ Need Help

Thank you very much Ashish Ji, very sorry for late reply Redgs ROHAN On Thu, Apr 21, 2011 at 4:00 PM, ashish koul wrote: > rohan > > try this > > =IF(ABS(C3-B3)<=0.1,B3,C3) > > > > > > On Thu, Apr 21, 2011 at 1:49 PM, Rohan Young wrote: > >> Dear Ashish, >> >> please sought it out my problem

Re: $$Excel-Macros$$ Need Help

rohan try this =IF(ABS(C3-B3)<=0.1,B3,C3) On Thu, Apr 21, 2011 at 1:49 PM, Rohan Young wrote: > Dear Ashish, > > please sought it out my problem as attached > > thanks > > Rohan > > > On Thu, Apr 21, 2011 at 12:02 PM, Rohan Young wrote: > >> Dear rajan, >> >> i need output figure not blank

Re: $$Excel-Macros$$ Need Help

Dear Ashish, please sought it out my problem as attached thanks Rohan On Thu, Apr 21, 2011 at 12:02 PM, Rohan Young wrote: > Dear rajan, > > i need output figure not blank cell > > thanks > > > On Wed, Apr 20, 2011 at 3:46 PM, rajan verma wrote: > >> =IF((C3-B3)>0.01,C3,"" > > > --

Re: $$Excel-Macros$$ Need Help

Dear rajan, i need output figure not blank cell thanks On Wed, Apr 20, 2011 at 3:46 PM, rajan verma wrote: > =IF((C3-B3)>0.01,C3,"" -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri

Re: $$Excel-Macros$$ Need Help

=IF((C3-B3)>0.01,C3,"") paste it in Output On Wed, Apr 20, 2011 at 1:04 PM, Rohan Young wrote: > Dear gurus, > > please sought out my problem as attached where i m confusing or what is the > solution > > thanks in advance > > ROHAN > 9818247278 > > -- > >

Re: $$Excel-Macros$$ Need Help

Dear Daniel, i need here Actual wt., the difference output is negative but the condition is <=0.1. what i need? does'nt matter output figure is negative but condition is <=0.1 is fixed* (if difference is >0.1, i only need Invoice wt. in the rest condition i need Actual wt. after the fixed condi

Re: $$Excel-Macros$$ Need Help

Dear Daniel, i need here Actual wt., the difference output is negative but the condition is <=0.1. what i need? does'nt matter output figure is negative but condition is <=0.1 is fixed* (if difference is >0.1, i only need Invoice wt. in the rest condition i need Actual wt. after the fixed condi

RE: $$Excel-Macros$$ Need Help

Hello, Can you explain G6 ? Difference is -0.190 which is <=0.1. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Rohan Young Envoyé : mercredi 20 avril 2011 09:35 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Need Help

Re: $$Excel-Macros$$ need help!

On Wed, Apr 13, 2011 at 11:22 AM, syed aliya raza hashim < hashim...@gmail.com> wrote: > Plz solve my problem! > > > > -- > syed aliya > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ need help!

find the attached workbook Thanks, Irfan Khan On Wed, Apr 13, 2011 at 11:22 AM, syed aliya raza hashim wrote: > Plz solve my problem! > > > -- > syed aliya > > -- > -- > Some important links for excel users: > 1. Foll

Re: $$Excel-Macros$$ need help!

First problem: Read guidelines for posting questions. DESCRIBE THE PROBLEM! Your Subject line should give a brief description of the problem. You should elaborate in the email, and explain what you've tried and where the error is. THEN attach a file if it helps. We have many helpful users here

Re: $$Excel-Macros$$ Need Help!

Hi, Find the attachment. Thaks, Kishor On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim wrote: > Hi, > Hi i have attached my file i want in sheet 2 there are column c in that i > want the name from sheet 1 but there are two condition first is match by ID > then match by Name as well then h

Re: $$Excel-Macros$$ Need Help!

As per my observation this is producing wrong result, please check it once again. On Fri, Apr 8, 2011 at 9:34 AM, §»VIPER«§ wrote: > hi syed, > > find the attached without array. > > -- > *Thanks & Regards > > Thamu > * > > On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim < > hashim...@gma

Re: $$Excel-Macros$$ Need Help!

hi syed, find the attached without array. -- *Thanks & Regards Thamu * On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim wrote: > Hi, > Hi i have attached my file i want in sheet 2 there are column c in that i > want the name from sheet 1 but there are two condition first is match by ID

Re: $$Excel-Macros$$ Need Help!

see if it helps On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim wrote: > Hi, > Hi i have attached my file i want in sheet 2 there are column c in that i > want the name from sheet 1 but there are two condition first is match by ID > then match by Name as well then how can we do this > >

Re: $$Excel-Macros$$ Need Help Regarding not calculating the average in case of Jan month but for all other month they are showing correct result

Thank you very much! On Thu, Apr 7, 2011 at 7:32 AM, rajan verma wrote: > use averageif() Function instead of Average(if()) > > Rajan. > > > On Wed, Apr 6, 2011 at 2:09 PM, syed aliya raza hashim < > hashim...@gmail.com> wrote: > >> >> Hi in this formula if i am incresing the range 25 to 125 then

Re: $$Excel-Macros$$ Need Help Regarding not calculating the average in case of Jan month but for all other month they are showing correct result

use averageif() Function instead of Average(if()) Rajan. On Wed, Apr 6, 2011 at 2:09 PM, syed aliya raza hashim wrote: > > Hi in this formula if i am incresing the range 25 to 125 then it is > counting blank cell also and traeting blank cell as a jan month so is there > any suggestion where can

RE: $$Excel-Macros$$ Need Help Regarding not calculating the average in case of Jan month but for all other month they are showing correct result

Hi, In K3 (array formula, validate with Ctrl+Shift+Enter) : =IF(ISERROR(AVERAGE(IF((MONTH($B$2:$B$125)=MONTH(J3))*(YEAR($B$2:$B$125)=YEA R(J3))<>0,$E$2:$E$125))),"",AVERAGE(IF((MONTH($B$2:$B$125)=MONTH(J3))*(YEAR( $B$2:$B$125)=YEAR(J3)),$E$2:$E$125))) Regards. Daniel De : excel-mac

Re: $$Excel-Macros$$ NEED HELP

Hi Daniel, Thank you so much for helping me out with this. Appreciate ur help bro Thanks n Regards Anupam On Fri, Mar 25, 2011 at 1:55 AM, Daniel wrote: > Hi, > > Have a look at the attached file. > > Regards. > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@

Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns

use concatenate function or & operator like =A1 & B1 & C1 etc On Tue, Mar 8, 2011 at 3:02 PM, sudhir kumar wrote: > Hi, > > Can u send Excel Sheet of this example. > > thanx > > > On 7 March 2011 12:17, Krish wrote: > >> Hi , >> >> I have data in row and column 1-3, and needs to club the

Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns

Hi, Can u send Excel Sheet of this example. thanx On 7 March 2011 12:17, Krish wrote: > Hi , > > I have data in row and column 1-3, and needs to club the data in > single row and column since the data acorss three columns, > > Pls help me. > > Regards, > Krish Kandy. > > -- > > ---

Re: $$Excel-Macros$$ Need Help

Hi find attach, check whether it helps as per my understanding NA count should be 0 On Tue, Feb 22, 2011 at 8:59 PM, Prathima R wrote: > My colleague has this equation set up to count the number of cells within > a range that are three standard deviations higher than the mean. But when he > ha

Re: $$Excel-Macros$$ Need Help Urgent..!

use this code in sheet 1 Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 1 And Target.Row = 3 Then Sheets(2).Activate Sheets(2).Cells(2, 1).Select End If End Sub On Mon, Feb 14, 2011 at 12:48 PM, rashid memon wrote: > please Provide Macro Co

Re: $$Excel-Macros$$ Need Help!!!!!!!!!!!!!!!!!

That was Excel limitation: max number of criteria (unique values list)on Auto Filter = 1000 On 2/13/11, Aamir Shahzad wrote: > sheet attached, simply when you want to use auto filter you must select all > your data till at the end. > Regards, > Aamir Shahzad > > On Wed, Feb 9, 2011 at 10:27 AM,

Re: $$Excel-Macros$$ Need Help

XLFileName     ThisWorkbook.Sheets(RepSheet).Cells(RepRow, 2).Value = Sheets.Count     Else     MsgBox Err.Number & Chr(13) & Err.Description     End If     ActiveWorkbook.Close savechanges:=False End Function '===============

Re: $$Excel-Macros$$ Need Help

. > Then, in the "report" file, > list the file name of each file, the number of sheets and the number of > records. > I can give that to you and then you can customize it to fit your needs... > > Paul > > -- > *From:* Prathima R

Re: $$Excel-Macros$$ Need Help

Try This.. Sub GetNonBlank() For i = 1 To ActiveWorkbook.Sheets.Count t = t + WorksheetFunction.CountA(Sheets(i).UsedRange) Next MsgBox t End Sub On Thu, Feb 10, 2011 at 6:11 AM, Prathima R wrote: > please advice in this concern as i am having around 20-30 workbooks where > in need to count t

Re: $$Excel-Macros$$ Need Help

t the file name of each file, the number of sheets and the number of records. I can give that to you and then you can customize it to fit your needs... Paul From: Prathima R To: excel-macros@googlegroups.com Sent: Thu, February 10, 2011 9:11:41 AM Subject: Re

Re: $$Excel-Macros$$ Need Help

please advice in this concern as i am having around 20-30 workbooks where in need to count the number of Non-blanks in multilple sheets. Thanks, Prathima On Thu, Feb 10, 2011 at 7:23 PM, Prathima R wrote: > > Thanks for the response. > > Here am trying to count the number of non-blanks in mult

Re: $$Excel-Macros$$ Need Help

Thanks for the response. Here am trying to count the number of non-blanks in multiple sheets On Thu, Feb 10, 2011 at 6:32 PM, Paul Schreiner wrote: > Are you wanting to count the sheets > or count the records/rows on all sheets? > > Sheets.Count > > gets you the number of sheets. > > For Sht

Re: $$Excel-Macros$$ Need Help

Are you wanting to count the sheets or count the records/rows on all sheets? Sheets.Count gets you the number of sheets. For Sht = 1 to sheets.count     total = total + application.worksheetfunction.counta(sheets(sht).range("A1:A65000")) next Sht would loop through all sheets and count the num

Re: $$Excel-Macros$$ Need Help

check the attachment se eif it helps On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose wrote: > Dear Team, > > Please find attach file in which i have explained my requirement and > request of your kindness to provide me the solution, *as i have more than > 4000 records of such data*. > > Thanks &

Re: $$Excel-Macros$$ Need Help

Hi Se att, u can do with pivot table. Rgds Enjoy excelling... On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose wrote: > Dear Team, > > Please find attach file in which i have explained my requirement and > request of your kindness to provide me the solution, *as i have more than > 4000 record

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

Paul - Thank you, this is exactly what I was looking for! On Jan 7, 11:37 am, Paul Schreiner wrote: > Align-left and Align-Right is irrelevent (I think) > because "alignment" is a paragraph property, not a string property. > > What you're saying is that you need the string padded > with spaces e

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

Align-left and Align-Right is irrelevent (I think) because "alignment" is a paragraph property, not a string property. What you're saying is that you need the string padded with spaces either on the left or right... So, by example, if you were padding with underscores (_), then the results you'r

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

can you attach the sample sheet On Fri, Jan 7, 2011 at 8:40 PM, Erick C wrote: > Hello everybody, > > I am in desperate need of some assistance, and I am hoping someone may > be able to give me a hand. I am still a bit of a novice when it comes > to vba code writing, so I am hoping that it may

Re: $$Excel-Macros$$ Need Help URGENTLY - zip file

You can use exact function as well =exact(A1, B1) Sent from BlackBerry® on Airtel -Original Message- From: SAJID MEMON Sender: excel-macros@googlegroups.com Date: Mon, 27 Dec 2010 17:15:52 To: Excel Group Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help

RE: $$Excel-Macros$$ Need Help URGENTLY - zip file

Dear You can compare two files with if formula just copy one file in second file and use =IF(columne one = columne two,"ture","false") hope you can easily find errors thanks > Date: Thu, 23 Dec 2010 01:31:23 -0800 > Subject: $$Excel-Macros$$ Need Help URGENTLY - zip file > From: vilaschav.

Re: $$Excel-Macros$$ Need help to get the collection date with the help of formula

try this INDEX($B$1:$W$1,0,MATCH("Collected",B2:W2,0)) On Tue, Dec 14, 2010 at 11:28 AM, lucky singh wrote: > Hi All, > > kindly help me to get the collaction date with the help of an formula... > I want to know the date of collection of each customer... > > please refer the attachment... > > >

Re: $$Excel-Macros$$ need help for insert .swf signature into outlook mail signature

check this link see if it helps http://www.ehow.com/how_5976974_insert-flash-movie-outlook-signature.html On Tue, Dec 14, 2010 at 10:44 AM, renuka chari wrote: > hi experts good morning > i need help for insert flash(.swf) signature file into outlook > signature > how it possible can u help me

Re: $$Excel-Macros$$ Need help to get the collection date with the help of formula

No attachment found. On Fri, Dec 10, 2010 at 3:16 PM, lucky singh wrote: > > Hi All, > > kindly help me to get the collaction date with the help of an formula... > > please refer the attachment... > > > Regards, > Lucky > > -- > > -

<    1   2   3   4   5   6   7   8   >