PFA...
On Mon, Oct 26, 2015 at 4:02 PM, Pravin Gunjal wrote:
> Dear Friends
>
> I have attached an excel file in which I have used macro to get "Created
> by" field automatically once the values are entered in column N (Qty).
> Likewise I want the last column (Entry Date) to
I'd use:Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim cell As Range
If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing Then
For Each cell In Target
If cell.Value <> "" Then
cell.Offset(0, 1).Value = Application.UserName
Dear Friends
I have attached an excel file in which I have used macro to get "Created
by" field automatically once the values are entered in column N (Qty).
Likewise I want the last column (Entry Date) to be updated as current date,
as and when the column N gets entered.
I have made one manual
I think I see your issue.Your example has (4) products (Product A, B, C, D)Your
formula "manually" adds the Unit volumes for eachand the costs for each.
But if you have more Products, this calculation becomes harder to manage.
You want a sum of the Unit volume of ALL products, not EACH product.
Dear Colleagues,
I have a race after 3 days and I need an excel sheet with a stop watch timer
to record all racers results once I entered the racer number..
as below sheet exactly.
https://www.youtube.com/watch?v=PMQiStqrNwg
I appreciate your prompt help with needed excel sheet.
Regards
Thank You Sir!
Gary
On Friday, October 23, 2015 at 2:47:17 PM UTC-4, Gary Dinges wrote:
> I will start by saying I did search group looking for answer to my issue,
> but didn't find, or understand what I needed.
>
> I am working on a form that will be distributed to remote plant locations.
>