Repeating a cell value in Excel

May 14

This is a request I have had a number of times.. In excel you want to copy the value of the cell above your current position if your current position is blank

To start this macro click on a row 2 or lower with a value in the cell above, change the value of x in the macro to the number of lines you want ot repeat

Sub Macro1()
' change the value of x to the number of lines to fill
Dim I, x
Do While I < x
    If ActiveCell.Value = "" Then
        ActiveCell.Offset(-1, 0).Select
        ActiveCell.Offset(1, 0).Select
    End If
    ActiveCell.Offset(1, 0).Select
    I = I + 1
End Sub

Time for a Lift

May 13

Saw this on youtube and thought you might enjoy it

Useful Calendar Reports in Access

May 09

I used some of the calendar reports on this site when developing a scheduling system for a trucking company

If you need some help on a project drop leave a comment on the post and I will reply.