I have a spreadsheet for shipping products.
When I enter the amount shipped, I would like for that days date to appear in the next column and not change unless I re enter the quantity shipped. I used a formula but the date updates every day. I want it to show the date shipped.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
Range("$C$1").Value = Now()
In the above example, the shipping cell is address of B1. IF B1 is being acted upon, then the timestamp is written in the next cell over.
What will happen from here, is get that to work, then we will expand to check all of your shipping boxes, figure out which one is being acted on, we will Add 1 to the cell location, and past in the date dynamically based on which row is being acted on.
So let us know when you get the above implemented, then we will grow on it!