try this
c58 = enter employee no
t 58 =SUMPRODUCT(MAX(($C$8:$C$57=C58)*($T$8:$T$57)))
u 58 =SUMPRODUCT(MAX(($C$8:$C$57=C58)*($U$8:$U$57)))
On Thu, May 5, 2011 at 10:02 PM, sudarshan rampe sidhu...@gmail.com wrote:
hello friends
i need a formula in the excel sheet in the last two columns so that
He is Considering #N/A Error..
On Thu, May 5, 2011 at 7:38 PM, pravin.si...@gmail.com wrote:
My friend I'll have data for all 34 35-53 soi there will be no error
Sent on my BlackBerry® from Vodafone
--
*From: * NOORAIN ANSARI noorain.ans...@gmail.com
*Date:
Just add the following line to your code..
Sheets(Customer
Record).Range(ABZ1).End(xlToLeft).Offset(0,1).PasteSpecial
Paste:=xlPasteValues
Regards
Deepak
On Fri, May 6, 2011 at 5:22 AM, Bob bobandrich...@comcast.net wrote:
I'm sorry , Still having trouble with copy on next available blank
Dear Mr. Golden Lance,
When i m copying the code and executing in the new workbook, the following
error is showing. Kindly help me.
*Compile error : syntax error*
Regards,
Saroj.
On Thu, May 5, 2011 at 10:17 PM, GoldenLance samde...@gmail.com wrote:
Thanks for highlighting
Were is it located to attach file? Sorry I don't see it. Thanks
On May 6, 1:25 am, ashish koul koul.ash...@gmail.com wrote:
can you share the sample file
On Fri, May 6, 2011 at 5:22 AM, Bob bobandrich...@comcast.net wrote:
I'm sorry , Still having trouble with copy on next available
Hi
I want to create one folder in the same folder...
MkDir (ThisWorkbook.Path \33)
this will create a folder with the name 33. I want to link the name with a
cell so that if the value is 34 the created folder name will be 34. if the
cell value is 38 the folder name should be 38.
Pls help.
Hello Experts,
I'm looking for an macro to send an email on a specific date, We can run the
macro daily and I want it to compare todays date with the deadline and in
case it matches, the excel should shoot an email.
I have mentioned the details in the excel sheet.
Please advice if this is
Hello Group Members,
Is it possible to add file name in consolidated sheet???
Pls suggest..
Regds,
Manish
-- Forwarded message --
From: ashish koul koul.ash...@gmail.com
Date: Oct 28 2010, 7:36�pm
Subject: $$Excel-Macros$$ How to consolidate the data using macro
To: MS EXCEL
Hi Bob,
I'm sorry bro, I didn't understand your problem completely...
There is a minor problem with the code that youve written.. If you copy the
complete column then you can paste it only from row no 1 of the worksheet.
So instead of copying the complete column you just need to copy those rows
=cell(FileName)
On Fri, May 6, 2011 at 11:04 AM, Manish pansari.man...@gmail.com wrote:
Hello Group Members,
Is it possible to add file name in consolidated sheet???
Pls suggest..
Regds,
Manish
-- Forwarded message --
From: ashish koul koul.ash...@gmail.com
Date: Oct
Sub MkDir()
Dim fso As New Scripting.FileSystemObject
fso.CreateFolder (ThisWorkbook.Path \ 33)
End Sub
On Fri, May 6, 2011 at 1:31 PM, Pravin Kumar pravin.si...@gmail.com wrote:
Hi
I want to create one folder in the same folder...
MkDir (ThisWorkbook.Path \33)
this will create a
Sub MkDir()
Dim fso As New Scripting.FileSystemObject
fso.CreateFolder (ThisWorkbook.Path \ *GiveThecellReferenceHere*)
End Sub
On Fri, May 6, 2011 at 4:43 PM, rajan verma rajanverma1...@gmail.comwrote:
Sub MkDir()
Dim fso As New Scripting.FileSystemObject
fso.CreateFolder
See if It help,, Edit Macro According to your requirement..
Public Sentmag As String
Sub SenDmail()
Dim outLookApp As Object
Set outLookApp = CreateObject(Outlook.application)
Dim FileName As String
Dim Data As Integer
Dim Msg As String
Dim mitem As Object
Dim Sign As String
Dim recp As String
try this
press alt +f11 goto tool - reference - Microsoft shell control and
automation and paste below code and run it.
select the folder in which files 1 and 2 are stored
Function SelectFolder(Optional Title As String, Optional TopFolder _
As String) As String
Dim objShell As New
send email to excel-macros@googlegroups.com
and add the attachment
On Fri, May 6, 2011 at 4:24 PM, Bob bobandrich...@comcast.net wrote:
Were is it located to attach file? Sorry I don't see it. Thanks
On May 6, 1:25 am, ashish koul koul.ash...@gmail.com wrote:
can you share the sample file
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 zinknax.zin...@gmail.com wrote:
Hi All,
I need help on get pivot formula for getting average of last three days
score.
Please find attached sheet, is more
see if it helps
http://akoul.blogspot.com/search/label/Sending%20e%20mail%20based%20on%20data%20in%20column%20in%20excel%20using%20outlook
On Fri, May 6, 2011 at 4:46 PM, rajan verma rajanverma1...@gmail.comwrote:
See if It help,, Edit Macro According to your requirement..
Public Sentmag
HI Brajesh
How are u... You can also Use this Macro By Compiling your All File...
Sub Compile()
On Error GoTo Err_Clear:
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim Fso As New Scripting.FileSystemObject
Dim Path As String
Please amend this as per ur requirement...
On Fri, May 6, 2011 at 7:30 PM, rajan verma rajanverma1...@gmail.comwrote:
HI Brajesh
How are u... You can also Use this Macro By Compiling your All File...
Sub Compile()
On Error GoTo Err_Clear:
Application.ScreenUpdating = False
Thank you all... Have a great Weekend :)
On Fri, May 6, 2011 at 8:54 AM, rajan verma rajanverma1...@gmail.comwrote:
Find the attached File..
On Fri, May 6, 2011 at 5:20 PM, mayur zinknax.zin...@gmail.com wrote:
Hi All,
I need help on get pivot formula for getting average of last three
dear ashish,,
That is excellent great.Thanks a lot .The formula u provided is
very nearer to the solution i wanted.everthing is same except in the month
column of the sheet.Name of the month should be printed like April'2011
instead of *05-Apr-2011 TO 04-May-2011*.
the above formula
Hi Guys,
lets say there are 2 workbooks wkbk_run and wkbk_monitor. wkbk_run has macro
which runs automatically and sometimes it throws OLE error for which we need to
MANUALLY click OK button. i want wkbk_monitor to monitor that wkbk_run and
whenever that OLE error occurs it should click OK
Hi All,
I have a little query in vba coding, please see the attached file. In the
excel file there is a Save command button, whenever I press the button it
will copy the data from cell no. c1:d1 and paste in the cell a1:b1, now my
query is, if the data is already in the cell no. a1:b1 it will be
try this
Private Sub CommandButton1_Click()
Range(C1:D1).Select
Selection.Copy
Range(A65356).End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
On Sat, May 7, 2011 at 1:56 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi All,
I
Dear Indrajit
please try this code
Private Sub CommandButton1_Click()
' siti Vi / jakarta, May 07, 2011
Dim R As Long
R = WorksheetFunction.CountA(Range(A:A)) + 1
Cells(R, 1) = Cells(1, 3)
Cells(R, 2) = Cells(1, 4)
End Sub
On Sat, May 7, 2011 at 3:26 AM, Indrajit $nai
It macro will not work properly if these is any blank row between the Data..
It will all time replace existing Data..
On Sat, May 7, 2011 at 8:56 AM, STDEV(i) setiyowati.d...@gmail.com wrote:
Dear Indrajit
please try this code
Private Sub CommandButton1_Click()
' siti Vi / jakarta, May
just a little modif:
Private Sub CommandButton1_Click()
Dim R As Long
* R = Cells(Rows.Count, 1).End(xlUp).Row + 1*
Cells(R, 1) = Cells(1, 3)
Cells(R, 2) = Cells(1, 4)
End Sub
On Sat, May 7, 2011 at 11:38 AM, rajan verma rajanverma1...@gmail.comwrote:
It macro will not work
27 matches
Mail list logo