Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>For my example, I'm using cell <code>G4</code> as the one that will be updated by your coworker. You have to have some way to persist the original value of <code>G4</code> in order to tell when it's been changed. The easy way to do this is to pick some cell that is out of sight of the user and store the number there so you can reference it later. Here I've chosen cell <code>AA1</code>. The following code must be added specifically to <code>Sheet2</code> since it needs to monitor the changed events on that sheet only so it can fire when <code>G4</code> is updated. </p> <pre><code>Private Sub Worksheet_Change(ByVal Target As Range) If Range("G4") &lt;&gt; Range("AA1") Then Dim lastRow As Long Range("AA1") = Range("G4") lastRow = Worksheets("Sheet1").UsedRange.Rows.Count Worksheets("Sheet1").Cells(lastRow + 1, 1).Value = Date Worksheets("Sheet1").Cells(lastRow + 1, 2).Value = Range("AA1") End If End Sub </code></pre> <p>Keep in mind that this is a very "quick and dirty" approach for this task, as there are no error handlers or much flexibility in the way it works. </p> <hr> <p><strong>EDIT --</strong></p> <p>One other method you could use is referenced here, and can simply check to see if a given cell has changed, without verifying the difference in value. </p> <pre><code> Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Range("G4"), Range(Target.Address)) Is Nothing Then Dim lastRow As Long Range("AA1") = Range("G4") lastRow = Worksheets("Sheet1").UsedRange.Rows.Count Worksheets("Sheet1").Cells(lastRow + 1, 1).Value = Date Worksheets("Sheet1").Cells(lastRow + 1, 2).Value = Range("AA1") End If End Sub </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POcapture data from a cell and paste the value into another cell on a different worksheet
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UStechturtle
    1. UStechturtle
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI appreciate your help. Perhaps I'm doing something wrong to get this to work. I'm not understanding how putting the value of g4 in aa1 does anything. When g4 changes so will aa1 if in the AA1 cell I do =G4. That seems like an extra step. What I want to do is capture G4 when she changes it. I think this isn't worth the time i'm vesting to be honest. It really does seem to dirty and has too much chance of error.
      singulars
      1. PO
      1. USdonviti
    2. COPutting the value in AA1 is so you have a reference to the old value once she changes it. You don't want to update the page every time something changes *unless* it is changed on G4. It checks to see if G4 and AA1 are no longer the same, and then runs the code if they are not. You could do it by [explicitly checking which cells are changed](http://support.microsoft.com/kb/213612) but I think that's a more complicated way to do it.
      singulars
      1. PO
      1. UStechturtle
    3. COI'm missing how the script will see the change if the cells equal the same and AA1 references G4. I think that's where I am hung up
      singulars
      1. PO
      1. USdonviti
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload