Making a macro for Excel

Desktop Apps — incorrectly specified categories?

1 USD

Client's review of cooperation with Igor B.

Making a macro for Excel

1 USD

The project is implemented. Pleased with cooperation. The executive on the communication, everything that was in the TZ realized quite quickly.
I am happy, thank you.

5.0

Aleksey Tttt

Reciprocal Feedback

7 November 2015

Freelancer's review of cooperation with Aleksey Tttt

Making a macro for Excel

1 USD

A great customer! Clear assignment, instant payment. Pleased with cooperation.

5.0

Project translated automatically. Log in or register, to view the original There is a macro: Private Sub Worksheet_Change(ByVal Target As Range) For Each cell In Target If Not Intersect(cell, Range("C2:O1000") Is Nothing Then With Range("B" & cell.Row) .Value = Date End With End If Next cell End Sub which automatically enters the date in the corresponding line of the column "B" when entering any value in a cell from the range C2:O1000 you need to assign it so that when data is removed or re-introduced the date does not enter again, i.e. The macro should not respond to the removal and if the date has already been inserted, then the macro has not reactivated it new. And you need to do if you extend the formula so that the macro does not react to it, does not enter the date.

Proposals 3 Rejected 1