Copy and Paste from previous Row

Please refer to attached excel sheet...

I need a VBA Macro to do the following:

Column B, C and D have data..
Some rows have missing data in Column B and C.
I need those cell filled with previous rows data until next filled data is reached.

Example:

Cell B45 thru C65 should be filled with same data as in B44:C45
Cell B67 thru C 82 should be filled with same data as in B66:C66
.
.
.
Cell B252 thru C252 should be filled with same data as in B251:C251
.
.
and so on until all done....

Please refer to original and Manually done sheet for understanding..

Let me know if you have any questions..

Thank you,

Riz Momin

Hi,

Paste the following code to a module.

Please Login or Register  to view this content.

hi Riz,

This can be done quite quickly without a macro by following the below steps:

- select the used range that requires fixing
- press [F5], "Special"
- choose "Blanks", [ok]
- type "=" & press the [up arrow]
- press [ctrl + enter]
This will leave the cells containing formulae.


The below macro uses the same approach but also converts the formulae to values:

Please Login or Register  to view this content.

If your selected range is likely to have more than 8192 non-contiguous cells you'll need to modify the macro slightly...



hth
Rob

edit: added code tags

Pleased we could help - thanks for the feedback :-)

Rob