Hi All,

I have a Macro currently in use which auto generates the next number in a sequence:

Dim lastCell As Range
With Worksheets("Sheet2")
Set lastCell = .Cells(Rows.Count, "A").End(xlUp)
If lastCell.Value = "Request No" Then
lastCell(2, 1).Value = "LHR/BAW001"
Else
lastCell(2, 1).Value = Left(lastCell, 7) & Format(Right(lastCell, 3) + 1, "000")
End If
Worksheets("Sheet1").Range("B1").Value = lastCell(2, 1).Value
End With
End Sub

I would now like to add in the adjoining cells (column B & C) to the reference when generated on sheet 2 the user and date / time stamp. Can you help with this please?

Many thanks,
Gaz