How do I systematically do this?

[JayPee]

Using Excel07 ... I've got several thousands of lines like so:

A B C
1: joe blah1 date1
2: date2
3: bob blah2 date1
4: date2

i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3, and
so on ... can I do this systematically instead of manually cutting and
pasting?

 

[Kevin B]

Select all the cells in columns A & B from row 2 on down to the last row of
data.

Press F5 and click the SPECIAL command button.

Click the BLANKS option button and click the OK command button

All blank cells should now be selected.

Type an = sign to start the formula, press the Up arrow key on the cursor
pad and press <Ctrl> + <Enter> to enter the formula in all blank cells.

Now select all the data in columns A and B from row 2 to the last row of data

Press <Ctrl> + C to copy the selection, then right click on a selected cell,
select PASTE SPECIAL.

Click the VALUES option button and click OK

 

[Mike H]

hi,

Right click your sheet tab, view code and paste this in and run it

Sub fillemup()
Dim myrange As Range
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
Set myrange = Range("A1:A" & lastrow)
For Each c In myrange
If c.Offset(1, 0).Value = "" Then
c.Offset(1, 0).Value = c.Value
c.Offset(1, 1).Value = c.Offset(, 1).Value
End If
Next
End Sub

Mike

 

[JayPee]

Thanks! That worked.

Select all the cells in columns A & B from row 2 on down to the last row of
data.

Press F5 and click the SPECIAL command button.

Click the BLANKS option button and click the OK command button

All blank cells should now be selected.

Type an = sign to start the formula, press the Up arrow key on the cursor
pad and press <Ctrl> + <Enter> to enter the formula in all blank cells.

Now select all the data in columns A and B from row 2 to the last row of data

Press <Ctrl> + C to copy the selection, then right click on a selected cell,
select PASTE SPECIAL.

Click the VALUES option button and click OK