title: Log file in Excel
body: <p>I'm trying to create a log file where a change to a cell will be recorded with a date stamp.
  The log file needs to record from few spreadsheets.
  I've managed to get a code that records the change and I have pasted it to every spreadsheet.
  Now the issue is that the recorded data from different spreadsheets is in one column and I'm not able to say from which spreadsheet it came from.<br />
  How to adjust the following code to move the recorded data from column ABC to EFG ?
  Additionally, how to add a record of a specific cell lets say D4?
  I'm completely new in this stuff so go easy on me please.</p>
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  Dim strAddress As String
  Dim val
  Dim dtmTime As Date
  Dim Rw As Long
  
  If Intersect(Target, Range(&quot;A1:M1000&quot;)) Is Nothing Then Exit Sub
     'change range to suit
  dtmTime = Now()
  val = Target.Value
  strAddress = Target.Address
  
  Rw = Sheets(&quot;Log Sheet&quot;).Range(&quot;A&quot; &amp; Rows.Count).End(xlUp).Row + 1
  With Sheets(&quot;Log Sheet&quot;)
      .Cells(Rw, 1) = strAddress
      .Cells(Rw, 2) = val
      .Cells(Rw, 3) = dtmTime
  End With
  </code></pre>
  <p>End Sub</p>