Anil
Sort the data after use formula.
Regards,
Brajesh
On Thu, Sep 29, 2011 at 10:54 AM, anil kumar kmr7a...@gmail.com wrote:
Hello sir,
frist of all thanks for reply. I used your formula but it is not work
according to my data. I have attched that file. plz see that.
Thanks Regards
Hi hamal,
Use can use filter if it help to you…….
Ctrl+Shift+L - drop filter - *filter by color* - *filter by cell
color *- Press
enter.
Regards,
Brajesh
On Wed, Sep 28, 2011 at 5:39 PM, hemal shah hemali...@gmail.com wrote:
If you have excel 2007 then follow the following procedure
Hi All,
I have got a file for which I have the password but when I click on the
file, it does not show me the password pop-up.
Password: assets
Kindly Suggests.
Regards
Mukesh Maurya
--
--
Some important links
Hi all,
I need to setup a Audi Trail system for my excel workbooks and I found
this code on the net by google search.
-
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
Dim strFileName As String
strFileName =
*Macro 1:*
Option Explicit
Sub ExtractReps()
Dim ws1 As Worksheet
Dim wsNew As Worksheet
Dim rng As Range
Dim r As Integer
Dim c As Range
Set ws1 = Sheets(Sheet1)
Set rng = Range(Database)
'extract a list of Sales Reps
ws1.Columns(C:C).AdvancedFilter _
Action:=xlFilterCopy, _
The trick here is knowing that when target.count 1, then the Target Range
becomes an array.
So, to get the cell address and values, you have to loop through the array..
like:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim inx
Dim strFileName As String
Hi Mahesh,
Thanks for your reply.
I have added extra numbers below that. And this macro is not accepting.
And also is it possible to make the matching cells as one color instead of
moving to next column.
/Suresh
On Thu, Sep 29, 2011 at 1:19 AM, Mahesh parab mahes...@gmail.com wrote:
Hi
Hi Paul,
thank you very much for aour effort. There is just one thing: I paste
2 values in S14 and S15 and the macro records values in S13 and S14.
Cold you please help.
regards,
seba
On 29 sep., 14:15, Paul Schreiner schreiner_p...@att.net wrote:
The trick here is knowing that when
Guys,
you have any presentation ppt on internet.if you have pls send me..
Regards
Amresh
On Thu, Sep 29, 2011 at 5:40 AM, Seba sebastjan.hri...@gmail.com wrote:
Hi Paul,
thank you very much for aour effort. There is just one thing: I paste
2 values in S14 and S15 and the macro records
Amresh,
If you have a question, please post a NEW discussion thread
instead of hijacking another discussion.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all
Send your file with a complete explanation and before/after examples to
dguille...@gmail.com
-Original Message-
From: Ken
Sent: Wednesday, September 28, 2011 1:03 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Computer moving average hrs of play per day
I have a spreadsheet
Interesting...
Can you please post the code you're using?
(at least for the loop)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as
Hi Paul,
I just took the your code above:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
Dim inx
Dim strFileName As String
strFileName = MyLocation\MyFile.txt
This will remove the duplicates. If you have xl2007 you could use the remove
duplicates
Sub advancedfilterunique()
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range(A1:A49)
.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range(b1), Unique:=True
.Delete Shift:=xlUp
End With
Evidently, the Target array doesn't start at '0' like normal arrays!
change the loop to:
For inx = 1 To Target.Count
and it should work just fine.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you
Dear Noorain Sir,
I am having some problem in the attached pivot.
I want a calculated field (count of name - count of absent) which is non-numeric
Please solve.
Thanks
N Pradhan
- Original Message -
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Thursday,
Save file as an xlsM file and enable macros and use
Option Explicit
Sub nodupesperitemSAS()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Cells(i, d) = Cells(i - 1, d) Then Rows(i - 1).Delete
Next i
End Sub
From: Neeraj Chauhan
Sent: Thursday, September 29, 2011 2:32
Haven’t followed this so
Send your file with a complete explanation and before/after examples to
dguille...@gmail.com
From: Mr excel
Sent: Thursday, September 29, 2011 4:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Macro 1:
Option
Hi Paul,
thank you again!!! It works perfectly:)
Best regards,
seba
On 29 sep., 15:32, Paul Schreiner schreiner_p...@att.net wrote:
Evidently, the Target array doesn't start at '0' like normal arrays!
change the loop to:
For inx = 1 To Target.Count
and it should work just fine.
Paul
Excel Experts,
I need to calculate the time differences between 11:30:00 AM and 11:37:00 AM
and show the 7 minutes in the decimal hour format.
Please see attached sample spreadsheet for the solution I need.
Thank you for your continuing Excel help.
John
--
=(D2-C2)*24
From: John A. Smith
Sent: Thursday, September 29, 2011 2:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time
Format
Excel Experts,
I need to calculate the time differences between 11:30:00 AM and 11:37:00
Hi dguillett,
Also give me meaning of r = Cells(Rows.Count, J).End(xlUp).Row
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
Hi dguillett,
I am a learner, could you please tell me meaning of r in
Range(J2:J r) in above code.
Thanks
Akhilesh Airen
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
I have data from two surveys. One survey was completed on 900 people
before a certain event happened, and then a second survey was
completed on a further 900 people after an event happened.
I need to calculate the % difference between the two whilst looking at
the demographics of the individuals.
(d2-c2)*24*60 ...change format to number
Regards
Chethan Kumar
On Fri, Sep 30, 2011 at 1:36 AM, dguillett1 dguille...@gmail.com wrote:
=(D2-C2)*24
*From:* John A. Smith johnasmit...@gmail.com
*Sent:* Thursday, September 29, 2011 2:55 PM
*To:* excel-macros@googlegroups.com
*Subject:*
Dear Paul,
please do the needful
thanks regds
ROHAN
On Wed, Sep 28, 2011 at 11:31 AM, Rohan Young rohan.j...@gmail.com wrote:
Dear Paul,
one more thing your indirect formula is not working in master sheet,
would u please explain
thanks regds
On Tue, Sep 27, 2011 at 6:50 PM, Paul
Dear Nalini,
See attached sheet if it help to u.
On Thu, Sep 29, 2011 at 6:23 PM, N Pradhan nalini.pradha...@gmail.comwrote:
**
Dear Noorain Sir,
I am having some problem in the attached pivot.
I want a calculated field (count of name - count of absent) which is
non-numeric
Please
Dear John,
For 7 Minute you can use..format
=TEXT(I21-H21,[h]:mm:ss)
for number format
use
(I21-H21) and paste in Custom FOrmat [h]:mm:ss
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Airen,
r = Cells(Rows.Count, J).End(xlUp).Row
it is use to find last non-blank row in J Column.
Searching Start from Excel End.
On Thu, Sep 29, 2011 at 7:35 PM, airen airen1...@gmail.com wrote:
Hi dguillett,
Also give me meaning of r = Cells(Rows.Count, J).End(xlUp).Row
Thanks
Dear Neeraj,
You can also use Data-Remove Duplicates in 2007 and Advance Filter to
remove duplicate.
with formula you can use..
=sumproduct(--($C$2:C2=c2))
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
Dear Anil,
Please use simple Macro
*Sub remove_duplicate()*
*Dim s As Range
Sheet1.Range(A2:A
Application.WorksheetFunction.CountA(Range(A:A))).Select
Selection.RemoveDuplicates 1
End Sub
*
--
Thanks regards,
Noorain Ansari
Dear all members
please help to solve the problem
Sanjib
-- Forwarded message --
From: Sanjib Chatterjee chatterjee.kolk...@gmail.com
Date: Fri, Sep 30, 2011 at 11:03 AM
Subject: $$Excel-Macros$$ date format in Excel
To: excel-macros excel-macros@googlegroups.com
Dear
I like
32 matches
Mail list logo