VBA command to copy the last cell

[mohan_rajun]

Hi,

I need a VBA command to copy the cells to the end of the row.

For example from the attached excel sheet, my data ends in cell C52 & I need the data to be copied from A51 & B51 till the end of the row using fill down.

I have attached my requirements in sheet "Results".

[DonkeyOte]

Perhaps you mean:

Please Login or Register  to view this content.

[mohan_rajun]

Hi,

If I use your VBA to my part of macro completed, it's not picking the data.

I have attached the same data which I had provided earlier, with my macro for background results.

I have also attached an excel sheet with the Input data.

[mohan_rajun]

Hello,

Can someone help me out for the query ?

[DonkeyOte]

The code snippet you were given does what you ask (even on your sample when run separately).

I confess I've not the time to go through the rest of your code...