Excel list help please :(

jeffreybrown · #5 05-03-2016, 03:31 PM

Code:

Can anyone help me with a formula to solve this please??

IMHO, a macro might be easier to work with as with a formula you would have to use a column other than A and then copy and paste.

This macro will look for the last row of column B and then apply the results from column A from the bottom up.

Code:

Sub FillRangeFromAbove()
    Dim LR As Long
    Dim i As Long
    LR = Range("B" & Rows.Count).End(xlUp).Row
    For i = LR To 2 Step -1
        If Range("A" & i - 1).Value = "" Then
            Range("A" & i - 1).Value = Range("A" & i).Value
        End If
    Next i
End Sub

If you are not familiar with macros, this might help...

http://www.rondebruin.nl/win/code.htm

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import list from Excel into drop-down list into word	ahw	Word VBA	43	02-28-2020 08:11 PM
Excel Combobox List	VBA-User	Excel Programming	4	01-07-2016 02:46 AM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data	Faldinio	Word VBA	7	10-19-2014 06:03 AM
How to export contact list to Excel	ksimmonds	Outlook	2	12-07-2011 09:33 PM
Searchable list in excel?	leahca	Excel	7	11-24-2011 04:44 AM