Formula Assistance
Closed
MudRunner
Posts
1
Registration date
Wednesday 30 April 2014
Status
Member
Last seen
30 April 2014
-
30 Apr 2014 à 13:51
Blocked Profile - 30 Apr 2014 à 16:07
Blocked Profile - 30 Apr 2014 à 16:07
Related:
- Formula Assistance
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Spreadsheet formula - Guide
- Formula to calculate vat in excel - Guide
- Grade formula in excel marksheet - Guide
1 response
OK, I am going to guess that this isn't homework, so I will start you in the right direction, and we will learn some stuff along the way.
The following is modified from code pasted here:
https://ccm.net/faq/1117-excel-vba-detecting-changes-in-cell#q=detecting+change+on+worksheet&cur=1&url=%2F
We can modify it to be really simple like:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
Range("$C$1").Value = Now()
End If
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!
The following is modified from code pasted here:
https://ccm.net/faq/1117-excel-vba-detecting-changes-in-cell#q=detecting+change+on+worksheet&cur=1&url=%2F
We can modify it to be really simple like:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
Range("$C$1").Value = Now()
End If
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!
