Maybe you could try this:

Select A2:F### (through the last used row)
Edit|Goto|special|blanks
Notice that the selection is now just those blank cells from the original
selection.

Now type the = sign and hit the uparrow
Hit ctrl-enter to fill all those empty cells with a formula that points to the
value above.

Debra Dalgleish has some more instructions:
http://contextures.com/xlDataEntry02.html



JenIT wrote:

I am attempting to take data that looks like this.

A B C D E F
125.06 3.12 26.05 2/5/2007 7/1/2007 0.2
0.2
0.2
Look for if there is any data in Col F (data is variable) and Col E is
blank then copy the previous Row's data A-E and paste it in the next
row. So it then looks like this.
A B C D E F
125.06 3.12 26.05 2/5/2007 7/1/2007 0.2
125.06 3.12 26.05 2/5/2007 7/1/2007 0.2
125.06 3.12 26.05 2/5/2007 7/1/2007 0.2

Any help with this would be great!

--

Dave Peterson