Copy the data to the Blank Cell

Data Set:

Around 200 rows. and about 25 columns. Each filled up row is followed by one blank row.

I want to copy data from filled up rows to the blank rows.. and only for column V, W & X

is it posible to do??

I have done till filteration and copying only V3:X3 but i can not do it for all the blank cells..

can anyone help with the loop>

Hi

Try this:

Please Login or Register  to view this content.

Cheers
Shaun