Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste
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!
|