Need help with Macro to autofill formula in Column B based on length of Column A

Hi, sorry i am new to VBA Coding....just started today. I need help writing a macro that will allow me to take the formula I have entered in B1 and autofill it down based on the length of column A. (i.e. if the cells A1-A10 have data, i need to be able to copy the formula i have entered in B1 from B1-B10. The issue i am facing is that the length of column A will vary from file to file. So one file might have 20 lines of data, while another might have 200 and i need the macro to work on both).

Any help would be much appreciated!
Thank you!!!

Hi,
Here's one way to do it :

Please Login or Register  to view this content.

thank you! worked perfectly!!