How do I tackle this problem?
 

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

A B C
row1 joe blah1 date1
row2 date2
row3 bob blah2 date1
row4 date2

i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3, and
so on ...

How do I tackle this problem?
 

One possible way, select the ranges in A and B where you need to the
previous
entry copied down so in your posted example select A1:B4, press F5, click
special
and select blanks, then type = and press up arrow once and finally press
ctrl + enter

After confirming it went OK select the range again and copy and paste
special
as values in place to remove the equal sign (aka formula)



--


Regards,


Peo Sjoblom

"JayPee" wrote in message
...
Using Excel07 ... I've got several thousands of lines like so:

A B C
row1 joe blah1 date1
row2 date2
row3 bob blah2 date1
row4 date2

i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3,
and
so on ...

How do I tackle this problem?
 

Forgot one thing

One possible way, select the ranges in A and B where you need to the
previous entry copied down so in your posted example select A1:B4, press F5,
click
special and select blanks, click OK to select the blanks
then type = and press up arrow once and finally press
ctrl + enter




....
One possible way, select the ranges in A and B where you need to the
previous
entry copied down so in your posted example select A1:B4, press F5, click
special
and select blanks, then type = and press up arrow once and finally press
ctrl + enter

After confirming it went OK select the range again and copy and paste
special
as values in place to remove the equal sign (aka formula)



--


Regards,


Peo Sjoblom

"JayPee" wrote in message
...
Using Excel07 ... I've got several thousands of lines like so:

A B C
row1 joe blah1 date1
row2 date2
row3 bob blah2 date1
row4 date2

i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3,
and
so on ...