Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change date formula to Value
I have a spreadsheet to record serial numbers already populated in column A
and the date the specific serial number was issued. The issuer puts a code in column C which automatically assigns a date in column E and some location details in columns F to H. What I need to do is run a macro which saves the file but changes column E to a value if column C is not blank. Column C can have gaps between rows. Any ideas would be greatly appreciated Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change date formula to Value
why don't you use a worksheet_Change function that when a date is entered in
column c todays date is automatically enetered in column E. Sub worksheet_change(ByVal Target As Range) For Each cell In Target If cell.Column = 3 Then cell.Offset(0, 2) = Date End If Next cell End Sub "Michael" wrote: I have a spreadsheet to record serial numbers already populated in column A and the date the specific serial number was issued. The issuer puts a code in column C which automatically assigns a date in column E and some location details in columns F to H. What I need to do is run a macro which saves the file but changes column E to a value if column C is not blank. Column C can have gaps between rows. Any ideas would be greatly appreciated Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change date formula to Value
Michael
This little macro will do that. HTH Otto Sub EValue() Dim rColC As Range Dim i As Range Set rColC = Range("C2", Range("C" & Rows.Count).End(xlUp)) For Each i In rColC If Not IsEmpty(i.Value) Then i.Offset(, 2).Copy i.Offset(, 2).PasteSpecial xlPasteValues End If Next i End Sub "Michael" wrote in message ... I have a spreadsheet to record serial numbers already populated in column A and the date the specific serial number was issued. The issuer puts a code in column C which automatically assigns a date in column E and some location details in columns F to H. What I need to do is run a macro which saves the file but changes column E to a value if column C is not blank. Column C can have gaps between rows. Any ideas would be greatly appreciated Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to change date to reduce bal | New Users to Excel | |||
what is the formula to change date of birth into age | Excel Discussion (Misc queries) | |||
How do i change the date formula | Setting up and Configuration of Excel | |||
I need a formula that change all date by putting in one date | Excel Worksheet Functions | |||
Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) |