Identify the last filled row in Column A and then drag formula in Column B till the same

Hi Team,

I need help in buliding a macro so that the macro identifies the last filled row in COlumn A and then drags the formula in column B to the same row in Column B.

For example - Column A is filled till A50, so the macro should drag the formula in Column B2 to B50. and If column A is now filled till A51, the macro should drag B2 to B51.

If anyone can help ASAP as I have to deliver a report on an urgent basis.

Thanks every1.

Hi try this

Please Login or Register  to view this content.

Hi Tom,

Thanks for your swift response. I tried the above however, It doesnt work.. It seems its because of the example I gave above.. I had given the above example just to simplify my concern..

Everything remains the same as in my example just that the formula is in column AK.

Can you help??

change "B2" into "AK2" or send the example if it will not work

Hi Tom,

Thanks for your swift and accurate solution.. Saved my day..

You deserved a reputation increase.

Have a nice day :-)