put this code into Sheet1's Module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = 1 Then
If Target.Value <> "" Then
If Target.Column = 3 And Target.Row > 1 Then
Target(1, -1) = Format(Now, "dd-mmm- hh:mm:ss")
Target(1, 0) = Application.UserName
End If
End If
End I
I have a worksheet in which I'd like to auto insert the date/time into
a cell in column A and the username into column B, if data is entered
or changed in the same row in column C.
What would be the best way to accomplish this ?
Thanks
Jeff
--
--
I posted a reply that I do not read ...
I had a formula in Italian and translated into English forgetting to
change the separator to rewrite the arguments correctly ...
then ... try:
=SUM(N(FREQUENCY(IF(B1:B10>0,MATCH(A1:A10,A1:A10,0)),MATCH(A1:A10,A1:A10,0))>0))
regards
r
On 14 Set, 19:25, Di
Hi Dilip,
I am also having same problem but slightly different from the below
even i was also following same logic for getting the count of unique
values, but the problem is have 5 pivots one down the other when i
refresh every month it will give some popup "asking do you want to
replace the conte
try this function:
=SUM(N(FREQUENCY(IF(B1:B15<>0,MATCH(A1:A15;A1:A15;0)),MATCH(A1:A15;A1:A15;0))>0))
CTRL+SHIFT+ENTER:
regards
r
On 14 Set, 19:25, Dilip Pandey wrote:
> Hi Manoj,
>
> Please find the solution attached with this email.
>
> Note:- Going forward please mark Group as well so tha
Hi Paul,
Thanks for confirming my suspicion.
Skidooo
--
--
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 @ htt
I have the folowing macro set up to print but in column i I have a
formula to look at column H o- if data in H, show comment in I. But,
when I have the formula copied down to row 2000, my print macro pics
up the formula as data and prints all rows. How to I exclude the
formula in I from the macro
I have the following macro that I use to print only rows with data (A1
to up to I2000 possible).
The only column that has a formula is the I colunm. Without the
formula this macro works but
I do not know where to put in the exclusion to not look at the formula
in column I. Note that the formula
send the file to me
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
On 14 September 2010 22:56, Robert wrote:
> I created a file with a VB macro long time ago for the final at the
> college and now i can't figure out what are the passwords i used
Thanks Sir, problem solved ...though the array seems complex for me to
understand...
Salute to Excel-Macros
With Best Regards.
On 9/15/10, ashish koul wrote:
>
> check the attachment see if it helps
>
> On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
>
>> Dear Sirs,
>>
>> I w
Thanks Paul
Dave.
Date: Wed, 15 Sep 2010 05:02:08 -0700
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Need most recent date
To: excel-macros@googlegroups.com
alternately, you could sort your data by invoice#,date (descending)
then do a vlookup.
It would pick the first date,
Hi,
Please see the attached for a possible solution.
Regards - Dave.
On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
Dear Sirs,
I want to capture data which employees are on leave as on date and
since when ?
Formula please…..
(Format enclosed)
NAME01-Sep 02-Sep 03-Sep 04-Sep 0
check the attachment see if it helps
On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
> Dear Sirs,
>
> I want to capture data which employees are on leave as on date and
> since when ?
> Formula please…..
>
> (Format enclosed)
>
> NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Se
YES!
Excel 2007 especially...
Are you perhaps using the .xlsx format?
With Excel 2007, Microsoft attempted to incorporate some level
of protection against twisted individuals that seek to utilize
Excel's programming abilities to spread viruses.
What they came up with is different file extensions
alternately, you could sort your data by invoice#,date (descending)
then do a vlookup.
It would pick the first date, which would be the most recent.
I like Dave's suggestion...
It's interesting because it takes advantage of the fact that
using (Othersheet!A2:A100=A2) is a logical test that
returns
Your problem:
You have a formula that inserts the current date:
=IF(B3="","",TODAY())
But of course, every day, the date changes.
You want the date to update ONCE, then stay fixed.
What sort of solution are you looking for?
something "automatic"?
or "manual"?
You could:
manually copy/paste spec
Hi Shimmy
Kindly go through the below mention link
http://www.ehow.com/how_4700901_password-protect-excel.html
On Wed, Sep 15, 2010 at 1:02 PM, Shimmy wrote:
> morning guys!
> I have been using Offic 2007 since 2008, and still until today I am
> having the same proble I had 2 years ago! Could
morning guys!
I have been using Offic 2007 since 2008, and still until today I am
having the same proble I had 2 years ago! Could some one help on how
to put password security on EXCEL and WORD using Office 2007.
Feel free to share the knowledge if you can, I really need this guys.
Regards
Shim
Dear Sir,
Problem partially solved. Result Cell should be blank if an employee is
already joined and now working.I have to find out continuous leave of an
employee from a particular date till today.Also highlight with colour thro.
conditional formating.
Enclosed file ...
Regards.
On 9/14/10, as
Hi David.
If you are not using 2007 or 2010 Excel, you are wasting your time so
then your best hope in in PowerPoint as its easier to assign the
various rows of data different shadings of the same color.
Also make sure the thickness of the lines are enough so that they are
touching.
I hope this
20 matches
Mail list logo
