Need help w/ auto update of current date in a specific cell after edit [SOLVED]

[ryan4646]

i have a sheet which i have to update data everyday.after updating i have to update the last modified date as well. the datas are in G,H,I,J Column. if i update any of this column the last modification date in M3has to be auto changed with the current date.


can anybody help me out how to do that ? i am uploading the file here


http://www.mediafire.com/download/n0710y8s8pqntpt/DATE_HELP.xls

 

[Hui]

Ryan


you could try this piece of VBA Code

[pre]

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("G6:J9"), Target) Is Nothing Then Exit Sub
ActiveSheet.Range("M3").Value = Now
End Sub

[/pre]

Copy and paste the text in a Worksheet Code Module of Sheet 1 in VBA

 

[ryan4646]

hi Hui,


no, its not happening

 

[ryan4646]

hi all


it would be very appreciated if any formula can come out.


dave...?

 

[ryan4646]

 

[Debraj]

Hi Ryan!


* Two Things I need to confirm on behalf og HUI..

1> You have to paste the code in (Right click on Sheet Name (Sheet1) and click View Code).. After paste.. please check if in top of the Code area's two section are automatically changed to "Worksheet" Module & "Change" Event..


2> In Sheet1.. updation of values in G6:J9.. should be done manually.. (No Cut-paste) or Formula..


then, Please let us know.. if you are still facing same problem..


Regards,

Deb

 

[SirJB7]

Hi, ryan4646!


Besides the correct and almost immediate answers that Hui & Debraj Roy posted and regarding your apparently hurry, perhaps you'd want to read the green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).


If you had done so you surely should have noticed this:


"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."


"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."


"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."


Regards!

 

[ryan4646]

hi dev and hui,


it is solved. Now it is working. so many thanks.


hi sirJB7,


with so much respect to you, sorry that i didnt introduce myself but i didnt find any urgent/important word in my writting.i will follow it in future thanks.